Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • 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
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>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
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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