Error Compacting

C

carl

When I try to compact my db I get a "Records can't be read; no read
permissions on db" msg.
After attempting to compact, a new db is created with an extra table
"MSysCompactError" with one record stating "The Microsoft Jet database engine
stopped the process because you and another user are attempting to change the
same data at the same time." with an error code field of "-1611".

My db is MSAccess 97, there is no log in, most of my forms open up
recordsets (I think my code closes all though) and the db is 'watched' by a
SQL Server.

Could it be I missed closing a recordset? Or the problem being the SQL
Server linked to the tables?
 
A

Alex

Hi Carl,

the problem is not going to be SQL or missed closing recordset.

Have you tried a repair on the database?

Regards

Alex
 
C

carl

Hi Alex
Yeah but to no avail.
There is a system.mdw file associated with the db but I assume I open the
database as an administrator as I don't log in.
Carl
 
A

Alex

Hi Carl,

if your system is using a system.mdw file as it's security and you
don't get the promt for the username and password all this means is the
admin account in the file has no password. If that is the case why is
the system.mdw file being used, is it to protect code and forms?

If you use the WRKGADM.EXE you can find out if the system mdw file is
in use, sometimes developers use the file and create a developer login
all the objects are owned by the developer to protect the code. I would
try and login as that login if that is the case to compact and repair,
to do that all you have to do is set a password for the Admin account
and you will be prompted for a password.

I am guessing that this security was put in place a while ago and could
be redundant now, is that the case?

Regards

Alex
 
Top