X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Software Requirements: .net Application, Access 2003    
post Sep 10 2017, 06:41 PM

Posts: 7
Joined: 4-May 12


We have a .Net application which connects to a Microsoft Access Database file. If the client has .Net Framework V4.0 installed are there any other requirements to connect to access database?

Trying to confirm if the client will need any other software like Access runtime for the connection to work.

Go to the top of the page
post Sep 10 2017, 07:03 PM

UtterAccess VIP / UA Clown
Posts: 32,198
Joined: 21-January 04
From: LI, NY

Yes an ODBC driver for Access

Scott <>
Scottgem's Blog
Microsoft Access MVP since 2007
Author: Microsoft Office Access 2007 VBA
Go to the top of the page
post Sep 10 2017, 07:10 PM

Posts: 7
Joined: 4-May 12

Thanks for the details.

If Microsoft Office is installed would the ODBC driver be installed?

If not, would you have any recommendations on what would be the easiest to install to get the ODBC driver?

Go to the top of the page
post Sep 11 2017, 08:17 AM

UA Admin
Posts: 32,146
Joined: 20-June 02
From: Newcastle, WA

I have three thoughts.

Does the current version of your .net application not connect to the accdb now? If not, then, yes, you need additional software. If so, then, no your application doesn't. So, you can address that part of the question directly from your own environment.

The other thought I had was to ask why you are using an accdb as the datastore for a .net application? Wouldn't it be more robust to use a server based database like SQL Server or MySQL?

Also, how does the current .net application connect now? ADO? or ?? That will help determine whether you need additional software, such as an ODBC driver.

Go to the top of the page
post Sep 11 2017, 12:49 PM

UtterAccess VIP
Posts: 2,572
Joined: 12-April 07
From: Edmonton, Alberta Canada

Actually, if you still using “mdb” format, then you don’t have to install anything since “JET” is included with windows.

However, if you using accDB format, then you have to install the ACE “connectivity” components.

So you can avoid having to install the access runtime, but if you using accDB formats, then you have to install additional software. That additional software can be just the ACE data engine, or you could install access runtime.

Albert D. Kallal (Access MVP, 2003-2017)
Edmonton, Alberta Canada
Go to the top of the page
post Sep 12 2017, 05:45 AM

Posts: 7
Joined: 4-May 12

Thanks for the replies everyone.

Currently, we have a small Access application(MDB). The client has requested we remove the requirement for Access to be installed, they are fine if we use Access as a data store.

We have tested a small .Net application on a PC which does not have Access installed and there appears to be no issue connecting via 'System.Data.OleDb'.

Appreciate everyone's response.

Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    25th March 2018 - 12:37 AM