How to use Access on LAN

[rubis]

Hi,

I would like to create a database and use it on LAN with 10 users accessing it. I prefer to write an EXE program in VB coz I don't want to install Access on every user machines. My requirement is each user can access to different part of the DB e.g. some can add data into tables and some can't. As I'm a new babe, pls suggest me about it. Any advice would be greatly appreciated..

Thanks,

 

[LLudden]

I'd suggest using an SQL server (MSDE) on the server for data instead of Access. Its more robust and faster. As to doing the front end in VB, you can, but its quite a bit more develeopment time. An alternative there is to get the Office Developers Kit and install the Access Runtime version to run your access front end without having to install office on each computer.

If you do decide to go with Access as a backend, just put the datafile on the server and give the users read/write access to it.

 

[rubis]

LLudden,

Do you mean give the read/write access to users through VB application or to read/write MDB file through user profile??

 

[LLudden]

The users will need sufficient file level access on the MDB file to read and write to it. One of the reasons SQL is a better system is that because users have access to the data from all programs (even shell), they can do "other" things to it (delete).