if i need to do a make table query

[csunsun]

if i need to do a make table query to a destination table in an outside database that is password protected, how do i tell the query what the password is so the table can be made?

thanks!!!

 

[sguslan]

You can not do that !
Create a linked server to the target SQL database server. Search SQL Books Online for "sp_addlinkedserver".

One that is done, use the following DDL according to your need:

create table linkedservername.targetdatabasename.dbo.test(
id int,name char(20)) .....

________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[JamesLean]

Also, it sounds like you are using Access? If so, you should post this question in the relevant Access forum.

--James