General :: Is It Possible To Get File Size Of Access Objects

Feb 24, 2014

Is it possible (using the menu or VBA code) to find out the size of the objects in an Access database file?For example if the .accdb file is 300Mb, is there any way of comparing the size of the numerous tables/forms/reports/queries etc, that make up the database?(I know that if I created a new access file and imported the objects from the working database that could give an indication but that would be quite a repetitive process).

View Replies


ADVERTISEMENT

General :: How To Set Size For PDF File To Open Through Access

Apr 3, 2014

when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want.

View 2 Replies View Related

Access Database File Size

Jan 23, 2007

I had a massive Access file of almost a GB in size. and I deleted all records off the tables hoping it would shrink and my purpose was to have the tables alone in their structures. However despite deleting all records, the database file size seems to stay the same. anybody knows why this is so? I don't think we can "commit" changes to databases done in access as it is done in other databases. anybody knows why this is so?

View 3 Replies View Related

File Size Of Access Databse Decreases? Random

Feb 14, 2008

I have been using access 2003 at my work place.

When I bring back my access 2003 project from work back home, i open the project at home, I am using access 2002 or 2000 format.

Then I notice if I save a copy of my work using access 2002, while initially using an access 2003 database, the file size decresaseas dramatically, from like 3mb to 800 kb?

any reason why?

No data seems 2 be lost.

Cheers!

View 4 Replies View Related

Is Access 2010 Performance Based On Records In A Table Or File Size

Jun 29, 2014

I have an Access 2010 database .. and will be adding about 25,000 records a day to it. So it will get pretty big fast .. so 9 million a year. Is this too big for Access ?? Or is it more a issue of file size .. I know that Access 2010 can go up to 2 GB. I am interested in how I can maximize my performance and not have the database.The data is as follows .. One table. The other tables will be small, just this one will increase in size really.

Id .. Autonumber (primary key)
When .. datetime
Radio .. integer (indexed .. w duplicates)
Group .. integer (indexed .. w duplicates)
Type .. text 4
TransType .. text 2

I am considering a purge of old records if needed .. like only keeping the most previous 5 million records or some reasonable number. Like .. then I would think I should try to number my records backwards (using long int rather than autonumber and number records backwards on import) .. ie record 1 would be the most recent one and only keep the last X number of them for performance reasons.

View 8 Replies View Related

General :: Difference In Size Between Actual Access Database And Its Backup

Aug 19, 2014

I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.

The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.

But I don't know why there is a difference in size?

Some of the tables in the database are linked from MS SQL Server.

View 4 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

General :: Import JPG Format Picture Size Into ACCESS Individual Input Cells

Sep 3, 2013

I saw a demo that the user could copy and paste a JPG format file physically to ACCESS, and then something happened, and ACCESS could read the JPG length and width size (e.g. 1.3 meter length and 1.15 meter width) into 2 individual ACCESS cells which is acted the same as user input to that 2 clells.

View 14 Replies View Related

File Size

Mar 16, 2005

hi all,

on a form i have 2 fields
one for import a file with the filedialog
2e for the size of that file
how can i have te size from the file in that field
can someone help me with that code

thanks

View 1 Replies View Related

Retrieving File Size

Jan 17, 2006

Hello all,

I would like, from a form, to get the file size of a particular file.

I would really like something like: FileSize("C: estfile.exe")


I am sure I have had something like this before, but cannot for the life of me find the answer I originally got!

Thanks!

View 3 Replies View Related

MDE File Size Question.

May 15, 2006

Hi, I was recently searching on the site for information leading to the compiling of an .exe file from the Access database. What I come to realize is that this is not possible. I was led to the MS Visual Studio 2005 for MS office studio and the MS Office Access 2003 Developer Extensions for it to use the Access runtime (As I came to understand) without having to install Access. If I am at all wrong up to this point please let me know. I was just wondering about that for clarification, my real concern is regarding the size of my database and the problem making it into an MDE.

As of now, my program is at roughly 30 mb, which I did not think was too incredibly large. However, Access will not allow me to create the MDE file. Where I think my problem is lying is that I have images scanned into the DB and then text boxes on top allowing me to essentially type a form and print it out.

Is there a better, more size efficient way of doing this? I have a hunch that it is the images that are not allowing for the MDE export, but I did not think they were all too large in size. If anyone has any comments that may help I would be very appreciative. Thanks in advance.


-Bob

View 5 Replies View Related

MDB File Size Keeps Increazing

Jul 17, 2006

Hi all,

I have developed a Access program which import excel tables into the the database and queries some data and writes it into an excel file...

The problem I am having is that after the program is loaded... the file size of my mdb file increase by more than 3 mb..

I tried deleting all the objects in the file.. and the size doesnt reduce at all,
When I import tables, I delete the previous one.. so I don't think it would be that...

The only thing I think the problem mite be is the life line of the variables..

Is it that after I run the program... the Variables stays there and ocupies space...??

afaik, the variables "dies" after the program is finished loading....
if not, is there a way to "kill" the variable at the end of the program?
so far, at the end of the program, I have set my objects = nothing.. to release them... but doesnt seem to help at all

any idea on what this problem mite be??

Thanks in advance..

View 2 Replies View Related

.mdb File Size Growing

Aug 17, 2007

Hi,
i am new to access. Anyone know why my .mdb file size Growing. Even when i delete the data from table and done with the compact and repair. i am doing my first small project with one table and 10 querys and 5 repots. each time i edit the query or report the file the size goes on increasing.
i have not more then 100 records in my database. i only edit my records when ever i edit my records .mdb file size grows so any one could help me to make it constant.
plz help

View 11 Replies View Related

DB File Size Blow Out

Oct 2, 2007

Yesterday my DB was 5MB. Today its 50MB. I haven't embeded any images etc... I can't see any reason why the DB would expand like this. The only thing I can think of is that perhaps there is a variable somewhere that allocates memory. What should I be looking for??

Any ideas are much appreciated.

View 6 Replies View Related

General :: Two Divisions But One Set Of Database Objects?

Dec 4, 2012

I'm using Access 2007. I have designed a database for one of a two division set up. All of the raw data in the tables is similar yet there is one unique identifier for the two divisions. Let's call it DivID, four characters in length.

To keep the maintenance simple I want to have one set of forms, queries and reports. I do not want to duplicate all of these. To the user they will only see one set of the menus, which will show all of the necessary sub-menus.

The first or main menu will have two buttons, Division A and Division B. The user simply clicks on the appropriate division button, and off they go. I'm thinking that it would be easiest for me if the DivID is stored after they click on their division button, and this value is used for any form or report that they run afterwards. Also, this DivID value would generate custom headers at each menu and submenu to confirm which division they chose.

View 5 Replies View Related

General :: Greyed Out Objects In Database

Sep 23, 2013

I have greyed out objects in my Access database. I didn't create them and don't know what they are. I tried to delete them but couldn't. Why did they come to my database -or they were already there but now they are appeared- and how can I get rid of them?

View 3 Replies View Related

File Size To Lare For VPN Client

Jun 24, 2006

Hi

I have created a db and am having serious problems, the size of the complete db is 3mb, and when split its 500k, the trouble I am having is that when putting the db on the network server and you try and open it based from home it takes so long for both the full db and the split.

The main db has one page that all staff need to see and have a quick response when opening on VPN client.
The form I want to open has a combo box that lets the employee select the company and all the information updates on the form.

I tried making a page in acces to do the same thing but having problems

Is this possible what I am trying to do or is there an easy faster option.

Thanks for your help

View 8 Replies View Related

General :: Unable To View Design Of Any Objects

Oct 4, 2012

I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of any objects. How do I enable the menu items?

View 1 Replies View Related

General :: New Objects Created Don't Appear In Navigation Pane

Oct 30, 2013

I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new database container, decompiled, compact & repair, and nothing works until the I delete some objects (forms, reports, queries, etc).

New objects created don't appear in the navigation pane until I close and re-open. Also, changing a query type from select to append doesn't result in the icon changing in the navigation pane.Code seems to run fine and everything else appears OK, but I really can't continue development until this issue is resolved. I fear continued development may lead to further corruption.after 20 years, this application has grown, I use a variety of techniques to get the size of the application. Currently:

1. 201,200 lines of code in 910 modules, reports and forms.
2. 544 forms
3. 328 reports
4. 3,617 queries (yes, I know, but it's so much work)
5. 450 tables (about half are linked)

I always thought, without thinking too deeply, that the number of objects in the spec refers to the number of reports, forms, modules, etc. But, now I'm wondering, do they also mean all the controls on the forms, and or the fields in the tables? What do they mean by objects.

I used Point Limited's translation modules recently to extract all the label and caption text for a French language translation project and it pulled out something like 21,000 individual controls, and, combined with this issue, I'm beginning to wonder...

View 5 Replies View Related

General :: Hyperlinks - Linking To Objects In Database

Sep 24, 2012

I have Access 2007 and I use to be able to Hyperlink to an object in my database 9no upgrade0 But suddenly this option is not available. What can I do?

View 4 Replies View Related

General :: Can't Delete Or Paste Database Objects

Nov 1, 2013

I just upgraded to Access 2010. I can't delete or paste database objects in the table, form, query lists, etc.. Is there a setting that allows this?

View 6 Replies View Related

MDE File Size Growing And Query Rewritting Itself

Aug 29, 2005

I have a strange issue. First off I have a front end in Access 2000 as a MDE file linked to a mdb data file.

Issue number 1: The MDE file almost doubles in size daily. Yes, the mde file not mdb (it grows slowly and expectedly as data is added and deleted) . I expected the MDE file to stay a static size. Is this normal, what causes this?

Issue number 2: I had on 3 occasions a query in the mde file suddenly pop up with a ”cannot repeat table name ‘Nameoftable’ in FROM clause”. I go into the mde file, SQL query view and delete the extra table name and all is fine for awhile. After the second time I did away with that quey and rewrote the query for my form a different way. It’s come back once again now for anther table. Has anyone heard of Access doing this?

I also note that the modified date of the file keeps changing. I am wondering if someone is tampering. My client that has this software is very naïve.

The MS site has no information regarding either behaviour.

Any ideas?

Jim

View 2 Replies View Related

Return Size Of A File In Form Text Box

Feb 17, 2005

A quick question that I'm sure one of you guys will be able to answer without any trouble, but I'm having difficulty with...

I have a form on which I would like to have a text box which returns the size of a file on my PC. The file path will not change.

Any ideas would be appreciated.

Thanks in advance.

View 1 Replies View Related

Reached Database Maximum File Size

Aug 27, 2004

I have some databases that I am importing data into but the records are so large (over 4 to 6 million) that they are making the file reached the 2 gig maximum.

Questions:

1) I have the imput tables broken down in to thirds of a month (i.e. Day 1 to Day 10, Day 11 to Day 20, Day 21 to Day 31) so what I was thinking is that there might be a way to just like three different databases together or four and have one be the master puller of the other three?

2) Currently, I have reports and queries that pull from one large table. So how would I set up the query reports etc. to pull from all three databases into one reports or query. Or is this not possible.


If you think of a better way to arrange or work around this problem then I am surely open to suggestions.

Thanks,
beachdude

View 5 Replies View Related

Emailing A Table Increases File Size

Apr 4, 2006

Hi,

I am trying to send a "EMP" table in an excel format using "SendObject". User clicks the "Send Mail" button to email the table in excel file. The user then clicks on the "Exit" button to exit. This wipes out the data in the table "EMP" as was expected. Every thing goes fine..... but the size of my database increases by more than 100 MB. (Note that the table in the data has been deleted & the data is around 59 MB).

Any suggestions on what could be causing this increase in file size.

Thx in advance,

Jatz

View 5 Replies View Related

General :: How To Store PDF File In MS Access

Jul 6, 2013

how could I store files such as PDF inside MS access.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved