Ask a new question

Converting ADP to MDB Can not import or link queries

I need to convert a database from ADP to MDB.  Everything can be linked to or imported except the queries on the server. 

How can I get these queries easily?
Thanks, Harold Menzel
This may be a little late, but if you are referring to the SQL stored procedures, they are not accessible via linking.  You have to write VBA code or pass-through queries to execute them.  You could also convert the simple ones (no parameters) to views.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thanks, I went into design mode SQL mode on the queries, copied the SQL and pasted into the new application.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Harold

SELECT queries in an ADP are actually views. You should be able to link to them as if they were tables.

Bill Mosca
ThatllDoIT.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 637 Applies to: