Various users accessing a DB on a network.

[bacalaoyalcapurria]

Hello,
There are some things I still don't know about Access, but I'm learning.
I created an Access database and this database will be residing on a network. My question to you is, Can more than one person access the database at the same time without having any problems? Data entry will not be allowed by anybody but me. Currently, it has a form where one can select from several combo boxes a "criteria" and a report will pop up based on the criteria selected.
Does it has to be turned into an application? If so, how can I do that?

Thanks,

Rita

 

[fneily]

If you're on an INTRAnet, just place the Access database on the server and let the users play with it there. Since, they're not doing any data entry, no problems.
If they're going to create their own queries, forms, and reports, and you're on an INTRAnet, then you might look into splitting the database into front end, back end.
If they're on the INTERnet, a simply way is to have a Citrix (

http://www.citrix.com)

server and let them login remotely to the database.
If you're daring and have time, you can create Data Access Pages (DAP's) for the INTERnet. Actually, since they won't be doing any data entry, this might not be that bad. But they won't be able to create their own queries, forms and reports.
So you would have to look at the type of network, how many users, future abilities of the users.

 

[psemianonymous]

The simplest answer to this is:

As long as you're the only user with write ability, you can have a large number of read-only users. To ensure everyone else is set as read-only, have someone set the folder permissions to limit everyone to read-only access and set you in a privileged group with read/write/create/delete access on the folder. This way everyone else can get in, but they absolutely won't be able to touch the data.

This is by far the simplest solution.

By folder, I mean your standard Windows file share, e.g. \\servername\share\yourdbfolder.