I tried to do "Split a Database" and after I clicked on the "Split" button, here is what I got: "The database engine couldn't lock the table, because it is already in use by another person or process"

Any idea?

Thanks

---

additional question:

is it possible to split your database many times? first i'm trying it at home and the following day i would like to try it at the office if it works. i already tried the split and if i do it tomorrow at the office would that be a problem?

Thanks

1 Answer

This is an error you typically get when you have the design view open on the table. I'm not sure what the split feature does, but if it moves records back and from separate mdb files, it should work using plain (optimistic) locking like other operations use.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy