Solved

Visual Basic 2013 Application

Posted on 2014-09-08
7
390 Views
Last Modified: 2014-09-09
I'm creating a Visual Basic 2013 application with the following parameters:
Target Framework: .Net Framework 4.5.1
Application Type: Windows Forms Application

The application is opening an Access 2013 Database.

What products should I include in the installation for this to install correctly?
Please provide links to these products so that I can download them.

Thanks
0
Comment
Question by:Ray Turner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 40310150
As far as you have described, you need nothing else than the .net framework.
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 40310196
From what you have described, you don't even need Access to be installed since you are not using Access, you are using ACE, the database engine.  ACE can be installed separately via a free download from MS.  You would only need Access to be installed on the PC that managed the database so you could modify objects.
0
 

Author Comment

by:Ray Turner
ID: 40311158
0
Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 40311180
As far as I understand from the details section, you cannot use that product to use it as your main database engine. In that case, better you use SQL Sever Express or SQL Lite.
If you only intend to "import" data from .mdb files, it may be suitable.
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 40311214
What you need to be able to connect to Access 2010-2013 databases on a computer that does not have Access installed is the Microsoft Access Database Engine 2010 Redistributable, found here.

This being said, I would rather use SQL Server Express than Access for a database on which the user does not interact directly as is the case when an application does it for him. There is a learning curve, but the way Access has been going this last few years, it is losing features all the time, and SQL Server Express, which is free and can be automatically distributed along with your application if you use the proper tools, is a far better option for the medium to long run, for performance as well as for maintenance.

Microsoft has developed a SqlClient library specifically for SQL Server in the framework. There is none for Access. You have to use the generic OldDB or ODBC libraries to connect to Access. This tells a lot about the Access support for .NET programmers.

Do not wait until the day you will have to convert your Access database to SQL Server because it is too big or suddenly have more users and cannot cope with the demand. The conversion is a pain, takes a long time, and the users are left in limbo while waiting for you to perform an uninteresting job.
0
 

Author Closing Comment

by:Ray Turner
ID: 40311225
Thanks
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 40312957
Do not wait until the day you will have to convert your Access database to SQL Server because it is too big or suddenly have more users and cannot cope with the demand. The conversion is a pain, takes a long time, and the users are left in limbo while waiting for you to perform an uninteresting job.
There is no time like the present so rather than building "desktop" style apps, start with "client/server" style apps from the beginning.  I can convert any of my Access FE's from Jet/ACE to SQL Server/Oracle/DB2/whatever, in an afternoon because my forms are always good client/server citizens and I include the extra arguments necessary in my DAO code.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question