Need Help Moving a MS Access 2002 Database to WinServer 2003

[kuau]

I was advised to submit my question to this forum:

I am new to Tek-Tips and new to a managed hosting Windows Server 2003. The managed hosting tech support is useless and I know zero about what is the best way to set things up. All I need is to allow 5 people access to one MS Access 2002 database on the server. I was hoping to control what part of the database they each see by having them use different mde files (Access front-end interfaces) which already exist. The 2 options I can think of are:

1. Have them run the front end on their local computers and access the backend via an ODBC connection.
2. Set up separate user accounts on the server, make them login, and put a shortcut on the desktop that would run the front-end mde for each of them.

I have no experience with Windows Server, but do know XP Pro. Any guidance would be greatly appreciated.

Thank you. kuau

 

[kalebson]

Are they going to be editing or just viewing?

 

[kuau]

They will be editing (one location will be adding items to inventory, another selling those items). [thanks for your willingness to help!]