I'm experimenting with a prototype version of a multiuser system with an Access 2002 front-end and a SQL Server 2000 back-end. I'd
like to be able to use an Access Data Project as the front end, but I also want to use local Access tables on each user's machine
for storing temporary ...

hi! any one help me how do I get my machine IP Address in
access. thanks in advance
krish

I am not an Access person.  I work with wireless connectivity.  I have
a client that has their customer database that they use to generate
Work Orders (WO) using Access.  They want to partially fill out a WO
and then make it accessible to a field technician who will input

Any one help me how to get IP of the user connected to my
database.
thanks in adv.
krish

any one help me how to copy MS access forms to Visual Basic
krish

We have a databse that's on the network.  If I want to create reports, even
using tables that no-one else is using, I always get an error message saying
that I cant save the report as i dont have exlcusive use of database.  Is
there anyway of getting over this or do I have to ...

I developed for a sister facility an application in A97, tables in BE, 2
different FE, one for the secretary who does all the data management, and
one for about 50 users who only print 2 reports. All worked fine on my
machine, but when the other facility installed they run into the ...

Has any one had any issues with Service Pack 2 and linked tables?
I've just tested our Access applications on their "Service Pack 2"
test bed machine and I'm getting the "An Error occurred and this
feature is no longer functioning properly.  Would you like to repair

How can I un-split a DB so that it goes back to its original state as 1dbf
file?
Thanks in advance

I got something weird in a 2 person multiuser environment (Access 2000). The
Network is setup properly with front and backend, the front end having been
distributed to the users machines along with *.mdw file for password
protection etc. .. all works fine...

Probally a silly question but, If you want to add a table or make changes to
an existing table, do you just open the BE and make the changes? Or do you
need to use the FE and link?

This is post with my challenge and the solution to my problem.
Background:
I have a client running Windows XP sp1 workstations and a Windows 2003
Small Business Server (Standard).

I have designed a multiuser access 2000 database with a FE
and BE and .mdw file.  The BE and .mdw are on a shared
network folder and the FE resides on each users machine.  
I (with great help from this newsgroup!) then designed a

I want to run multiple statements and make sure that no one will
change or add new rows between my statements. Since Access does not support
multiple statements in one query I decided that I need isolated
(serializable) transaction. How should I implement this?

I've read through almost all the threads refering to Front Ends (FE) for
Access and am still unclear about the following:
Is/are there any reason(s) why multiple copies of the FE program could not be
saved to unique folders on a server and have shortcuts on the users PCs