Repoint an ADP front end to a different SQL Databse

[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?

 

[Kevin3NF]

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

 

[Vadim Rapp]

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

 

[James]

Thanks for your help, I've sorted it now.

 

[James]

Thanks for your help, I've sorted it now.