T
The Merg
I have an application in VB6-SP6 that uses an Access database for the
back-end. Initially, it was only going to be used my one person (me), so I
did not create the ability to have multiple users log into it. In order to
accomodate additional users using the application, I put the database on a
network drive and installed the front-end on the other users' desktops.
When opening the database, I now pass through for it to open the database in
Shared Mode. I realize this could cause issues, if multiple people are
making changes, but the other users are just using the program to look up
data as opposed to me who also performs data entry.
The problem I am having now is that sometimes when I leave the application
running on my desktop, other users are not allowed into the database and
receive the "database is locked exclusively by another user" error. As far
as I can tell, we all have read/write/delete privileges to the directory
where the database is.
Any ideas would be appreciated.
Thanks,
Merg
back-end. Initially, it was only going to be used my one person (me), so I
did not create the ability to have multiple users log into it. In order to
accomodate additional users using the application, I put the database on a
network drive and installed the front-end on the other users' desktops.
When opening the database, I now pass through for it to open the database in
Shared Mode. I realize this could cause issues, if multiple people are
making changes, but the other users are just using the program to look up
data as opposed to me who also performs data entry.
The problem I am having now is that sometimes when I leave the application
running on my desktop, other users are not allowed into the database and
receive the "database is locked exclusively by another user" error. As far
as I can tell, we all have read/write/delete privileges to the directory
where the database is.
Any ideas would be appreciated.
Thanks,
Merg