Access On the Network

[dhstein]

I attempted to see how performance would be if I ran my Access application on
the network. I put the .accdb file on the server and then opened it. My
menus came up, but almost nothing works. Do I need to split the database
first before running it on the network? Thanks for any help on this.

 

[Larry Linson]

. . . Do I need to split the database
first before running it on the network?

Obviously, you do not spend much time reading this newsgroup nor
microsoft.public.access.multiuser, or you would have known this before
encountering the problems.

Yes.

You need to split, and give each user a copy of the front-end database
(queries, forms, reports, macros, and modules) linked to tables in the
back-end database (tables, relationships, and data) in a shared folder on
the server.

See MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm for more
information; also, see former MVP, now member of the Access team at
Microsoft, Jeff Conrad's site,
http://www.accessmvp.com/JConrad/accessjunkie.html, for more.

 

[Tom Wickerath]

Hi DH,

Yes, you most definately should split your application, placing a copy of
the FE (front-end) on each user's local hard drive. You should also ensure
that you have disabled Name Autocorrect, set all subdatasheets to [None], and
established a persistent connection, as a minimum. I discuss these
techniques, and more, in my Multiuser Applications paper:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

My menus came up, but almost nothing works.

I suspect you were running into a Trust Center issue. By sharing the entire
file on the server, you would have to specifically trust this shared folder,
and that's something that your network administrators may not allow you to
do. Split the database, decide on a common folder to install the FE on each
user's local hard drive (don't use the Program Files folder, or any
subfolder), and then make sure to set the Trust Center settings for your
folder so that any VBA code (and some macro actions) will be allowed to run.

Dealing with the Trust Center (Access 2007 only)
http://www.accessmvp.com/TWickerath/articles/trust.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________