Multiple Users - Access Db 2

[cwsstins]

I have an Access db that I need to set up for simultaneous multiple-user access. I need the db to be read-only (not sure how to do this either), so there would be no concern about multiple edits on the same record.

Background:
I administer a db application running on an Oracle backend. I've got remote users who are trying to access a module of this application. This particular module has presented performance problems for them, so I plan on setting up the Access db in a centralized location at the remote site. Data from the Oracle db would be transferred to the Access db on a daily basis. All changes would be made to the Oracle db, no changes will be made to the Access db. In testing, the performance has dramatically improved.

The problem is, I'm not familiar with Access and I don't know how to remove exclusive locking to enable multiple users to access the db at the same time. Also, I am not sure how to ensure that it is a read-only db.

Thanks,
stinsman

 

[psemianonymous]

Go to the NTFS folder permissions and disallow anyone from modifying/creating/deleting files in the folder; this will force read-only on them. I believe if you do this they will get an error message when opening the database for the first time; also if you use things like temp tables for reports, these won't work of course.

 

[Remou]

I think that a Front End (FE)/ Back End (BE) set up may be what you need. All the front end forms can be locked for edits and additions or based on read-only queries. You will find a great deal of information on this type of set-up in both the FAQs and posts in various fora.

 

[cwsstins]

I'll take a look at some FAQs...but I should mention that there are no forms or queries. Tables only...the application itself provides the interface. My major problem is getting it accessible to multiple users...how is this done?

 

[Remou]

The general idea is to put your Back End, which contains all the imported tables, in a shared directory. Then create a Front End for each user, which contains tables linked in from the Back End. This can be done by code. The Front End can be opened read only or you can use Access security. You may wish to look at:
FE / BE and Security
thread700-1121353
Splitting a database...How to do Front end and Back end.
thread700-1112451
Preventing Write access to linked tables
thread700-1074085

 

[cwsstins]

Remou thanks...that helps!

 

[psemianonymous]

You can't get a simpler solution than "make your IT department set the NTFS permissions to read-only". You can't. It takes them about a minute to do.

 

[cwsstins]

Pseale, thanks for your reply as well. My primary issue here is that I need to enable multiple users to access the db simultaneously. But here's a star...