| Author |
Topic |
|
nicka
Starting Member
28 Posts |
 Posted - 2002-10-09 : 12:49:07
|
| An MS access database needs to be accessed from both the web and using the switchboard on the database itself. My question is when individuals are using the switchboard to access the tables I get the following message on the browser: "file already opened exclusively by another user, or you need permission to view its data." The database is not restricted at all and from the web I am not making any restrictions (i.e. password or userid restrictions) at all. Help |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-09 : 14:01:08
|
quote:
An MS access database needs to be accessed from both the web and using the switchboard on the database itself.
Why can't all of the machines use the web interface only? That seems to be the easiest solution.While I haven't seen this kind of problem (and I have had scenarios where both web and non-web access was used), if you absolutely have to use the switchboard, you might be able to make it work using a front-end/back-end setup using linked tables. That way the Access database that contains the tables is never opened directly regardless of method. The switchboard database would open linked tables instead of regular tables. |
 |
|
|
nicka
Starting Member
28 Posts |
Posted - 2002-10-09 : 15:07:14
|
After doing some testing it seems that the issue is that the problem is only a web problem. In other words I connected to another copy of the database local on my machine and it worked fine even with using the switchboard simultaneously with the web interface. For some reason that remote location worked a couple days ago (connecting to it) but now it gave me that error. Do you think that the remote machine needs to be rebooted because of an IIS issue (locking up or something).Helpquote:
quote:
An MS access database needs to be accessed from both the web and using the switchboard on the database itself.
Why can't all of the machines use the web interface only? That seems to be the easiest solution.While I haven't seen this kind of problem (and I have had scenarios where both web and non-web access was used), if you absolutely have to use the switchboard, you might be able to make it work using a front-end/back-end setup using linked tables. That way the Access database that contains the tables is never opened directly regardless of method. The switchboard database would open linked tables instead of regular tables.
|
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-09 : 15:15:37
|
| I think the problem is the Access locking file (.LDB file) Access has notoriously bad lock handling, and at some point, in a multiuser environment, you will experience lockups that require kicking all of the users out of the database and deleting the .LDB file. There's very little you can do to alleviate the problem, you just have to accept a certain amount of maintenance. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-10-09 : 15:35:10
|
| Be advised that at about 10 users, Access will get really slow or possibly just not work for ya.Depending on how hard your users hit the database, you may experience issues, especially if you have queries with "SELECT * FROM table."Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
nicka
Starting Member
28 Posts |
Posted - 2002-10-09 : 15:43:41
|
I just looked at the server where the database is stored. No one is accessing the database (no .ldb file there) and still I get this error message when I connect using the web.Helpquote:
I think the problem is the Access locking file (.LDB file) Access has notoriously bad lock handling, and at some point, in a multiuser environment, you will experience lockups that require kicking all of the users out of the database and deleting the .LDB file. There's very little you can do to alleviate the problem, you just have to accept a certain amount of maintenance.
|
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-09 : 16:04:44
|
| Repair and compact the MDB file, and reboot the computer it's running on. It's probably a rogue Access process that did not terminate normally. |
|
|
|
nicka
Starting Member
28 Posts |
Posted - 2002-10-09 : 16:50:51
|
Thanks I will do that.quote:
Repair and compact the MDB file, and reboot the computer it's running on. It's probably a rogue Access process that did not terminate normally.
|
|
|
|
|
MS Access via web and switchboard simultaneously