[2005] Prefered method of Connecting to a remote Access 2003 Database.

Hello community,

WHat is the prefered method fo connecting to a 2003 access database backend(tables only) using a VBNET 2005 front end application for distribution.


Please Dont ask why its access 2003 backend... that desision was made way above my pay grade...:(

THanx for any advice!

Some people dont deserve their pay to be sure

Try this wonderful website for all the different options.

http://www.connectionstrings.com/

Hope this helps

Where is the database located exactly, in relation to the clients?

The database is located on a system within our own network. It is accessed via a mapped drive.

As i understand the data is imported to the database in question from a third party location outside of my offices control. We simply have access to the Back end tables.

So .. We(meaning me) are developing a front end in VB.Net to acces the records in that table and to perform all necesary operations Insert , Update , Select and Delete.

Sunshine, thats a simple great site! THanxs!... I think it actualy answers my question flat out.

I guess the only question is do i open the database as a ADODB object or a DAO?? Does that make sence?

Quote:

---

Originally Posted by smilbuta

Sunshine, thats a simple great site! THanxs!... I think it actualy answers my question flat out.

I guess the only question is do i open the database as a ADODB object or a DAO?? Does that make sence?

---

Neither. You use ADO.NET in .NET applications. Follow the Data Access link in my signature for some code examples and there are numerous tutorials available. www.startvbdotnet.com has a page dedicated to ADO.NET with Access.