Access 2003 shared database
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Access 2003 shared database
I have a database that I thought was designated a shared database so more than one person could open the database. Someone was in the database but I couldn't open it as long as they were in the database. I looked under tools/options/advanced and the Default Open Mode is shared. There is one thing different now - we just got updated to explorer 7. Would that cause this behavior and if so how can I get the database to be a shared database again?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Access 2003 shared database
If someone opens an Access database and starts modifying database objects, that user locks the database exclusively. Check whether that could be the cause.
Could you provide feedback on the replies to your recent questions? Thanks!
Could you provide feedback on the replies to your recent questions? Thanks!
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Access 2003 shared database
No they were just opening reports. Could it be some security setting? I know before we got Explorer 7, multiple people could access the database. I have to check whether this is the case for other databases that are shared.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Access 2003 shared database
What exactly do you mean by Explorer 7? Do you have Windows 7 as operating system, or Internet Explorer 7 as browser, or ...?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Access 2003 shared database
Internet Explorer 7 as browser.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Access 2003 shared database
That has no direct bearing on Access 2003.
Make sure that all users have full permissions (read/write/create/delete) on the folder containing the database (and if it's split into a frontend and backend, this holds for the folder containing the frontend AND the folder containing the backend). These are Windows-level permissions, not Access-level permissions.
Make sure that all users have full permissions (read/write/create/delete) on the folder containing the database (and if it's split into a frontend and backend, this holds for the folder containing the frontend AND the folder containing the backend). These are Windows-level permissions, not Access-level permissions.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Access 2003 shared database
I could open the databases (in use) on the drive that is designated a secure site but the databases that are on my directory are the ones that can't be open by more than one person.
I get the attached security warning when opening databases that are not on a designated secure site. When I open databases on the secured sites, I don't get this security warning.
I get the attached security warning when opening databases that are not on a designated secure site. When I open databases on the secured sites, I don't get this security warning.
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 390
- Joined: 26 Jan 2010, 16:02
- Location: Las Vegas, NV
Re: Access 2003 shared database
I would take Hans' advice one step further:
- Right click the mdb file(s) in question
- Click Properties
- Click the Security tab
- Click Edit
- Click Add
- Enter "Everyone" (no quotes) in the box labelled "Enter the object names to select".
- Click OK
- Highlight Everyone
- Click the "Full Control" checkbox. This will automatically check all the check boxes except "Special Permissions"
- Click Apply
- Click OK
Using this technique, I was recently able to give a user full control to an individual file in a protected folder.
Does this help?
I have had good luck, in this kinds of issues, giving the "Everyone" Windows user group full control on the individual file(s) in question. To do this:Make sure that all users have full permissions (read/write/create/delete) on the folder containing the database (and if it's split into a frontend and backend, this holds for the folder containing the frontend AND the folder containing the backend). These are Windows-level permissions, not Access-level permissions.
- Right click the mdb file(s) in question
- Click Properties
- Click the Security tab
- Click Edit
- Click Add
- Enter "Everyone" (no quotes) in the box labelled "Enter the object names to select".
- Click OK
- Highlight Everyone
- Click the "Full Control" checkbox. This will automatically check all the check boxes except "Special Permissions"
- Click Apply
- Click OK
Using this technique, I was recently able to give a user full control to an individual file in a protected folder.
Does this help?
Carol W.
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Access 2003 shared database
That probably would work if my company didn't control everything. The Add button is dimmed out.
-
- 3StarLounger
- Posts: 390
- Joined: 26 Jan 2010, 16:02
- Location: Las Vegas, NV