I need to be able to occasionally get into a database to make updates,
however, when I ask the users to get out of the database, not everyone is
released (I have a function which shows all the connected users).  Is there a
way to force Access to release all connections, or is there ...

Short version of question: Where is the ODBC counterpart to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/ad
oproperties.asp? I
want to specify "mode=share deny none" in my ODBC connection string but I
don't know the syntax.

I have a database that tracks all of the insurance claim files that my
department works on.  I have been asked to create a similar database for the
hurricane insurance claim files that our catastrophe team is working on.  
Originally, I had thought just to use the original database ...

Please forgive my ignorance but I am trying to set up a LAN with
computers.  I am using Micorsoft Access 97 and wondered if one databas
can be used by all 3 computer users at the same time?
Would this work ok or does the database need to be split - please tel

Is there a way of preventing the back end from being opened directly.  I
cannot hide the actual file as I have no control over where the customer puts
the backend.  I was hoping to have something where if someone opens the
backend directly, it flashes up a message and then closes ...

I may seem to ask a very trivial question, but what is the way of splitting a
database into FE and BE?
The other thing which I need to know is how can I garantee that the data is
saved safely when two users enter the data simultaneously?

I apologize if this has been addressed previously (and I'm sure it has
considering its basically the topic of this newsgroup) but I'll ask
anyway...
We had been running an Access 97 database with roughly 50 users, and

I don't understand this error : "Could not update, currently
locked by <frontend_user> on Machine <theMachine>".
I have a FrontEnd, in which a macro runs query to update linked
tables (in the backend), wit hthe data contained in local tables.

I am developing an access front-end/back-end system for our agents in China
and US.  We have set up a Remote Desktop in Windows Small Business Server
2003.  What we are trying to do is have install only one copy of front-end in
the Remote Desktop and have all users login the same ...

how do I use Multiuser? please some body tell me.

I've already posted about this problem in microsoft.public.access, but
nobody there could help (though a few tried).  I just found out about
this group, so I thought maybe I'd have better luck here.
The switchboard form will open for multiple users.  But when two users

I was asked to write a small demo system in Access 2000 which, of course, as
always happens is now live and being used by 21 users and, as the data is
confidential to each user means maintaining 21 copies of the database.  When
I get the opportunity I will split the database into ...

  Is GUID for Jet "{947bb102-5d43-11d1-bdbf- 00c04fb92675}" is the
same for all of its versions?
  Can anyone help me out.
Thanks in advance,

I'm developing an access frontend/backend system for a small operation that
has two locations.  There is a pc to be used as a server at the owner's place
of business.  We want to put the backend db there and, then, enable the owner
and the other location to access it from the ...

I don't know if this is relevant to this thread, but is there a
practical approach to allowing users with Access versions 97 through
2003 to use the same database? Is this splitting the back-end from the
front-end a viable approach?