Sharing Access over WAN
Hi
I want several users who don't have Access on their machines to update the same backend tables. Should I use SQL as the backend, or is there a better solution?
I want several users who don't have Access on their machines to update the same backend tables. Should I use SQL as the backend, or is there a better solution?
You don't speak much of how the updates are triggered - is it an application you control, web pages, or something else? This may affect whether you decide to use ODBC or another connectivity technology (ADO/DAO).
Sticking with Access is okay, as long as you setup your locking correctly, and you don't expect amazing performance. This is possible to do, without installing Access on any of the computers, as the Jet driver has been part of the standard distribution of data drivers for some time.
You can quickly get into the database by setting up an ODBC data source which uses the Jet engine, link it to your shared database file(s) on the network, and go!
Sticking with Access is okay, as long as you setup your locking correctly, and you don't expect amazing performance. This is possible to do, without installing Access on any of the computers, as the Jet driver has been part of the standard distribution of data drivers for some time.
You can quickly get into the database by setting up an ODBC data source which uses the Jet engine, link it to your shared database file(s) on the network, and go!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We haven't set up the database on the user's machines yet. They don't have Access. I think that we will have to use the Access runtime
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all for the input
(and see my comment in your other Q that just closed)
mx