Importing Issues

[DAyotte]

I'm getting a message when trying to import a form from my database to the company database. The table that it pulls from imported just fine, yet the form appears to lock every time I try.

The error message is: "Microsoft Office Access cannot save design changes or save a new database object because it is open by another user. To save this new object, you must have exclusive access to the file."

Mind you... I just saved it. It's closed on my computer, and no one else could possibly have it open. Just to be sure, I saved a copy of the database on my desktop, renamed it, and tried again to no avail.

 

[DAyotte]

but then they have to come to an analyst or my sup in order to change any little thing, which will detract us from the tasks that we;re supposed to be doing... that's my only reservation.

 

[jasmith4]

Right, but how do you know if lots of salespeople are doing essentially the same thing if they're creating queries in isolation? You need that control, and when someone wants a change, you should meet with others to gauge how useful it is or whether it can be done differently or expanded upon. After a while such changes should be less and less frequent.

I also like Mr. Larson's "side"-database idea: make sure they realize that "side" databases are NOT supported!