Solved

Visual Basic 2013 Application

Posted on 2014-09-08
7
379 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
  • 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 36

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 36

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

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

685 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