Access 97 "Asset Tracking" database errors

  • Thread starter Thread starter Alejandro
  • Start date Start date
A

Alejandro

Hello all,

I have recently tried one of the pre-fab databases from Microsoft. I
created the "Asset Tracking" database, with almost all defaults, except for
the style. The options chosen were all defaults.

What I get when I open the db is "Microsoft Access can't apply the filter
because all the records are locked" with nothing but an OK button. Once in
the database, only the "Enter/View Assets," "Change Switchboard Items," and
"Exit" seem to work. The others kick an error which is "There was an error
executing the command."

Once in the Enter/View area, the "Maintenance" and "Depreciation" buttons
have this error "You tried to lock table '~sq_fMaintenance' while opening
it, but the table cannot be locked because it is currently in use. Wait a
moment, and then try the operation again." and "You tried to lock table
'~sq_fDepreciation' while opening it, but the table cannot be locked because
it is currently in use. Wait a moment, and then try the operation again.",
respectively.

I have tried to make sure that there isn't a single lock in the system, to
no avail. Any suggestions?

Thanks in advance!
 
Is the database in the same version as your ACCESS version? Did you convert
it to your version if not?
 
It appears to be. I only have one version of Access, and I do have to
correct one thing, it is access 2000. I tried double checking that it was
the correct db version, by running the convert command on it, and it was
already in 2000.

-=Alejandro

Ken Snell said:
Is the database in the same version as your ACCESS version? Did you convert
it to your version if not?
Click to expand...
 
I'm not familiar with this prefab database. Can you zip up your database and
email it to me so that I can see firsthand what is happening here? My email
address can be obtained by removing this is not real from the address.

--
Ken Snell
<MS ACCESS MVP>

Alejandro said:
It appears to be. I only have one version of Access, and I do have to
correct one thing, it is access 2000. I tried double checking that it was
the correct db version, by running the convert command on it, and it was
already in 2000.

-=Alejandro

Ken Snell said:
Is the database in the same version as your ACCESS version? Did you convert
it to your version if not?

--
Ken Snell
<MS ACCESS MVP>

except
for Once
in Items,"
and
Click to expand...
Wait
a
Click to expand...
system,
Click to expand...
 
Alejandro -

I have looked at the database and found the problem.

Open the Switchboard form in design view, and open the Properties window.
Click on the Data tab. You'll see that the Records Lock property is set to
All Records.

Change this property to No Locks. Save and close the form.

The database now will work correctly.
 
Thanks! After doing that for the Maintenance and Depreciation forms as
well, those buttons worked too.

Thanks again,
-=Alejandro
 
Back
Top