Re: Linked Tables
- From: "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 15:09:29 +0300
You can save User ID & and Password with linked table connection string. Look at following code to find out how this can be done:
http://www.mvps.org/access/tables/tbl0010.htm
-- Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com
"jwalsh" <jwalsh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1CDCE179-3964-4674-B8DB-9C61C24ECE89@xxxxxxxxxxxxxxxx
I have used the upsize wizard to move tables from an Access 2000 database to
SQL server.
All works well. I have done a lot of work setting up the right relationships
between the tables to ensure data integrity.
I note that the Access database does not seem to use an ODBC connection to
the SQL database.
However, I missed one table, so I used the linked table manager, had to set
up an ODBC connection to the SQL database and linked the table to the SQL
database.
In the Access front end I now have a problem. A first time connection to
this table, from a form etc. the application asks for a User ID & and
Password ( ODBC set up with SQL authenticatiion ). I do not have this problem
with any other table on the SQL database.
Any ideas ?
.
- Prev by Date: JPEG llibrary
- Next by Date: Re: Scheduling Access?
- Previous by thread: JPEG llibrary
- Next by thread: Re: Scheduling Access?
- Index(es):
Relevant Pages
|
