R
REMilk
I am the only person who maintains this database and it is on MS Access 2003
is on a single machine.
I am unable to copy table (structure and data) from one db to another; even
a copy of the original db.
Every time I get the dreaded "The database has been placed in a state by
user 'Admin" on machine "XXXXX" that prevents it from being opend or locked."
I have tried to lock everything, lock edited records, unlock everything but
to no avail. I have tried making a new database and copying the structure
and the data, but cannot copy & paste because of this problem. I( have also
tried to cut & paste from other databases into a brand new database and
continue to have this problem. This did not occur 3 weeks ago when I
performed the last maintenance on the db.
Thank you in advance for your assistance.
is on a single machine.
I am unable to copy table (structure and data) from one db to another; even
a copy of the original db.
Every time I get the dreaded "The database has been placed in a state by
user 'Admin" on machine "XXXXX" that prevents it from being opend or locked."
I have tried to lock everything, lock edited records, unlock everything but
to no avail. I have tried making a new database and copying the structure
and the data, but cannot copy & paste because of this problem. I( have also
tried to cut & paste from other databases into a brand new database and
continue to have this problem. This did not occur 3 weeks ago when I
performed the last maintenance on the db.
Thank you in advance for your assistance.