Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

logout for ODBC source ?

66 views
Skip to first unread message

Zlatko Matić

unread,
Jun 2, 2005, 5:44:56 AM6/2/05
to
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 ? How to close all ODBC connections and enforce
new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Trevor Best

unread,
Jun 2, 2005, 2:24:02 PM6/2/05
to

Wait for MS to fix Access so that it closes ODBC databases when it's
done with them?

--
[OO=00=OO]

Zlatko Matic

unread,
Jun 2, 2005, 5:11:37 PM6/2/05
to
?! :)

"Trevor Best" <nos...@besty.org.uk> je napisao u poruci interesnoj
grupi:429f4ea6$0$24082$db0f...@news.zen.co.uk...

Trevor Best

unread,
Jun 2, 2005, 8:29:37 PM6/2/05
to

My experience with SQL Server and ODBC is that I open a database
variable and have linked tables. Everything is closed and db vars set to
nothing before I close the app. If I close the front end MDB from Access
it does not close the connection to SQL Server until I actually exit Access.

If I close and re-open the app without exiting Access and I log in as
another user I have the problem that my app thinks I'm somebody and SQL
Server thinks I'm somebody else.

You can imagine the problem if the server thinks that numpty logged in
ATM is an admin.

--
[OO=00=OO]

Zlatko Matic

unread,
Jun 3, 2005, 5:54:59 AM6/3/05
to
Right!
That bothers me too...


"Trevor Best" <nos...@besty.org.uk> je napisao u poruci interesnoj

grupi:429fa426$0$23699$db0f...@news.zen.co.uk...

Bri

unread,
Jun 3, 2005, 1:17:35 PM6/3/05
to

Are you doing the RefreshLink after you change the Connection? If not,
then the Links are not actually changed in memory. If you are already
doing this then there may not be a solution. I expermented with changing
the connection to invalid values and it errors on the RefreshLink.

--
Bri

Zlatko Matic

unread,
Jun 5, 2005, 4:48:09 AM6/5/05
to
Hi!
No, I haven't used RefreshLink yet....I will try.


"Bri" <n...@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no...

Zlatko Matic

unread,
Jun 5, 2005, 7:04:19 AM6/5/05
to
TableDef.RefreshLink didn't help me.
Bye.

"Bri" <n...@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no...

0 new messages