multiuser

[ianatkins]

i need to make my database available to 3 users, all of which have interent access.

I dont't really want to deleve into asp, is there any there alternatives.

Can I split the data out of the database, and make access connect to that?

Or is there anyway that the users could upload the database after using, and the exisiting version would be combined with the updated one?

Thanks for any help!

 

[Autoeng]

Are all of your users in the same location? Is there some reason why you don't want them to use Access directly. Access offers Data Access Pages but they are limited in the ways you can retreive information. Give some more detail of what you are trying to accomplish and we'll see if we can help.

My first thought is to develop a split and secured db that way you have the full power of Access available.

Autoeng

 

[ianatkins]

All 3 users are in different locations.

The database is a contact management system. So all 3 users are going to be logging calls, and all 3 need to see what each other has called about.

thanks
ian.

 

[Autoeng]

You have a couple of choices here.

Most preferable choice. You can split your data base and deliver the same front end (forms, queries) to each user and locate the back end (data tables) on a central server which all can access. Securing would also be recommended. I don't have a lot of experience with making contact to a database from outside locations so I would suggest that you search for more information in the forums concerning that.

Or you can export and link your Access information in an Excel spreadhseet format which you could post on your website.

Or you could create a webpage that imports specific information into fields that you create.

Or you can create Data Access Pages which are not very user friendly when it comes to searching for particular records (you have to navigate through every record one at a time instead of being able to jump to one in particular).

Autoeng

 

[MikeAngelastro]

I know of an instance where the Access database is referenced by a link on a web page. As long as the folks had MS Access installed on their machine, it worked. However, they did not do any data updates.