Hi,
About 5 years ago, I created a database to organize my video collection. It was pretty fancy (by my standards). I was able to link pictures from another folder into the form I created. This allowed me to see the video cover that correlated to the record I was viewing.
My database is over 2 gigs. This is a problem. Just about the entire size of my database are in my tables. The folder that houses my images is only about 170 megs. Granted a lot of these images are used over and over within the database. They should be linked and not embedded in the database.
I am having problems operating my database and I know it is due to size. Can someone help me figure out how I can make my tables smaller or know of an easy way to check to see if I have images embedded into the database?
I made a copy of the database so I could go into the tables and delete the 2 colums that would house any images but made no difference. I have a little over 3,000 records but I would think that if it were just fields of informarion that should make no difference.
If anyone could help, I would greatly appreciate it.
Thank you,
Greg
About 5 years ago, I created a database to organize my video collection. It was pretty fancy (by my standards). I was able to link pictures from another folder into the form I created. This allowed me to see the video cover that correlated to the record I was viewing.
My database is over 2 gigs. This is a problem. Just about the entire size of my database are in my tables. The folder that houses my images is only about 170 megs. Granted a lot of these images are used over and over within the database. They should be linked and not embedded in the database.
I am having problems operating my database and I know it is due to size. Can someone help me figure out how I can make my tables smaller or know of an easy way to check to see if I have images embedded into the database?
I made a copy of the database so I could go into the tables and delete the 2 colums that would house any images but made no difference. I have a little over 3,000 records but I would think that if it were just fields of informarion that should make no difference.
If anyone could help, I would greatly appreciate it.
Thank you,
Greg
