Windows Forum

Ask something
Question Locked

Error 3045 in Microsoft Access

0 helpful
3 replies

by jim

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all.
I have a small business database that I built to handle all sorts of data entry from one point. Eventually we took on collection of more data and added a second data entry point on the workgroup. So I split the database and left the back end on one of the data entry machines and had the front end operating at both data entry locations with no problems. We very recently upgraded to Vista and now, since I have had to change the linked table paths on both front end files and change other permissions settings for vista to allow user access to the backend file, I cannot operate both front ends at the same time. When one front end is open the backend file is locked and no other can utilize it.
I am sure there is a very simple solution, here is to hoping that you the reader can tell me what I need to know.
Thanks.

3 replies

by techbro

I'm not currently at a machine to check this, but there is a setting in Access that allows you to open a database in an "Exclusive Edit" type mode (that may not be the official name, but that is what it does). My hunch here is that when you upgraded to Vista, something tripped that setting. Try opening the DB on one of your workstations and looking through the Options.

This discussion is closed to new replies.