Solved

VB.Net - How to update a database

Posted on 2016-09-25
4
48 Views
Last Modified: 2016-09-27
I have a VB.net program used by about 15 users.  It uses Microsoft Access databases and datasets
One of the source files is an old ExminerComments.mdb file, and this is a local database on the users computer.
There have been problems when a user buys a new Windows 10 computer, and then runs the installation program.
I am guessing that it may be due to the outdated .mdb file.
I was thinking of updating their databases to a later Examiner Comments.accdb file.
Question:
1.      Can I alter the Vb.net program to suit without lots of programming changes??
2.      Do I need to change the connection strings and the Data sources table?  If so how?
3.      I was also thinking of changing the database name to “NewComments.accdb” to avoid confusion.  Is this advisable?
The file bellow shows my current connection strings and data sources
Connection-strings-etc.jpg
0
Comment
Question by:Polyview
  • 2
  • 2
4 Comments
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 41815378
>>I am guessing that it may be due to the outdated .mdb file.

Wrong.  Don't guess, it just creates lots of work for no benefit.   (I can use .mdb databases without problems on win 10)
0
 

Author Comment

by:Polyview
ID: 41817065
Thanks for that.  Maybe I will try to get them to download the Jet.OLEDB.4.0 provider?
0
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 500 total points
ID: 41817211
>>Maybe I will try to get them to download the Jet.OLEDB.4.0 provider?

If that is the source of the problem then yes.
0
 

Author Closing Comment

by:Polyview
ID: 41817601
Will try - thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Visual Studio .Net 2012 and Crystal Reports 9 44
asp.net mvc input file 2 32
Word Directory is not in the drop down list 4 24
fso.FolderExists("\\server\HiddenFolder$") 4 46
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now