Database not working?

[saltyseadog]

Our database is 1.6gb in size.
It has stopped working, is there a way to delete old records?
We are told it will crash the computer, because access needs the same space as the data its self.
Any ideas?
Thank you for your time in reading this post

 

[KenHigg]

I recommend you start by reading up on 'compacting' the database in Access help.

 

[ghudson]

Before you try anything I suggest that you make a backup copy of the db, just in case.

Have you tried to compact it? You can run this from the Run command prompt off of your Start button to compact the db [all on one line]...

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "\\Server\Partition\Directory\Database.mdb" /excl /compact

You can import the db objects into a new database. You could split the tables into multiple databases if you need all of the records.

Search for the Microsoft Jet Compact utility. I have posted previous links on where to find the program and use it to compact your db.