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. 7 2365
Zlatko Matiæ 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 ? 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.
Wait for MS to fix Access so that it closes ODBC databases when it's
done with them?
--
[OO=00=OO]
?! :)
"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk... Zlatko Matiæ 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 ? 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.
Wait for MS to fix Access so that it closes ODBC databases when it's done with them?
-- [OO=00=OO]
Zlatko Matic wrote: ?! :)
"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj grupi:42***********************@news.zen.co.uk...
Zlatko Matiæ 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 ? 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.
Wait for MS to fix Access so that it closes ODBC databases when it's done with them?
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]
Right!
That bothers me too...
"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk... Zlatko Matic wrote: ?! :)
"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj grupi:42***********************@news.zen.co.uk...
Zlatko Matiæ 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 ? 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.
Wait for MS to fix Access so that it closes ODBC databases when it's done with them?
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 Matiæ 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 ? 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.
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
Hi!
No, I haven't used RefreshLink yet....I will try.
"Bri" <no*@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no... Zlatko Matiæ 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 ? 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.
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
TableDef.RefreshLink didn't help me.
Bye.
"Bri" <no*@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no... Zlatko Matiæ 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 ? 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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wolfgang Kaml |
last post by:
Hello All,
I have been working on this for almost a week now and I haven't anything up
my sleeves anymore that I could test in addition or change....
Since I am not sure, if this is a Windows...
|
by: Julia Baresch |
last post by:
Everyone,
I posted the message below back in February and didn't get any
information. I also wasn't able to find any documentation in MS Help,
web site, or other groups. I'm posting now with...
|
by: Alec |
last post by:
Hi All,
I am currently trying to link in Access 97 to a table in a MSSQL 7
server. Initially the link is fine, however, when I close the access
database and re-open it from the same network...
|
by: Crazy Cat |
last post by:
Hi all,
I am having trouble getting linked Oracle 9 server in MS SQL Server
2005 Express to work properly. My machine is running Windows XP.
The Microsoft and Oracle OLE DB Providers have...
|
by: somersbar |
last post by:
im trying to get a basic ASP.NET application running. im trying to
display data from a microsoft access database on my web form. im trying
to bind the data to a data-grid. but i get the following...
|
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in...
|
by: network-admin |
last post by:
We have Problems with Access query on Oracle 10g Database with ODBC
Connection.
The Query_1 is such as
select *
from xtable
where ycolumn <"S"
Result = ODBC Faild...
|
by: Salad |
last post by:
I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro...
|
by: Salad |
last post by:
With the database window open I click on Help, then click on "About
Microsoft Office Access". A dialog window is presented and there are 4
buttons at the bottom right of the form. One is...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |