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

[smilbuta]

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!

[SunshineBH]

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

[jmcilhinney]

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

[smilbuta]

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.

[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?

[jmcilhinney]

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.