I have been developing a split (fe/be) database in Acess 2000 that is still
in progress.
I can normally work on the database while inside the office due to correct
drive mapping, etc.

I've developed severals databases and they work fine. But
whenver I want someone from anothe site to use the
applications they take forever to open. Is there a way to
have the runtime setup program work with a user in

Will A97 run in an Windows 2003 network environment? Our IT network people
try to tell me that the A97 databases need to be converted to A2000 because
of a possible move to Windows 2003 from NT4. Is there something to it?
I would prefer to upgrade to at least A2002 (XP) and not to ...

I have a 5 year old Database which has 7 teams. All staff is assigned
to one of these 7 teams. I have 7 Supervisor.  Management now wants to
limit each Supervisor to view only their team's Data. There are about
25 Tables and 50 Quieres.

can I pass arguments from one access .mdb file to another access.mdb file
when launching the second from the first?
Lets say a user is working with on file and has a certian record selected..
say a customer name. Can I put in a button that when clicked launches a

I have a database application which is only a single user app at the moment.
But i have 1 client who wants to have it running on 2 networked machines at
the same time.
If machine 1 changes any of the fields in the database the change needs to

Has anyone heard of a case, where a worm/virus could have
infected an access mdb database file.
I am having a problem with a database that is on a network
where one of the workstations was infected with the win32-

Ok, I have an expression which gets today's date and displays the
records, and also gets the next working days date and displays the
records. So effectively removing saturday and sunday.
Now currently it is using the Date() function to automatically get

I recently networked several XP computers at my home office. Two machines  
have Access 2000 installed.  On machine A I have an access database. When  
I try to open it on Machine B it gives me an error message saying "Cannot  
open the file. It is already opened exclusively by ...

I get the following error when I am logged on as an 'normal' user, and
not as an administrator, on a pc with Windows 2000 Professional:
Database: Order
Error: 3051

I am running Access 2000 for both front end and back end.  
I have one front end used to enter the data, and another
front end to display the information on a timer which
means every 20 seconds the data will be requeried to

Anybody tell about the advantages in splitting DB using
for multiuser.
krish

So I went and split my DB like almost everybody I spoke to recommended.
But now I am having PROBLEMS with my code.
The first thing that I notice doesn't work is when my
code tries to set an index for a recordset.

I use AccessXP,ADO to access JET database.
1) Could anyone please explain Why the statement : CNN.Mode =
adModeShareExclusive + adModeReadWrite does not prevent others from open the
same table while the same statement without adModeReadWrite can prevent ?

I have a multi user db with a front end for each user and
a back end for the tables. A new XP computer has just
started accessing the db and the back end keeps
corrupting, needing to be repaired.