Connecting to MS Access DB on remote system on LAN using VB.NET - TechRepublic
Question
January 14, 2007 at 03:46 PM
fatali8

Connecting to MS Access DB on remote system on LAN using VB.NET

by fatali8 . Updated 19 years, 6 months ago

I’ve been working on a program in Visual Basic.NET 2003 for the last few weeks that uses an Access 2003 database to store and retreieve information.

I used OLEDB and it worked fine… as long as the database was on the local machine or it was in a shared, mapped drive on a server.

My problem is I can’t get it to connect without the shared folder being mapped. I would very much rather it not have to be mapped, but I don’t want to have to switch to a different connection type (SQL, ODBC, ect) because I would probably have to re-write all the databindings and navigational coding in 4-5 forms.

Can anyone help with this? I’ve googled for 2 days and I have posted to more tech forums than I can remember but I haven’t been able to find any help.

This discussion is locked

All Comments