Authentication for Linked Access database

#1

The Access 97 I tried to link to has no login password. Every tiem I tried
to access a table, if gave me the authentication failed error. What should
I do to remedy this?
Thanks
Bill

#2

Hi Bill,

Sorry, I'm not sure the situations on your side. Could you please post the
exact reproduce steps and error message?

I'm looking forward to hearing from you.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Quote:

From: "Bill Nguyen" <billn (AT) jaco (DOT) com
Subject: Authentication for Linked Access database
Date: Fri, 22 Aug 2003 16:22:38 -0700
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <eGWi4PQaDHA.1004 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.tools
NNTP-Posting-Host: 66.162.157.201
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:19414
X-Tomcat-NG: microsoft.public.sqlserver.tools

The Access 97 I tried to link to has no login password. Every tiem I tried
to access a table, if gave me the authentication failed error. What should
I do to remedy this?
Thanks
Bill

#3

Hi Bill,

I noticed that you have posted the question titled"Can I create a link
server from an Access Database?" in the microsoft.public.sqlserver.tools
newsgroup and a community member has posted a response to your question. I
have added some supplements also.

Please reply directly to the thread with any updates and your feedback
regarding your experience on this specific issue.

Please let me know if this solves your problem or if you would like further
assistance.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Quote:

From: "Bill Nguyen" <billn (AT) jaco (DOT) com
References: <eGWi4PQaDHA.1004 (AT) TK2MSFTNGP12 (DOT) phx.gbl
IgLRMmTaDHA.1928 (AT) cpmsftngxa06 (DOT) phx.gbl
Subject: Re: Authentication for Linked Access database
Date: Mon, 25 Aug 2003 10:22:46 -0700
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#0gay0yaDHA.2296 (AT) TK2MSFTNGP09 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.tools
NNTP-Posting-Host: 66.162.157.201
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:19441
X-Tomcat-NG: microsoft.public.sqlserver.tools

William;
Here are the steps:
1. Linked servers
2. Linked Access database name (Petrotel in this case)
3. Click on "Tables" to view all Access tables:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
Authentication failed.
OLE DB error trace [OLE/DB provider "Microsoft.Jet.OLEDB.4.0'
IDBInitialize:: Initialize returened 0x800e4d: Authentication failed.]
In Access linked server properties, Security set to:
Local login: sa and Impersonate checked.

Thanks
Bill

"William Wang[MSFT]" <v-rxwang (AT) online (DOT) microsoft.com> wrote in message
news:IgLRMmTaDHA.1928 (AT) cpmsftngxa06 (DOT) phx.gbl...
Hi Bill,

Sorry, I'm not sure the situations on your side. Could you please post
the
exact reproduce steps and error message?

I'm looking forward to hearing from you.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
| From: "Bill Nguyen" <billn (AT) jaco (DOT) com
| Subject: Authentication for Linked Access database
| Date: Fri, 22 Aug 2003 16:22:38 -0700
| Lines: 7
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eGWi4PQaDHA.1004 (AT) TK2MSFTNGP12 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.tools
| NNTP-Posting-Host: 66.162.157.201
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:19414
| X-Tomcat-NG: microsoft.public.sqlserver.tools
|
| The Access 97 I tried to link to has no login password. Every tiem I
tried
| to access a table, if gave me the authentication failed error. What
should
| I do to remedy this?
| Thanks
| Bill
|
|
|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Authentication for Linked Access database

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Authentication for Linked Access database - 08-22-2003 , 06:22 PM

RE: Authentication for Linked Access database - 08-23-2003 , 12:43 AM

Re: Authentication for Linked Access database - 08-25-2003 , 09:25 PM