
Problem in Share-Level to User-Level, VB6,Jet4
Peter
See here
http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForMicrosoftJet
regards
Ian Williams
** invalid reply address, change dk to denmark
Tips & Tricks - http://tips.kingsoft-denmark.com
Quote:
> Hi - In the past I have run successfully with share-level security:
> cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
> cnn.Properties("Jet OLEDB:Database Password") = strPassword
> cnn.Properties("Mode") = adModeReadWrite
> cnn.Properties("Data Source") = strURL
> Now I have successfully converted the DB to user-level security using
> Access, but I have been unable to find the commands for sending the DB
> owner's name and password. Help would be very much appreciated!
> - Pete