 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / April 2005Is Access multi-user by default ?
Is Access multi-user or is there a specific version that is multi-user ? Thanks Chris > Is Access multi-user or is there a specific version that is multi-user ? > Thanks > Chris It is multi-user capable out of the box. There are certain practices that are highly recommended when having multiple users, but there is nothing different about Access or the file required.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanks for the quick response Where would I find the best practices ? I have a client that is having problems with the program crashing their system when more than one user is accessing it at the same time... It is not on a server, peer to peer network with shares Thanks Chris > > Is Access multi-user or is there a specific version that is multi-user ? > > Thanks [quoted text clipped - 3 lines] > highly recommended when having multiple users, but there is nothing different > about Access or the file required. >> > Is Access multi-user or is there a specific version that is multi-user ? >> > Thanks [quoted text clipped - 11 lines] > system when more than one user is accessing it at the same time... > It is not on a server, peer to peer network with shares The most basic step is to split the app into a "tables only" file and another file with everything else. The second file contains links to the tables in the first. The data file is the one that is shared over the network while each user has his own locally stored copy of the front end file. Having multiple users simultaneously in the same monolithic file leads to file corruptions and this might be what your client is seeing. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com > Where would I find the best practices ? > I have a client that is having problems > with the program crashing their system > when more than one user is accessing it > at the same time... It is not on a server, > peer to peer network with shares In addition to Rick's very accurate admonition about splitting the database and giving each user a copy of the front end, there's an introductory presentation on Access in a Multiuser Environment that I did for my user group that you can download from http://appdevissues.tripod.com. It will identify topics that I thought worthwhile to discuss, and a bit more. The best collection of detailed information and links on the subject of Access in the multiuser environment is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm. Larry Linson Microsoft Access MVP Larry Where is the introductory presentation on Access ? Looked under downloads on your site Chris > > Where would I find the best practices ? > > I have a client that is having problems [quoted text clipped - 14 lines] > Larry Linson > Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.