Access 2000 Table Locked

  • Thread starter Thread starter bpoteet
  • Start date Start date
B

bpoteet

I am running Windows Professional 2000, Office 2000
Professional with all the latest updates. Access is at
9.0.4402 SR-3. I was asked to troubleshoot an Access 2000
mdb (72 MB). The db is not linked and has been used for
eight months with no compact and repairs done.

There are approx. 20 tables, half of which are empty.
Most of the remaining tables have no more than 50 rows
except for four or five that have between 2000 and 6000
rows. I estimate the compacted size should be between 4-5
MB.

I select compact and repair; it starts and stops within
ten seconds with "Compacting" showing in the status bar
with the progress meter half way. A compacted db is
created (75 MB). I attempt to import tables to an empty
database, with seven tables having locking errors.
Attempts to copy, run a make table query, export against
the seven tables result in tables with zero records.

I do not have the developer's tool kit. I have tried
compacting with the db open as well as not open.
Suggestions are appreciated.
 
Sounds like you have done a lot of things I would have tried. I have run across a similar situation and all I could do was to copy and paste the records into a new table. That process will allow the "bad" records to be separated out as paste errors. It may be somewhat time consuming since on your larger table since you may have to split it up into separate copies but give it a try.
 
Thanks for the suggestion. I tried to copy rows from the
table and copy was greyed out. Unable to use. Thanks
though.
-----Original Message-----
Sounds like you have done a lot of things I would have
Click to expand...
tried. I have run across a similar situation and all I
could do was to copy and paste the records into a new
table. That process will allow the "bad" records to be
separated out as paste errors. It may be somewhat time
consuming since on your larger table since you may have to
split it up into separate copies but give it a try.
 
bpoteet said:
I am running Windows Professional 2000, Office 2000
Professional with all the latest updates. Access is at
9.0.4402 SR-3. I was asked to troubleshoot an Access 2000
mdb (72 MB). The db is not linked and has been used for
eight months with no compact and repairs done.

There are approx. 20 tables, half of which are empty.
Most of the remaining tables have no more than 50 rows
except for four or five that have between 2000 and 6000
rows. I estimate the compacted size should be between 4-5
MB.

I select compact and repair; it starts and stops within
ten seconds with "Compacting" showing in the status bar
with the progress meter half way.
Click to expand...

How long have you let it run? It could take a few minutes especially
on a network. Task managers "not responding" can be quite
misleading.
A compacted db is
created (75 MB). I attempt to import tables to an empty
database, with seven tables having locking errors.
Attempts to copy, run a make table query, export against
the seven tables result in tables with zero records.
Click to expand...

The JetComp utility might help.
I do not have the developer's tool kit.
Click to expand...

Developers tool kit won't help in this situation.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top