Hi All,
I have been developing an Information database over the past couple of months and now I am ready for users to be able to use it.
But before I do so I just need some help with a few things in regards to multiple users.
I need to find out the easiest and best way to deploy this to Multiple Users, at multiple sites Nationally (and possibly eventually Internationally) so that I can also still edit and make changes to the database. (possibly up to 100 users?)
I DO NOT want to set up Users and Groups.
I will be doing this at the folder level (via an ACL) where this database will be located and at this stage only I will have Admin rights to it.
The questions I need help with are:
· If I split the database into FE & BE, and make the FE available to users does it matter where the BE is located? Does it need to be in the same location (drive) as the FE? (obviously not in the same folder).
· How can I set it up so that multiple users can be running queries at the same time, and also allow me to make changes to the database without it locking up? (can I make changes in the BE if multiple people have the FE open and some running queries etc)?
· Is the ONLY way to make changes to the design in the FE to have everyone out of the FE?
· The database will be saved in a folder on a Shared Network Drive, since this will be used by multiple users nationally, will it be ok for them to all just access this one FE file from the Shared Folder? ( I have read about doing shortcuts etc to the database on each individuals desktop but then have to update it when changes are made to the FE? Is this correct?)
· Pretty much the same question as above, but does each user need to have their own copy of the FE file? Is this the only way? Or can multiple users access the one FE file??
Then if I need to make changes to the FE (which wont happen too often), I would need to supply them all with a new FE?…not sure how feasible this will be when there may be 100’s of users using the database
· We have an internal portal/intranet, I can set up a link on here to open the database (FE) from the Shared Folder, will this be ok as it will mean everyone is going to be using the same FE?
· Just confirming I can make just the FE an MDE file? Can I do that? Is this required if I make my ACL to the folder ‘Read Only’?
I will disabled the access for users to get into the Design View etc, this isn’t really my main issue, I ideally just need to know the best EASIEST way to make it accessible to many users so that I can still make changes.
Sorry for the million questions, but as you can tell from my Username I am certainly ‘No Access Guru’ and no IT person, so ‘idiot proof’ help would be greatly appreciated!
Thanking you all in advance
P.S - Sorry if this has all already been covered in previous threads etc....I dont have time at the moment to try find it all haha, but will go through when I can.....thanks again!