Link to .mdb online

B

BrianS

I'd like to link my local Access DB to an Access DB that resides on my
web-site. I'm not sure how to create the ODBC connection, and not sure how to
link it with my local database. Any help would be greatly appreciated.
-Brian
 
B

BrianS

Isn't there a way to do it through queries, not an actual linked table?
What about pass-through queries? (which I don't completely understand)
 
R

Rick Brandt

BrianS said:
Isn't there a way to do it through queries, not an actual linked
table? What about pass-through queries? (which I don't completely
understand)
Click to expand...

No. Passthrough queries work by sending SQL statements to a database
*server* like SQL Server or Oracle. There has to be a program running on
the remote box to receive the SQL, process it, and then send the results
back. When you store data in an MDB you have no such service program
running.
 
Top