How come it won't let me and my colleague work at the same time? I've changed the settings to shared and everything and still when we are trying to create stuff (I'm working on a form and she's working on a report) it won't let us save them cuz we are in exclusive mode. Is there anything we can do you correct that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW CAN 2 PEOPLE SHARE ACCESS DATABASE?
- Thread starter Artesha
- Start date
In database design window select from the Tools Menu / Options. Click the Advanced tab and make sure the Default Open Mode indicated Shared.
Is this database setup as multiple front-end applications linked to a server based back-end with all the tables? Just trying to get a better feel for how this application is set up.
Bob Scriver
Is this database setup as multiple front-end applications linked to a server based back-end with all the tables? Just trying to get a better feel for how this application is set up.
Bob Scriver
- Thread starter
- #3
Thanks, Bob. I tried that and I am still getting the exclusive message when we are both trying to change things. It is not set-up with the multiple front-end applications. How can I go about doing this? Will it allow both me and my asst to make changes and create applications at the same time?
Yes, you see the front end application contains static tables only(non changing), queries, forms, macros, and module and is distributed to end-users on their individual PC's. The back-end database contains the dynamic tables that are constantly changing with entries and processes from the front-end applications. The front-end applications are linked to the back-end databases through linked tables.
The front-end applications are setup as I described above.
Now I have a question. Is there any possibility that you have set the database password for this database. This would limit the database to only being worked on by one user at a time. Let me know if this is the case.
Bob Scriver
The front-end applications are setup as I described above.
Now I have a question. Is there any possibility that you have set the database password for this database. This would limit the database to only being worked on by one user at a time. Let me know if this is the case.
Bob Scriver
- Thread starter
- #5
Are you using a form to edit or enter data? If so, check the "Recordset Type" property of the form. I usually set it to "Dynaset".
Also, check the "Record Locks" property. I usually set it to "Edited Record". I'd advise against "No Locks", as it may cause data integrity problems.
If either of these (especially Record Locks) are set wrong, it may cause problems.
Also, check the "Record Locks" property. I usually set it to "Edited Record". I'd advise against "No Locks", as it may cause data integrity problems.
If either of these (especially Record Locks) are set wrong, it may cause problems.
I have this problem too, and I don't think you can modify forms or reports if someone else is using the database (ie shared database). I've looked this up many times.
To get around this I made a working copy of the database and then I import my changes into the shared copy.
If anyone can find out how I'd love to know how too!
Curlers do it between the sheets!
To get around this I made a working copy of the database and then I import my changes into the shared copy.
If anyone can find out how I'd love to know how too!
Curlers do it between the sheets!
BrazilTechie
Programmer
Please check
thread702-523984
I think the solution I gave could be the same to your problem.
Let me know how it goes.
thread702-523984
I think the solution I gave could be the same to your problem.
Let me know how it goes.
I change forms, etc. all the time in a shared database. The changes usually aren't visible to a user until they exit and open the database again, but I've not had any trouble making changes.
You can't, however, open a table for modification when a form bound to the table is open.
You can't, however, open a table for modification when a form bound to the table is open.
i believe 'shared' pertains to data, not design. multiple people can open the db and add/edit/delete data. it isn't talking about designing objects.
in Access 97 you can alter the design of forms and reports while others are using the db and that's ok.
In Access 2000 you cannot. one person doing design work at a time in the same db, and no design changes can be made if any users are even in the db.
you can make copies of the db, keep track of what you each have changed, then patch it all back together later. good luck.
in Access 97 you can alter the design of forms and reports while others are using the db and that's ok.
In Access 2000 you cannot. one person doing design work at a time in the same db, and no design changes can be made if any users are even in the db.
you can make copies of the db, keep track of what you each have changed, then patch it all back together later. good luck.
In reports: Record Locks: No Locks
In forms: Record Locks: Edited Record
Probably the reports are the trouble...
Good luck
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Daniel Vlas
Systems Consultant
In forms: Record Locks: Edited Record
Probably the reports are the trouble...
Good luck
Daniel Vlas
Systems Consultant
- Thread starter
- #13
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question