Connecting an access (2000) database

Question

Connecting an access (2000) database

maxwell

Grasshopper

Points: 20
More actions
March 3, 2003 at 2:40 am

#64505

I have a problem connecting an Access 2000 db to an sql server.
The access db is on a different server from sql, I have tried to add a login to linked server properties but is not working.
I recived an error 7399.
There is someone that have done a linked server like this?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Is the Access database secure database? Do you place 'admin' as remote login with correct password? Where did you get this error message, EM or QA?

maxwell Grasshopper Points: 20 More actions · Answer 2

Access db is not secure.

Error is generated by EM.

I found a note that suggested "The .mdb database file must reside on the server sql"; my problem is that .mdb database is on a different server, probably I have to change the location of access db.

Thank you

Data-Man SSC Veteran Points: 291 More actions · Answer 3

Hi, I just went through this a couple of weeks ago. Even though your access database is not secure it does require a login. Set the login to Admin with no password on the linked server properties security tab. Also, make sure that name under which SQL Server is started has access (permissions) to the directory where the access database resides.

maxwell Grasshopper Points: 20 More actions · Answer 4

Thanks

I've done what you suggested but it doesn't work.

Probably your access db was on the same server with sql.

Mine is on a different server and probably this is why I'm unable to connect to the access db

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

I guess you have registered SQL Server with NT authentication from EM. Change it to SQL Server authentication should work, at least it works for me when Access database is in different server than SQL Server.