ADP Project Issues with Access 2010

[johnson8809]

I need to create an ADP Project that I need to work with sql server 2008. I want it to replace the current 2010 production access database I am currently using. Can I import the tables, copy over the forms and modules into the adp project and match the references? Can it be done with access 2010?

[ranman256]

I doubt it. Others my know a secret I dont.
Tho you can just link in all SQL tbls and run the Access db as normal.
(just rename all SQL tables to the exact names you had )

[ItsMe]

I need to create an ADP Project that I need to work with sql server 2008.

Can you elaborate? What is it that mandates your use of SQL Server? Are there already tables and data on the server that you need to connect to?

Also, ADP is, now, deprecated. I really do not see a need for the use of ADP. I suggest using SQL Server Native Client 11.0 ODBC driver and a dsn-less connection to work with SQL databases.