problem with odbc connectivity

[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

 

[Stefan Hoffmann]

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?

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 <--

 

[Guest]

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

 

[Stefan Hoffmann]

hi Raj,

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

Then you have stored the credentials while linking the tables, haven't you?


mfG
--> stefan <--

 

[Guest]

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.

 

[Stefan Hoffmann]

hi Raj,

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

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.

Then you may try ADODB.Connection.


mfG
--> stefan <--

 

[Guest]

Hi Stefan,

Thanks for your adodb suggestion. Now its working fine.

Raj