Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 21st, 2003, 04:30 PM
Registered User
Join Date: Oct 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Retrieve data from local Access files

We are currently running a VB6 application that uses ADO2.6 to access data from MsAccess files specified by the user (the application is installed on each user's machine). The database files are used via the application's File New/Open/Save menus and can reside locally or anywhere in a network. Each user will typically have many database files in his "project" which he will open and work with, one at a time.
We are considering converting to .NET where the application will sit on a Web server. Is it possible to :
1) use MsAccess databases using ADO.NET (I get the impression that SQLServer is "the thing")
2) can the user via the .Net application specify the path to his desired MsAccess file and open it. The file can sit anywhere on the network or client. (I have again the impression that .NET applications using ADO.NET use one central database sitting on the server only?)
Any input, anybody ? Thanks !
Old October 21st, 2003, 04:40 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

1) yes. ms access can be used with ADO.NET, but if you have SQL Server, use it instead. Access does not do well on the web.
2) If you are using ADO.NET programatically, you can have the user select a file with the file dialog or something simmilar and use that for the source of your ADO.NET code. There is not much difference in that respect.
I haven't worked extensibly with ado.net, but it is much nicer than ADO.

Old October 31st, 2003, 08:52 PM
Registered User
Join Date: Oct 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks !
Can you then tell me what connection Object/String to use to connect to an MSAccess database ? What must the Provider keyWord be ? When I finally deploy my Windows application (this is NOT a Web application), do I need to include special files (something like the Database Jet Engine) in order for my application to work with Access ?

Finally, are there any books you would recommend on ADO.NET in Windows Forms Applications that also addresses Access as a DB and not only SQL Server ?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot retrieve string data in CSV and Excel files ajimi VBScript 13 March 19th, 2008 09:59 AM
Write data from access database to text files hayley Classic ASP Basics 1 February 1st, 2005 08:54 AM
data from txt files to access db citizen99 Access VBA 3 January 25th, 2005 12:50 PM
How can I retrieve data from Access dadabase in PD imfriend Classic ASP Databases 1 January 12th, 2004 10:49 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.