Repoint an ADP front end to a different SQL Databse

  • Thread starter Thread starter James
  • Start date Start date
J

James

I want to use the front of one SQL database, as the front
end of the another SQL database. I know I could create a
new ADP file an import all the forms, reports etc.. But I
also want to use the built in toolbars.

Is there a way of repointing an ADP front end to a
different SQL Databse?
 
if the application (FE) isn't going to change, make a copy of the file and
use File>>Connect to point to the other SQL db. This assumes of course that
the new SQL db is the same structure, table names, etc.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
J> I want to use the front of one SQL database, as the front
J> end of the another SQL database. I know I could create a
J> new ADP file an import all the forms, reports etc.. But I
J> also want to use the built in toolbars.

J> Is there a way of repointing an ADP front end to a
J> different SQL Databse?

If another database is on the same server, then all you have to do is
specify its table names as database.owner.table where relevant. You can
construct queries from the joined tables from different databases as if they
were in one, this is transparent. Even if it's another server, you can link
it and then do pretty much he same (though that would be much slower).

Vadim
 
Back
Top