Database size - limit 1

[101287]

Is there any way to check the database base size? The problem that I'm having is that I'm exporting an excel file daily and whenever the databse get to 2,095, 108 kb the loading start abending (not working) because the size.

Is there any way that I can check the database base before starting the uploading?

Guidance will be helpfull.

Luis

 

[Hap007]

Hi,

The size limit for an Access 97 mdb is 1 gig
The size limit for an Access 2000 and later mdb is 2 gig

You must remember that access creates temporary spaces, so you would never want your database to actually reach the limit or it will surely fail.

If you are approaching these limits, you might want to consider creating a SQL backend to hold the data.

Also, if you are close to the limits, then you should be compacting your database on a regular basis.

A different approach might be to create a seperate Access database and import your Excel data into that db and then link to the newly imported data.

Final suggestion, just link to the Excel data and never actually import.

All suggestions have pros and cons.

Hope this helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[101287]

Do you know if there is a way with VBA that I can determine the size of the database? If I'm able to determine the size then I can develop code to back up and compact the database.

Please advise.

 

[PHV]

A starting point:

MsgBox FileLen(CurrentDB.Name)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886