Solved

VB.Net - How to update a database

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.

831 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