a project of organizers' collaborative
|
Active forum topicsWho's new
Who's onlineThere are currently 0 users and 3 guests online.
Syndicate |
Networking ODB??I had thought that ODB could be networked but I can not find any references in the docs. I have moved the ODB datafile and the zipcode files to a folder on our server. Everything works fine until a second user tries to access the database. We get: Unable to open Database Can two or more users be in the database at the same time? I knew that we would not be able to have two users looking at the same record. Am I doing something wrong? James Brown |
James -- The information
James --
The information on networking ODB is covered extensively on pages 57 and 58 of the user manual and there must be 500 or more networked installations of it by now.
So the answer to your question is, yes, something about your setup is atypical. Computer user #2 is not getting the same permission to access the file as computer user #1. Please consult the person who runs your network about this.
Rich Cowan
for the ODB Project
hi James --
hi James --
I actually encountered the same error while doing a client install so I now know exactly what causes this problem.
It is not an ODB issue; as I suspected, it is a Windows issue.
I am pretty sure you have installed ODB on a Windows server which has the full permissions system enabled. This is not typical for ODB but we should really document it a bit better. What I can tell you is that it is necessary to make sure that each user of ODB has permission enabled to:
1) read and write the odb database file (by default, odbdata.odb)
2) create files in your "odb databases" folder
3) read and write any other file in the "odb databases" folder
With the problem I ran into, the sys admin for our client was able to remote in and fix this issue for me in about 10 minutes, as only he had the server passwords needed to do this. You can do a test as well by trying to create a simple text file named "test.txt" while you are logged in to your server using the same user account as each ODB user.
If this file can't be created, and edited in Notepad, then your permissions are not correct. Then when you try to run ODB the Jet database engine will try to create a "lock file" (odbdata.ldb) and Windows will return the permissions error that you saw.
Hope this helps,
Rich Cowan
ODB Support
Our setup is atypical, but I got it to work!!
When you say "Please consult the person who runs your network about this.", I have to laugh and then panic. I am the person who runs our network. Anyway, I seem to have it working now and thought I would share... Our server is Ubuntu 7.10 Linux. I had our odb data files in a folder in one of the network drives on the server. As suggested in the user manual, I setup Samba on the Ubuntu machine to share the ODB folder as a separate drive. I then restarted the server and restarted the windows machines. Then on the windows machines I located the ODB folder on the server and told windows to map that as a network drive. After another restart and then repointing the ODB installations to the new drive, we were up and running.
Thanks everyone!