Jackson1942
Registered User.
- Local time
- Today, 09:12
- Joined
- Dec 22, 2011
- Messages
- 15
When a normal user opens my SP Reports.accdb database they are presented with a Form with 3 buttons. Each button takes them to a different Form that will produce a Report or Query based upon their selection.
When the user selects button 1 or 2 they get the following error message:
“The Microsoft Access database engine cannot open or write to the file ‘S:\ITS\Shared\Service Portfolio\ ITS Service Portfolio\Service Portfolio.accdb’. It is already opened exclusively by another user, or your permission to view and write its data.” Respond OK to the message and you see Error Number: 2950.
I checked and no one was using the Service Portfolio.accdb.
If they select the third button, the next Form opens correctly however the Combo boxes are not populated.
I have spent days researching finding everything from VB, Access 2010 bug, Linked Table and Not Trusted solutions that I have tried and am unable to fix the problem.
Following is the complete setup that I am using that contains multiple databases each performing a specific function from producing reports to maintaining the tables.
Database setup:
I have a folder on a shared network drive named Service Portfolio.
Service Portfolio is in a Trusted Location.
In that folder I have two folders named ITS Service Portfolio and ITS Service Portfolio Reports.
In ITS Service Portfolio I have a database named Service Portfolio.accdb thatcontains nothing but tables; similar to a split database.
In ITS Service Portfolio Reports I have a database named ITS SP Reports.accdb that contains nothing but Queries, Forms, Reports and Linked Tables from Service Portfolio.accdb.
SIDE BAR: I set this up somewhat like a Split Database because there are three other folders besides the two mentioned, each contains a database that links to the Service Portfolio.accdb tables.
ITS Service Portfolio Maintenance folder contains SP Maintenance.accdb; it is used to update the tables in Service Portfolio.accdb. Authorized administrators have full access to the folder and database, they have no issues.
ITS Staff folder contains ITS Employee.accdb; it is used to maintain employee tables in Service Portfolio.accdb. Authorized administrators have full access to the folder and database, they have no issues.
ITS Team Maintenance folder contains ITS Team Maintenance.accdb that team members will eventually use to update specific tables in the Service Portfolio.accdb. At this point this database is not in production.
When the user selects button 1 or 2 they get the following error message:
“The Microsoft Access database engine cannot open or write to the file ‘S:\ITS\Shared\Service Portfolio\ ITS Service Portfolio\Service Portfolio.accdb’. It is already opened exclusively by another user, or your permission to view and write its data.” Respond OK to the message and you see Error Number: 2950.
I checked and no one was using the Service Portfolio.accdb.
If they select the third button, the next Form opens correctly however the Combo boxes are not populated.
I have spent days researching finding everything from VB, Access 2010 bug, Linked Table and Not Trusted solutions that I have tried and am unable to fix the problem.
Following is the complete setup that I am using that contains multiple databases each performing a specific function from producing reports to maintaining the tables.
Database setup:
I have a folder on a shared network drive named Service Portfolio.
Service Portfolio is in a Trusted Location.
In that folder I have two folders named ITS Service Portfolio and ITS Service Portfolio Reports.
In ITS Service Portfolio I have a database named Service Portfolio.accdb thatcontains nothing but tables; similar to a split database.
In ITS Service Portfolio Reports I have a database named ITS SP Reports.accdb that contains nothing but Queries, Forms, Reports and Linked Tables from Service Portfolio.accdb.
SIDE BAR: I set this up somewhat like a Split Database because there are three other folders besides the two mentioned, each contains a database that links to the Service Portfolio.accdb tables.
ITS Service Portfolio Maintenance folder contains SP Maintenance.accdb; it is used to update the tables in Service Portfolio.accdb. Authorized administrators have full access to the folder and database, they have no issues.
ITS Staff folder contains ITS Employee.accdb; it is used to maintain employee tables in Service Portfolio.accdb. Authorized administrators have full access to the folder and database, they have no issues.
ITS Team Maintenance folder contains ITS Team Maintenance.accdb that team members will eventually use to update specific tables in the Service Portfolio.accdb. At this point this database is not in production.
