How to change a user and a pass to linked table programamticly

U

Uri Dimant

Hello

I have an Access (97) database with linked tables to SQL Server with user
'sa' and password 'bla'

I'd like to write a macors to change the user and password for linked
tables to 'user' and password 'nothing'

Could you please provide some exampes , as I would not want to drop the
tables and -re-create them with a new user and password ( I have 100 tables)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Embed the same Excel multiple times 0
Change\handle passwords on linked tables 3
How pass credentials to Access from Excel (for onward use) 5
Embed Username & Password in Oracle External Linked Table 1
multiple odbc login screens 4
How to configure the user and password for MySQL 2
How to manage SQL Server authentication in Access2007 1

Top