UtterAccess.com
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    
 
   
adam999
post Sep 10 2017, 06:41 PM
Post#1



Posts: 7
Joined: 4-May 12



Hi,

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.

Thanks,
Adam.
Go to the top of the page
 
ScottGem
post Sep 10 2017, 07:03 PM
Post#2


UtterAccess VIP / UA Clown
Posts: 32,183
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
 
adam999
post Sep 10 2017, 07:10 PM
Post#3



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?

Thanks,
Adam.
Go to the top of the page
 
GroverParkGeorge
post Sep 11 2017, 08:17 AM
Post#4


UA Admin
Posts: 31,245
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
 
AlbertKallal
post Sep 11 2017, 12:49 PM
Post#5


UtterAccess VIP
Posts: 2,551
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.

Regards,
Albert D. Kallal (Access MVP, 2003-2017)
Edmonton, Alberta Canada
kallal@msn.com
Go to the top of the page
 
adam999
post Sep 12 2017, 05:45 AM
Post#6



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.

Thanks,
Adam.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 10:18 PM