I can't add any more posts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a database over my movies, and now I can't add any more post. Its
quite a big database with lots of pictures. The database is now 1.99 gb
large. Is this the problem and can it be fixed?
 
Hi,

You are hitting the limit of how big Access Databases will go.

If you have added things & deleted over time, you could try compacting. With
a DB that size I do that when you don't want to use your PC for a while.

Regards,

Chris.
 
Additionally, you might want to link to the picture files rather than
embedding them in the database - this would most likely drastically decrease
the file size of the mdb (you would still need to compact and repair to see
the file size go down after moving the images out of the database)
 

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

Can't add more posts 2
Add autonumber to a large table? 0
Is it possible to increase Access 2000 Database to more than 2G? 5
Database Problems 5
Not accept a value of 0 in a currency field. 3
Database with lots of pictures 9
Compact and Repair Advice 14
linking tables and relationships 3

Back
Top