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

 

[Joseph Meehan]

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",
"link tables" and link all the tables from the be. You may want to keep
small static lookup tables. For example many of my applications use joined
tables to get the names of government counties using a county number.

You may need to reestablish relationships.

That will speed up results, reduce right conflicts etc.

Repair and compact each database after you are done editing it.

You may want to set up user based security as well, but that is another
big issue and if you are interested in that, you will want to make sure you
really really understand it first.

If you experience write conflicts, come back and we may be able to offer
some suggestions to reduce that problem.

 

[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",