mdb file limitation

F

Frédéric

I work on Access 2000... and i want to know what is the
maximum size of an MDB file...

For information, i word on an mdb file of 1,9 Go
 
T

Tony Toews

Frédéric said:
I work on Access 2000... and i want to know what is the
maximum size of an MDB file...

For information, i word on an mdb file of 1,9 Go
Click to expand...

That's very large indeed. Are you storing graphics in the MDB?

You don't want to embed graphics into a table as this causes
significantly bloating of the database. Frequently about one Mb per
graphic.

For more info see the Image Handling Tips page at my website.
http:\\www.granite.ab.ca\access\imagehandling.htm

Tonhy
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access files do not open by double click if someone open it first 0
Before starting Access 0
Recovery of .mdb file 8
Cannot open .mdb file by double click when another user has opened 5
Difficulty with compatibility mode and Track Changes 2
Permissions / Closing MDB left open 1
mdb format and Access 2007 3

Top