By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

Can access database be run for multi users?

P: 35
I want to run my database through networking for multi users. Is it possible??
Aug 23 '18 #1
Share this Question
Share on Google+
7 Replies


P: 1
Yes its possible. Just try it out.
Aug 23 '18 #2

twinnyfo
Expert Mod 2.5K+
P: 3,284
Networking is one of the great advantages of MS Access. There are very few limitations, although two users cannot edit the same record at the same time.

There are some tips and tricks to doing it right though. When I get to work I will provide some links to articles/threads which address this.
Aug 23 '18 #3

twinnyfo
Expert Mod 2.5K+
P: 3,284
Take a look at this artcile on Custom User Permissions and Menus and it will provide some good insight. It is a bit advanced for anovice developer, but a great place to learn your craft.

I am also trying to find the thread that discusses a Shell Script to copy a networked front end to the user's local machine so that the DB executes locally, accessing the networked Back End. I can provide that script, but the thread itself is useful in understanding what is going on and why.
Aug 23 '18 #4

zmbd
Expert Mod 5K+
P: 5,397
Aftab Ahmad
As TwinnyFo said, there are some steps to take.

IMHO: the two most important steps are:

- Split the database into Front-end and Back-End. A COPY of the front-end will run from client's PC and the back-end will reside on your network share

- Normalize your data

You will find dozens if threads here on Bytes.com covering both of these concepts.
Aug 23 '18 #5

twinnyfo
Expert Mod 2.5K+
P: 3,284
OK! I found the other thread:

Feeding Updates From a Newer Version
Aug 23 '18 #6

zmbd
Expert Mod 5K+
P: 5,397
TwinnyFO
I have used a version of that script for many years; however, now I have my Access frontends check for a new version on the network and if needed create the script on the fly and then shell out the script, closing the current Frontend, copy the new frontend, and then restart Access.
Much less traffic on the network and faster startups for the client.
Aug 23 '18 #7

twinnyfo
Expert Mod 2.5K+
P: 3,284
Z,

My script checks for the latest version first, then only copies thenew back end if it is out of date, then opens the DB. This precludes Access from opening twice. This eliminates net traffic completely unless the DB is out of date.

Here is the absolute latest version of said script:

Expand|Select|Wrap|Line Numbers
  1. @ECHO OFF
  2. CLS
  3. SET gSourceLocation=\\SERVER\FOLDER\DATABASE\
  4. SET gAppFileName=DBASENAME.accde
  5. SET gVersionFileName=Version.txt
  6. SET gAppDir=Documents\DBUser\
  7.  
  8. SET sUserProfile=%userprofile%
  9. SET sSourceFile=%gSourceLocation%%gAppFileName%
  10. SET sSourceVersionFile=%gSourceLocation%%gVersionFileName%
  11.  
  12. SET sDestination=%sUserProfile%\%gAppDir%
  13. SET sDestinationFile=%sDestination%%gAppFileName%
  14. SET sDestinationVersionFile=%sDestination%%gVersionFileName%
  15.  
  16. SET sSourceVersion=0
  17. SET sDestinationVersion=0
  18.  
  19. ECHO Source Version File: %sSourceVersionFile%
  20. ECHO Current Version File: %sDestinationVersionFile%
  21.  
  22. SET /p sSourceVersion=<%sSourceVersionFile%
  23. SET /p sDestinationVersion=<%sDestinationVersionFile%
  24. IF "%sDestinationVersion%"=="" (SET sDestinationVersion=0)
  25.  
  26. ECHO .
  27. ECHO Application: %sSourceFile%
  28. ECHO Local Directory: %sDestination%
  29. ECHO Current Version: %sDestinationVersion%
  30. ECHO Availiable Version: %sSourceVersion%
  31. ECHO .
  32.  
  33. IF NOT EXIST %sDestination% (
  34. ECHO Making Destination Directory...
  35. MKDIR %sDestination%
  36. )
  37.  
  38. IF NOT %sDestinationVersion% == %sSourceVersion% (
  39. ECHO Installing latest Version of the Application to the Local Computer
  40. ECHO Please be patient, this should take no more than 30 Seconds...
  41. COPY %sSourceFile% %sDestinationFile%
  42. ECHO Copying Version File to Local Computer...
  43. COPY %sSourceVersionFile% %sDestinationVersionFile%
  44. )
  45.  
  46. START "MSACCESS.exe" %sDestinationFile%
Aug 23 '18 #8

Post your reply

Sign in to post your reply or Sign up for a free account.