I mapped E drive to the share and tried to create the linked server with E:/samInfo.mdb.

It is showing all data if I connect to the SQL server through remote...

I copied the database to a local drive and created the linked server with C:/SamInfo.mdb

It is working fine everywhere .

Any idea?

Still giving me the same error.

I tested another method . Mapped a drive in the SQL server to the share. And gave E:/SamInfo.mdb as the location .

Again it is...

Actually its not a stored procedure . Its a view to see the data from the linked access file

select * from OPENQUERY([VIMachine], 'Select * from DataFile')

In query...

Yes you are right. I created the linked server in the server. If connect to that server using remote console I am able to execute the stored procedure .

My login...

What is the authentication that you are using on your local machine?

Windows Authentication . My useris has Administrative rights. My pc is also in the same network...

No. All our web pages are connected to SQL Server 2000.

This data is in a machine on the same network , as an access file. I need to get...

The linked server I am creating (SQL Server 2000 MAchine) is our Production server. Nobody cannot logon to that machine (remote desktop ) except administrators.

If other engineers needs to...

I am getting the same error message for select * also.

I gave the sharing security for everyone and my login name full control . But if I go to the...

Again I am stuck at EXEC sp_tables_ex 'VIMachine'

It is giving me the error Microsoft Jet database engine cannot open the file '\\ampcs04\Test\SamInfo.mdb' , It is already opened exclusively by another...

I followed the same procedure , and created the share on Access machine with Everyone Full Control.

After that I ran the query Exec SP_TABLES_EX 'VIMachine'

it gives me the same...

Here is the scenario .

I am connecting to the MSaccess database from the production server. If I logon to the server , I am able to see the database...

Thanks much. This works. There is a small problem with this. If I log on to Query Analyser using sa user id and if I run the query

select *...

If I create a DTS, I am able to conenct to this Access file on different server and able to see the Data tables.

Why the linked server is not working?

thanks

I am logging into SQL Server with SQL server authentication