Table Help

[Gregbert]

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

 

[Pat Hartman]

Sounds like you've never compacted the database. In 2gig, you should be able to store millions of records. 3,000 is a drop in the bucket.

 

[Gregbert]

Exactly! I have compacted it.

I am very confused by the whole thing. It is extremely annoying. I will keep trying different things to see how I can tackle this.

Take care,
Greg

 

[Pat Hartman]

Perhaps the database is corrupted. Try creating a new empty database and importing all your objects into it. If that doesn't solve the problem, you probably have the pictures embedded rather than linked as you think.