By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

closing ODBC connection ?

P: n/a
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? I would like to allow users to login/logout
consecutively from MS Access front-end without need to close front-end.
I tried to perform new login with the same login form after already being
login, but it seems that Access accepts even wrong passwords after
connection
once established (!?) It seems that consecutive login does not affect at
all, after ODBC connection was once established...If you give correct
username, new DSN-less connection will be accepted even if the password is
wrong...tabledef.RefreshLink didn't help...
So, I think that I have to close all ODBC connections (linked tables,
pass-through queries) somehow and the enforce new login. How to do it ?

Also, I tried to use pg_shadow system table for inspecting whether password
is OK, but it seems that password is encrypted, so Access can't compare
password from pg.shadow and password on the login form. What to do in order
that Access can see actual password from pg_shadow ?

Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 5 Jun 2005 12:54:50 +0200, "Zlatko Matić"
<zl***********@sb.t-com.hr> wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? I would like to allow users to login/logout
consecutively from MS Access front-end without need to close front-end.
I tried to perform new login with the same login form after already being
login, but it seems that Access accepts even wrong passwords after
connection
once established (!?) It seems that consecutive login does not affect at
all, after ODBC connection was once established...If you give correct
username, new DSN-less connection will be accepted even if the password is
wrong...tabledef.RefreshLink didn't help...
So, I think that I have to close all ODBC connections (linked tables,
pass-through queries) somehow and the enforce new login. How to do it ?

Also, I tried to use pg_shadow system table for inspecting whether password
is OK, but it seems that password is encrypted, so Access can't compare
password from pg.shadow and password on the login form. What to do in order
that Access can see actual password from pg_shadow ?

Thanks.

Hi

Are DSN-less connections ODBC?
For ODBC you might be able to see what is going on by switching
tracing on. Be careful not to leave it on though as it produces a lot
of output!
David

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.