The size of DB is about 2 gigs.
When I try to compact it the message says -
Re: Error Message upon compacting
The following I found in the help files.
Troubleshoot compacting an Access database or Access project
A Microsoft Access database or Microsoft Access project will not compact for any of the following reasons:
You don't have enough storage space on your disk for both the original and compacted versions of the Access database or Access project. Delete any unneeded files and try again.
You don't have both Open/Run and Open Exclusive permissions for the Access database. If you don't own this database, contact its owner to find out whether you can be given these permissions. If you own this database, you need to update your permissions.
Another user has the Access database or Access project open.
The Access database or Access project is located on a read-only network share, or its file attribute is set to Read Only.