shared Db not sharing anymore

[Jings00]

Hello all,
My issue is that a have an access 2000 shared database on a windows 2K server. Every so often users will be unable to load the database, given the message "database opened exclusively by 'admin' on machine xxxxx". Yet no other user is doing anything other than viewing data. Even worse, sometimes a user will be given the message "database an unrecognized format....." yet if everyone else logs off, they can open it. Any ideas what may be causing this?

 

[FloBob]

I have had that problem before, though I believe that was before I seperated the FE and the BE of the databases. Are you still using just the one database and everyone opens it? if so, try sepperating out your tables from your forms and everything else... If you dont know how to do this there are a bagillion threads on it just do a search for front end or back end. Once everyone has their own copy of the forms and modules etc they will just use the same data and you should eliminate this problem, because you cannot open the BE exclusively through link tables. The down side is you will probably suffer a slight performance hit, no one seems to know why but it does happen when the BE is on the server and FE are on the local machine.

Another thing to try is after you compact and repair try moving the database to a higher level in the directory sturcture. example:

c:\access\info\client_data\yourDatabase.mdb
TO
c:\access\yourDatabase.mdb

Again this is just a try thing and to my knowledge no one seems to know why but that helps with access's ability to find and use the database. Maybe Pat or Mile's can elaborate as they know more then I do on their worst days.

 

[Jings00]

I have read some on the FE/BE model, and have used it in one case, but the problem I have here is that alot of the users are running update routines on their own, not just the administrator. Maybe I'm being a little dense here, but can you still use the FE/BE system with the FE updating the BE? And if I grant my FE an update ability to the BE, will I not have the same kinds of access rights issues I am currently having using a single system?

 

[FloBob]

Yes you can update the data in the BE from the FE interface. No you shouldnt have the issues because all the FE is doing is linking to the tables of the BE. You dont just view the data from the FE you can manipulate it aswell. This also lets you work freelly on your copy of the FE only haveing to interupt your users if you need to make an actual table change or update their FE's. I hope this helps.