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]
