Cannot save when mult user on database.

[scopes456]

I have a split database with the backend on a network. And a font end short cut that multiple users access. User select there name and log in which bring them to their home page using "Tempvars" from the logon form . The database works find when one user is one it they can add or update their record but if the database is open ( just to the logon screen) on another computer I get an error when the user try to save.

How can I solve this?

 

[Eljefegeneo]

Are all the users being directed to the same front end via their shortcuts? If so, this is causing the problem. Everyone should have their own front end on their workstation.

 

[scopes456]

Yes the shortcut leads them to the same front end. Does all user have to copy this front end to there workstation? That will be the only solution?

 

[arnelgp]

yes, give each user a copy of your FE.

 

[Eljefegeneo]

Put a copy of the front end on each workstation. Keep a copy of the current front end on the server. When you make any changes to the front end, make the change on this copy and then copy it to each workstation.

 

[arnelgp]

search this forum about FE autoupdater.

 

[CJ_London]

sounds like when your users save they are saving the form as well as the data. Each user having their own front end will appear to stop this problem but you should check your code - if you are using docmd.save for example, this saves the form, not the data which is saved automatically when the form is closed so you may think it is working when in fact it is not.

Also ideally your front end should be distributed as a .mde or .accde so users cannot change the forms/code

 

[scopes456]

Everyone thank you for your help, i change docmd.save to just say the record, and everything works great.