?
Solved

VB Data Entry Application without Microsoft Access

Posted on 2009-12-30
5
Medium Priority
?
430 Views
Last Modified: 2013-11-25
I need to build an application for QAQC and Data Entry.  We have field crews that download information to gps devices and export that data to access tables.  I would like to build a vb application that could import that access table and edit it using a form.  I currently have a very complex access application that does the job, but we would like to share with clients without asking to install ms access and with a more professional (unique) look.  I have visual studio 2008 and am sure that this should be possible, I just need some guidance as to how and where to get started.
0
Comment
Question by:tiggapoohtv
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:Jon500
ID: 26149577
You are really facing a very difficult problem. I have used MS Access for years as well as VB6 and VB.Net. There are (sadly) no migration paths from MS Access to the other two programming environments. In fact, it is even difficult to migrate VB6 to VB.Net, even though two companies claim to do it well.

The problem is that Access uses a different form-processing subsystem. Also, there are thing in Access (such as macros) that just don't exist as such in VB6/.Net.

Your best bet is to preserve the database schema (tables, relations, queries, etc.) and write a new GUI on top of it. You can migrate your Access schema to SQL Server with relative ease, but the user interface is a different matter.

My advice is to try to choose a GUI this time that is more future-proofed. For example, Windows Forms apps are nearly ubiquitous but Silverlight will run on virtually any browser. Lots to think about.

Sorry I couldn't be more optimistic. Don't penalize me because I could give you a path to follow--there simply is no viable one in this case other than a hand-coded solution, and that is the answer to your question.

Good luck,
Jon500
0
 

Author Comment

by:tiggapoohtv
ID: 26149674
I am fine with starting from scratch that is the meaning of my question.  I have tried and know it is impossible to simply migrate.  I want to start from scratch and build an app that i can package and send to another user that takes the data and gui along with it.  Id like to be able to import new tables to this app as well.
0
 
LVL 8

Accepted Solution

by:
Jon500 earned 2000 total points
ID: 26151210
Well, from your "I know this should be possible" statement above, I thought "this" meant a migration and not a rewrite from scratch.

What you need is to create a data-access tier using ADO.Net to Access. There are entire books written on this subject so I am not so sure how to advise here, but I think I can point you in the right direction with respect to free web sites that discuss this matter.

I would prototype your GUI using VB.Net and then wire-up your tables/queries using ADO.Net. I have attached a code sample that includes a connection string and the code required to pull data using a SQL query into a dataset table (see attached).

A good starting point for you is here:
http://www.dreamincode.net/forums/showtopic33908.htm

I hope this helps. My intentions are to get you started on the right track, as you requested.

Regards,
Jon500

Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\pathinfo\yourdb.mdb"
Dim SQLString As String = "SELECT * FROM YourAccessTable"
Dim OleDBConn1 As System.Data.OleDb.OleDbConnection = 
   New System.Data.OleDb.OleDbConnection(ConnString)
Dim DataSet1 As New DataSet()
Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter = 
   New System.Data.OleDb.OleDbDataAdapter(SQLString, OleDBConn1)
OleDBConn1.Open()
OleDbDataAdapter1.Fill(DataSet1, "DataSetTableName")
DataGridView1.DataSource = DataSet1.Tables("DataSetTableName")

Open in new window

0
 

Author Closing Comment

by:tiggapoohtv
ID: 31671428
I will look into the wonderful informatiion you have given me... Thanks!
0
 
LVL 8

Expert Comment

by:Jon500
ID: 26182969
Thank you and good wishes,
Jon500
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Integration Management Part 2

864 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