connectind to different databases

[romiorojo via AccessMonster.com]

I have and application that is under modification.I have an 2 access
databases. The first database is connecting to the 2nd one which in turn has
links to sql server database. The first database does not have links but has
dao code to pick the data from the second database. The code looks like"
insert into tab1 select * from tab2 in database2" where tab1 is in the first
database. The problem is coming when database 2 is referencing to tables
linked to sql server. what do I need to specify to make it work ok. Is there
any DAO connection string code that can be supplied within the sql statement
as I have many statements like this one. I will really appretiate if I can
get some help.

 

[Alex Dybenko]

Hi,
I think best solution - if you link tables from SQL server to both
databases.
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[romiorojo via AccessMonster.com]

I cannot have links in my first database since there are other restrictions
and the users will have to create a DSN on the PC using the application. I
really need some solution faster as I am approaching a stage where I will
have to recomend something and start working on it. Please help. I need code
which I can put in the statement mentioned below which connects and moves
data across at this time itself.

Hi,
I think best solution - if you link tables from SQL server to both
databases.

I have and application that is under modification.I have an 2 access
databases. The first database is connecting to the 2nd one which in turn

[quoted text clipped - 11 lines]

as I have many statements like this one. I will really appretiate if I can
get some help.