Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Can't compact database
 New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kerryww
Starting Member

30 Posts

Posted - 17 January 2013 :  01:32:45  Show Profile  Reply with Quote
Hi,

I have my forum on an Arvixe server named AVEN.

Whenever I try to compact the Access database I get the following error.

Microsoft JET Database Engine error '80004005'

You attempted to open a database that is already opened exclusively by user 'Admin' on machine 'AVEN'. Try again when the database is available.

/admin_compactdb.asp, line 104


I have a user named Admin. Would the solution be to just delete the user or would this cause even more of a problem. I'm logged in under different user name.

Thanks for you help.

Kerry Whitfield

kerryww
Starting Member

30 Posts

Posted - 18 January 2013 :  01:32:17  Show Profile
Stop looking everyone - I found a solution.

I downloaded the MS JetComp Utility and then downloaded a copy of the Access database and used Jetcomp to compact. Worked like a charm.

Kerry
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2019 Snitz™ Communications Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000 Version 3.4.07