Solved

VB.Net - How to update a database

Posted on 2016-09-25
4
56 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
[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
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

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)…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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