Performance

[Ice Man]

Dear All,

I have an access database... I need to put it on a server and make shortcuts
to it on 5 Computers
So it will be multiuser.... How Should I link the forms and database what
method should I use
should I use an ODBC connection or waht?

thanks for the replies

 

[gandalf]

have look at these websites

http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.able-consulting.com/ado_conn.htm
http://www.mvps.org/access/api/api0001.htm

http://www.mvps.org/access/tables/tbl0009.htm
http://accdevel.tripod.com
http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html
http://www.lebans.com/mousewheelonoff.htm
http://support.microsoft.com/?id=258049
http://www.mvps.org/access/general/gen0005.htm
http://www.trigeminal.com/usenet/usenet001.asp?1033
http://www.pksolutions.com

mailmerge

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


http://appdevissues.tripod.com

-----Original Message-----
Look up splitting a database in the help file.

In short you put a copy of the existing database on the server and a
copy of the same database on each user's machine. I suggest you add "be" to
the name of the file on the server and "fe" on the user's version. (be =
Back End; fe = Front End)

Next remove the queries, forms reports and macros from the be and remove
the tables from the fe's. On the fe's go

to "file", "get external data",