Can't import table -- Help!

N

njanet

I'm trying to create secure database, by making new db and
importing all objects from unsecure db. Everything
imports except for the table. A message pops up saying
that "you and another user is trying to change the same
data at the same time." I know there are no other users
in the unsecure db because no .ldb file is visible. I've
secured 17 other dbs for the agency and none of them had
this problem. It seems that someone did something to lock
this table, without authorization to do so. Can you tell
me how to UNlock the table in unsecured db so I can import
it into new secure db.
 
T

TC

That's a file corruption problem, not a security one. Repair & compact the
database, then try again. If that doesn't work, focus on reading as much
data as possible out from that table. Perhaps cutting & pasting, or a
make-table query, etc. Keep a copy of the current db, in case your efforts
make it >worse<.

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import to bypass security 4
Copy Security Settings 4
New to security 6
ULS not working 1
Hlp - DB security mystery 13
Import from a secure DB 1
link/import the object 3
MDW and linked tables 4

Top