Thanks, I'll check it out
Gustav Brock <[EMAIL PROTECTED]>
06/07/2004 09:45 AM
Please respond to Gustav Brock
To: [EMAIL PROTECTED]
cc:
Subject: Re: MaxDB, ODBC, and ADO question
Hi James
OK. Within the current session you probably need to:
First, relink the TableDefs using the new User ID/Password.
Then, either use CurrentDB or use DBEngine with a refresh of the
TableDefs collection:
DBEngine(0)(0).TableDefs.Refresh
For a developer Access list visit:
AccessD mailing list
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
/gustav
> Date: 2004-06-07 15:25
> That is correct, I am trying to use access only as an application (no
> security at all within Access), then I want to connect to the linked
> tables using the MaxDB security. What I have currently is one user
who
> has read only rights and aother that has update, and I want to be able
to
> log on with the read user, then if for some reason I need to do an
insert
> or update; break the ODBC connection and re-establish it as the update
> user.
> I have got the app to prompt me only once for the user ID and Password,
> but I still haven't been able to break the ODBC connection and
> re-establish it under a new set of credentials, that's why I thought
since
> I no longer have any issues with the MaxDB ODBC connector, I should take
> this question to an Access forum as what I am attempting is an Access
> issue.
> Thanks for the help though.
> James
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
