S
srikanth puppala via AccessMonster.com
Hello,
I have a problem which i need some advice. I have a mdb connected to SQL
server 2000 and that server has 2 databases. I followed the below link to
create DSN for connecting those databases using a form in my mdb. When I
switch between those databases a seperate set of new tables are linked
everytime and they are numbered 1,2,3..so on. I tried goin to Linked table
manager in tools option and select the system DSN in machine datasource and
tried to link all tables to that particular database in sql server but they
wont change at one shot instead I have to repeat the same process for all
tables in the database. It will be very helpful if some have a clue for
this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316752
I have a problem which i need some advice. I have a mdb connected to SQL
server 2000 and that server has 2 databases. I followed the below link to
create DSN for connecting those databases using a form in my mdb. When I
switch between those databases a seperate set of new tables are linked
everytime and they are numbered 1,2,3..so on. I tried goin to Linked table
manager in tools option and select the system DSN in machine datasource and
tried to link all tables to that particular database in sql server but they
wont change at one shot instead I have to repeat the same process for all
tables in the database. It will be very helpful if some have a clue for
this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316752