Can't add more posts

[Guest]

I have made a database of my movies, Its quite large (1.99 gb) with lots of
pictures. It got a few tables where one now consists of 2661 posts. Now I
can't add any more posts. Is the problem that it's too big and in that case
what can I do? I still have lots of movies to add
thnx in advance

 

[Rick B]

the limit is 2 gb.

If you are storing photos IN your database, then that is the problem.

Please review previous posts on the topic and you will see that it is
recommended that you link to photos and not store the actual photo in your
table.

 

[Wayne Morgan]

The file size limit is 2GB.

Options:
1) Have you done a Compact and Repair? On a file that size, make a copy of
it before you try this in case it doesn't work. If you can't compact it,
create a new file and import everything from the old file into the new one.

2) See this link for a more efficient way to handle pictures.
http://www.granite.ab.ca/access/imagehandling.htm

3) Split the file into a front-end and back-ends. This will put the table(s)
into other file(s). You would then link to these tables in your front-end
file. Split off as many back-end files as you need to get the file size down
to a reasonable size. Tables should be the only things you put in the
back-end files. http://www.granite.ab.ca/access/splitapp/index.htm