I've been developing and writing code for Access databases for a long time, but there have always been network people around to do all of the installation work. I'm now developing a db for a small firm, at most 4-6 simultaneous users, not much traffic, no security issues (everybody can see everything), no run-time app, and I have to do the installation. There doesn't seem to be a need to set it up as a FE/BE application and the head of the firm, who has a bit of db experience, doesn't want to have to worry about coordinating front ends. So, do I just install Access on a shared drive and then create icons which pointing to it? Does MS require a site license? Anything else I need to know? Anything else I should keep in mind? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help installing a small multiuser db
- Thread starter rpochoda
- Start date
alvechurchdata
Programmer
You'll need the mdb on the shared drive and a copy of Access on each of the users' PCs. I don't know if you can get a Site License to enable everyone to share a single central copy of Access.
Geoff Franklin
Geoff Franklin
You will need Access on each user.
If you are NOT going with Front End / Back End, put the db on the server (or a shared drive) and then you need to change a couple of settings on each user in order for mulitiple users to acees data at same time.
On each user, go to Tools\Options then click on the Advanced tab. Select Exclusive and ALL Records.
I know this doesn't make much sense, but it's the only way I have been able to get mulitiple users to work on a network without splitting the db into Front End / Back End.
Thomas Bailey
a/k/a TomCat
If you are NOT going with Front End / Back End, put the db on the server (or a shared drive) and then you need to change a couple of settings on each user in order for mulitiple users to acees data at same time.
On each user, go to Tools\Options then click on the Advanced tab. Select Exclusive and ALL Records.
I know this doesn't make much sense, but it's the only way I have been able to get mulitiple users to work on a network without splitting the db into Front End / Back End.
Thomas Bailey
a/k/a TomCat
In the front end, create a module with a function to re-link the tables
Make a startup form to open a recordset from a small table in the back end
If you get an error, have the form call the above mentioned function
After re-linking the table, do whatever 'versioning' stuff you need for the back end
Put the front end on a shared drive
Make a batch file to copy the front end from the shared drive on client computers
Distribute the batch file to users.
You need either a copy of Access on each computer or the Developer Edition to pack the application in an installation package.
Some such useful functions can be found at
HTH
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Daniel Vlas
Systems Consultant
Make a startup form to open a recordset from a small table in the back end
If you get an error, have the form call the above mentioned function
After re-linking the table, do whatever 'versioning' stuff you need for the back end
Put the front end on a shared drive
Make a batch file to copy the front end from the shared drive on client computers
Distribute the batch file to users.
You need either a copy of Access on each computer or the Developer Edition to pack the application in an installation package.
Some such useful functions can be found at
HTH
Daniel Vlas
Systems Consultant
- Status
Similar threads
- Locked
- Question
- Locked
- Question