Hi
Haven't had much exposure to Progress so excuse me if this sounds dumb. We use Progess 9.1D and I have created a DSN using the Merant 3.6 SQL-92 Progress driver. I wish to view the table in MS-Access as a linked table. I can link it fine to the table I want to view and when I do I get the prompt to enter the password and all is okay. However if I then quit out of Access and go back in and try top open the table view I don't get the password prompt, only an Progress Access Denied error. Any ideas how I can automate the passing of the password over to the link as I can't save it in the DSN? Thanks.
Haven't had much exposure to Progress so excuse me if this sounds dumb. We use Progess 9.1D and I have created a DSN using the Merant 3.6 SQL-92 Progress driver. I wish to view the table in MS-Access as a linked table. I can link it fine to the table I want to view and when I do I get the prompt to enter the password and all is okay. However if I then quit out of Access and go back in and try top open the table view I don't get the password prompt, only an Progress Access Denied error. Any ideas how I can automate the passing of the password over to the link as I can't save it in the DSN? Thanks.