MS Access Table which links to a progress table

[dd501]

Hi, I have a system DSN setup which links to our progress database. I also have a table in MS Access which links using the DSN connection to a table in our progress database.

But when I open the table in Access it prompts for the user ID and password to connect to the external data source. (attached screenshot)

My username and password I use for Progress works when I enter it and opens the table. But is there a way I can open they access table automatically without the prompt?

Maybe create a second data source connection with the username and password already entered? And then link the access table to that?

Many Thanks for any advice

 

[LarryD]

This is from the Progress Kbase:

These instructions work with both the Merant 3.60 driver and the SQL-92
ODBC Driver.

1) Create a File DSN (instead of a System DSN or
User DSN) through the ODBC Data Source Administrator.

2) Once created, test the connection, and then modify the
file just created (by default this file is kept in the directory:
C:\Program Files\Common Files\ODBC\Data Sources). Using a text
editor (such as, Notepad), add (or modify) the following lines:

UID=<userID>
PWD<password>

Example of a "SQL-92" File DSN after the modifications:

[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL-92 v9.1B
UID=sysprogress
PWD=s
HOST=pchost3
PORT=9999
DB=sports

Once this is complete, do not modify or save the File DSN through the
ODBC
Data Source Administrator. It will overwrite the file that was modified.
If it is saved, the two lines will need to be added again.

Third party ODBC applications, such as Excel, calling the data source
connecting to a Progress Database will no longer prompt for a User ID or
Password.

 

[stevephillips79]

Hi,
I have a system DSN setup which links to our Progress database.Even I also have a table in MS Access which links using the DSN connection to a table in our Progress database.
Thank you



--------------------------------------------------------------------------------------------------------------------------

Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups seo specialist