I have a series of Databases connected together and multiple people can be logging data throughout the day.
I then harvest the data by using excel and a data connection to create a pivot table to pull the data into excel.
The problem is when anyone has the data bases open I cannot query the data base with excel and the other way around, when I have the excel file open, no one can get into the data base.
Since these data bases are connected by queries, they don't query if someone has the other data base open or I have my excel sheet connected to it.
These are all on a server share windows 2003 server and I used the Server Manager to create the share.
What do I need to do here? Is this an setting in Access or is it the share. I am the admin of the data base - do I need to put it into a certain mode before making it available to all users?
Its a race, whoever gets it first has access to it, you can't even open the data base to veiw the data if someone has it open, it returns an error that its locked or can't read the table because its in use or something like that.
The exact error is
You cannot open a db that is already open by User "Admin" on machine xyz, try again when the DB is avialble.
Thanks!
I then harvest the data by using excel and a data connection to create a pivot table to pull the data into excel.
The problem is when anyone has the data bases open I cannot query the data base with excel and the other way around, when I have the excel file open, no one can get into the data base.
Since these data bases are connected by queries, they don't query if someone has the other data base open or I have my excel sheet connected to it.
These are all on a server share windows 2003 server and I used the Server Manager to create the share.
What do I need to do here? Is this an setting in Access or is it the share. I am the admin of the data base - do I need to put it into a certain mode before making it available to all users?
Its a race, whoever gets it first has access to it, you can't even open the data base to veiw the data if someone has it open, it returns an error that its locked or can't read the table because its in use or something like that.
The exact error is
You cannot open a db that is already open by User "Admin" on machine xyz, try again when the DB is avialble.
Thanks!
Last edited: