Form already in use or no permissions when multiple users are accessing a form

[Randy]

I have my application split, BE and FE. This is a form with a subform.
For both I have the properties set to
Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO

anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.

If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?

just not sure.

 

[GinaWhipp]

Does everyone have their own Frontend? What are they doing when they open the Form...reading only?

 

[CJ_London]

is your form record locks property set to no locks?

Or have you changed the default in options>client settings?

Or have you set the front end to open the backend exclusively in vba?

 

[Randy]

sorry good questions I should have noted some answers in my post
right now the FE is on the server in the same folder as the BE. For now we only have 5 users and they all go to the same folder to access the same FE.

Yes as of now all users are doing read only. The data is loaded each night by me, and then the end users just use this application to find data during the day. It saves us license fees and hitting against our ERP system during the day.

I am not using VBA. I have the FE "linked" to the BE tables. I am using table manager. Just keeping it simple right now.

 

[Randy]

additional answers
is your form record locks property set to no locks? Yes.

have you changed the default in options>client settings? Yes. Default open mode is Shared.

 

[GinaWhipp]

Can you do a test with the the Frontend on their locals? Let's see what happens with that.

 

[jdraw]

Randy,

Here are some tips from FMS
http://www.fmsinc.com/microsoftaccess/performance/linkeddatabase.html
http://www.fmsinc.com/microsoftaccess/databasesplitter/

Good luck.