• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

VB.Net - How to update a database

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
Polyview
Asked:
Polyview
  • 2
  • 2
1 Solution
 
AndyAinscowCommented:
>>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
 
PolyviewAuthor Commented:
Thanks for that.  Maybe I will try to get them to download the Jet.OLEDB.4.0 provider?
0
 
AndyAinscowCommented:
>>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
 
PolyviewAuthor Commented:
Will try - thank you
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now