Linked tables

[Rachel]

Hi,
I have a query that takes data from a linked table (SQL
Server Database) and appends into a table within my Access
97 database. I would like to run a process overnight that
runs the append query, however when I run the query I am
prompted for the SQL server Login information. Does anyone
know anyway that I can set the login information in code
before running the query.

Many thanks for any help.

Rachel

 

[Alex Dybenko]

open query properties sheet, build odbc connection str, then when access
prompt to save password - click Yes

 

[Rachel]

Thanks for your reply Alex,

If I build in a Source Connect Str within the query it
won't let me use queries from the current database in the
same query. I need to restrict the amount of records being
returned as if I try and apply parameters to the query
from the SQL server table I get a ODBC Timeout Error. If I
use a lookup against the linked table it works ok, but
this is where it prompts me to enter username and password.

Do you have any other ideas?

Thanks
Rachel

 

[Alex Dybenko]

hmm, not sure i completely understand
but first you have to make a pass-throug query against sql server, with
saved password
then make another query, append query where you append records from first
quey to your table
HTH