problem with odbc connectivity

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi experts,

Iam using Access2002, oracle 10g and odbc to connect.

I have 2 users, UserA with TableA update previliges and UserB can update
TableB. When I login in using my access program with UserB first and update
the TableB i am able to update successfully. But when I login in using UserA
and make some changes in TableA and close my program and then login back
using UserB, then i can not update the TableB. Though UserB have enough
privileges to update TableB database, I keep on receiving "insufficient
previligies" error while executing update statement.

I think this is because somewhere the connection is not getting closed
properly or retained.

Is there any way i can check or close all connections while closing the
access program?

Thanks in advance,
Rajesh
 
hi Raj,
Iam using Access2002, oracle 10g and odbc to connect.
I think this is because somewhere the connection is not getting closed
properly or retained.
Is there any way i can check or close all connections while closing the
access program?
Click to expand...
You need to close Access, not only your application as Access caches the
sessions.
So when you switch to user in your application, the "previous" session
is still active with the corresponding priveleges.


mfG
--> stefan <--
 
hi Stefan,

Thanks for your reply.

Yes I tried closing Access, compact and repair database and even restarted
my computer, but still it retains. Not sure why.

thanks, Raj
 
hi Raj,
Yes I tried closing Access, compact and repair database and even restarted
my computer, but still it retains. Not sure why.
Click to expand...
Then you have stored the credentials while linking the tables, haven't you?


mfG
--> stefan <--
 
Hi Stefan,

Again thanks for your reply.

Is it possible to have 2 connections at the same time to update 2 different
tables by 2 different users?

I just discovered that 1st connection is maintained throughout and 2nd
connection should just establish the connection to update few records once
and disconnect.
 
hi Raj,
Is it possible to have 2 connections at the same time to update 2 different
tables by 2 different users?
Click to expand...
Imho no, not when you use linked tables to the same database. You may
use an extra ADODB.Connection.
I just discovered that 1st connection is maintained throughout and 2nd
connection should just establish the connection to update few records once
and disconnect.
Click to expand...
Then you may try ADODB.Connection.


mfG
--> stefan <--
 
Back
Top