How to share ADP tables

[SF]

Hi,

I have developed a small sale access project for my friend. The project will
be used by 3 PCs connected together. How can I share the tables of my access
project to allow accessing by other two PCs.

SF

 

[Mary Chipman]

You don't. Give each user their own copy of the ADP. They will need to
have logins/permissions on the sql server db.

-- Mary
MCW Technologies
http://www.mcwtech.com

 

[Uwe Ricken]

Hi SF,

as pointed out by Mary it is good to use a single frontend
for each user. Otherwise it is possible to share an ADP
with other users by using the command parameter
/RUNTIME of Microsoft Access.

e.g.

C:\Program Files\Microsoft ...\MSACCESS.EXE
Drive:\Path\YourAdp.ADP /RUNTIME

Be aware that the menu of MS Access is not fully accessable

HTH ;-)

--
Gruß, Uwe Ricken
MCP for SQL Server 2000 Database Implementation

GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm