Access Problems

L

Ldaled

Hello All,
I have some users having problems doing certain operations that they are
normally able to do. I wanted to see if any of you can help me out with
suggestions towards a resolution.
So we have several Access DBs they all coneect to various DBs on a SQL
Server 2000 box. When users attempt to use certain macros or views etc. they
get the following error message:

ODBC--call failed.[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'jleland'. (#18456)

it does not appear to be a permissions issue as the above listed user acct,
jleland, is a DBO on the SQL box as well as SA. I am sure any of you who
answer will need more info, so I will be watching this forum all through the
day so go ahead and post any questions that I can answer for you to diagnose
this issue, I am at a lost.
thanks in advance people.
 
L

Ldaled

Hi Bill, thanks for your response. The password for jleland was correct
however, there was some info I did not know on Friday when I posted this. So,
oua Access app is a UI for one or two databases on an SQL box. The macro that
a few users were trying to run in access was what was crashing. It was
attempting to connect to a second SQL box in one of our other domains. the
user acct jleland no longer existed in the second domain and the second SQL
box, hence the login failed error.
Just thought I would let yall know for future reference.
Thanks again.

~LDD

Bill Edwards said:
The password that jleland is using to connect to SQL server is not correct.

Ldaled said:
Hello All,
I have some users having problems doing certain operations that they are
normally able to do. I wanted to see if any of you can help me out with
suggestions towards a resolution.
So we have several Access DBs they all coneect to various DBs on a SQL
Server 2000 box. When users attempt to use certain macros or views etc.
they
get the following error message:

ODBC--call failed.[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'jleland'. (#18456)

it does not appear to be a permissions issue as the above listed user
acct,
jleland, is a DBO on the SQL box as well as SA. I am sure any of you who
answer will need more info, so I will be watching this forum all through
the
day so go ahead and post any questions that I can answer for you to
diagnose
this issue, I am at a lost.
thanks in advance people.
Click to expand...
Click to expand...
 
Top