Group:  Microsoft Access ยป microsoft.public.access.odbcclientsvr
Thread: How to change linked table automaticly

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How to change linked table automaticly
"Uri Dimant" <urid[ at ]iscar.co.il> 20.12.2005 13:50:37
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

Thanks






Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net