ADP and linking to Jet tables

R

Rene

Hello group!

Is it possible? Linking to Jet tables from an ADP project? This is very
straightforward in .mdb files.

I've been pulling my hair for two days, and I just can't find a way. I'm
new to SQL server, and studying ways to migrate several instances of one
Access DB to SQL - my plan was queries on linked tables.

My Access DBs are secured - could that be a reason for my problems.

I've tried DSN, ODBC, Linked servers ... there's no way out.

None of the documentation I've read suggests it can't be done -

The error message I get when trying to link to an access table is:

method execute of object '_connection' failed

Thanks for the replies

René
 
S

SFAxess

Use ADO to accomplish this in an Access ADP. Access
Projects (ADP) are designed specifically for using SQL
Server. There is no "link table" wizards like in an .mdb.
If you are not familiar with ADO, the Knowledge base has
many examples to do whatever it is you desire.
You can also program SQL Server to get your data from
an .mdb file, but that is much more complicated,
especially since you are new to SQL Server.
 
M

Mary Chipman

No, this is not possible. An ADP is an OLEDB/ADO connection to a
single SQLS database, and linked tables are done through ODBC in Jet.
Jet is no longer present in ADP's, hence no links. You'd need to
create a linked server in SQL Server, then create views in the SQLS
database the ADP is based on that referenced the linked server.

FWIW, you'd be much better off if you just switched from ADP to mdb
and then linked in the SQLS tables as well as any Jet tables you might
be interested in. There's no simple scenario like that from an ADP.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top