front end update problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building my first db and seem to have done something in the security
settings that is preventing me from updating the db front end. I have the
master db split, and both front and back end reside on the server (for now).
I'm working through my programming issues on a copy of the db on my pc and
want to migrate some of my updates from the copy to the master.

When I try to copy and paste a form from the copy db to the master db, I get
a message that says "This database has been placed in a state that prevents
it from being opened or locked" by the user on computer XYZ. Unfortunately,
I'm the user at computer XYZ. I've checked the security settings on both
master and copy, and I'm listed as the workgroup administrator on both, so
should have access.


thanks in advance for your suggestions.

ElizCat
 
ElizCat said:
When I try to copy and paste a form from the copy db to the master
db, I get a message that says "This database has been placed in a
state that prevents it from being opened or locked" by the user on
computer XYZ.
Click to expand...

Instead of copying and pasting, you should just copy the whole frontend from
your PC to the master location on the network. You'll need to do this when
no one is using the frontend (which is a good reason to actually distribute
the frontend to each user's computer).
 
Joan,
so as long as the front end has the same name, the back end should work with
it just fine... ahhh, I see the wisdom! Thanks! Right now there are no
other users, so that upgrade will be easy.

Thanks for the help, and have a great weekend!
ElizCat
 
Actually it doesn't matter what the frontend is named. The important thing
is to refresh the links to the backend on the server, and then copy the
frontend to the server location, overwriting the existing frontend.
 
Back
Top