link access database tables and remote sql serverdatabase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an access project linking to a remote sql server. I would
like to link to my local access tables in this project as well. I can not
connect to local access tables while I am connected to the remote sql server.


How can I link to my local access tables in the same project? Is there a
new version of access that allows me to do this?
 
This would be useless because an ADP project has no local JET dbengine.
Even if you could link to them, you could do nothing with them.
 
However, you could etablish a linked server on SQL-Server linked to your MDB
file or use DAO or ADO to make some queries on a local MDB file.
 
As Sylvain states, you cannot link to and MDB file from an ADP. When using
Access projects, I usually have a second MDB front-end to do much of the
reporting, so that I can make use of VBA in my queries. You can connect to
multiple different database engines using an MDB (in fact that one of the
main reasons it was named Access).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top