Split Database but no edits can happen

[DavidMcA18]

Hi Everyone,



Ive been working on this database and have just split into Back End and Front End with no problems as ive done this before.

I can open it and edit anything i like but by other 2 users cant. Theres a note (its not an error thats popping up) to say that the recordset is not updateable. They cant edit anything at all. There are no user levels or anything.

Can anyone point me in the right direction?

[ranman256]

do the other users have rights to read AND write to the folder?
do the users have db settings: macros enabled and trust set to OK?

[DavidMcA18]

Yes to both. Its a shared server folder which we all have access to. and they have trust centre enabled.

[ranman256]

does every user have their own copy of the frontend app?

other that that, there's no reason for them to be locked out. (unless you wrote code to do so)

[DavidMcA18]

They all click on the same file to open the front end. Should this matter?

[orange]

Each user should have their own copy of the Front end file on their own PC as ranman suggested.
See this article from FMS for more info.

[ArviLaanemets]

Probably the 1st user opens the front-end, and it will be locked for the other users.

[ranman256]

yes. everyone gets their own copy.