Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MAXIMUM DATABASE SIZE?

Status
Not open for further replies.
VBACT

VBACT

IS-IT--Management
Dec 4, 2002
24
US
I have often been told that an ACCESS db will stop functioning at about 2.0gb. Is this true?

Would appreciate any help with this
 
Sort by date Sort by votes
Yep
it will stop or give errors
Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong
 
Upvote 0 Downvote
Access 97, which I use, will only go to 1 gb.

You can get around it by using linked tables, so your database can actually get much larger.

Have you compacted your database regularly? If not, you'll find that will reduce the size significantly.

 
Upvote 0 Downvote
Thanks. If one of the linked databases contains only images, do you have any suggestions for reducing the size?

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Question
switch between two open database
Replies
12
Views
535
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
841
grnzbra
grnzbra
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
264
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
305
dhookom
dhookom
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
252
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top