Linked tables

  • Thread starter Thread starter Rachel
  • Start date Start date
R

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
 
open query properties sheet, build odbc connection str, then when access
prompt to save password - click Yes
 
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
 
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
 
Back
Top