I recently built a new database, splitting it so it can be used by multiple persons. The database was built in Access 2007-2010 and converted to Access 2003 version because we still have some Access 2003 users.
The problem is that on users' computers, the data in forms and subforms is locked and can not be changed. In other words, the database becomes read-only for everyone other than the creator. I've never run into this issue before. There are other split databases using this same server that operate without problems.
Here's what I done/checked so far to try to overcome this issues.
1. Made sure sharing permissions on that server and the folder holding the .be file on that server are set properly, i.e. all the users have permission to use that folder. I even created a special accessusers group on the domain controller and assigned all the users to it.
2. Added the .be location to the list of trusted locations.
3. Changed the macro setting in both the front and backends to allow all macros to run without warning.
If I move the backend to the user's machine, everything works. I don't even have to re-link it, although I do.
Any ideas?
The problem is that on users' computers, the data in forms and subforms is locked and can not be changed. In other words, the database becomes read-only for everyone other than the creator. I've never run into this issue before. There are other split databases using this same server that operate without problems.
Here's what I done/checked so far to try to overcome this issues.
1. Made sure sharing permissions on that server and the folder holding the .be file on that server are set properly, i.e. all the users have permission to use that folder. I even created a special accessusers group on the domain controller and assigned all the users to it.
2. Added the .be location to the list of trusted locations.
3. Changed the macro setting in both the front and backends to allow all macros to run without warning.
If I move the backend to the user's machine, everything works. I don't even have to re-link it, although I do.
Any ideas?
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar