I have been using MS access database ( *.MDB) in a 64-bit format in windows 7 (64-bit) for quite some time. The Access SQL is called from a C++ module.
I have recently upgraded my OS to windows 10, I am still able to open connection to the ODBC (user DSN in this case), however, it seems my earlier program can no longer open the table or run queries. I am unsure what are my options now, please advice.
Should I use .accdb in place of .mdb ?
Asked
Active
Viewed 162 times
0
Vadim Kotov
- 8,084
- 8
- 48
- 62
ark1974
- 615
- 5
- 16
-
Did you install Microsoft Jet? – Guillaume F. Apr 09 '17 at 08:41
-
@GuillaumeF. No. I install Microsoft Access 2010 64-bit ODBC driver – ark1974 Apr 09 '17 at 08:48
-
You need `Jet OLEDB` if you want to open the MDB file directly, but apparently it's dead, look at this answer : http://stackoverflow.com/questions/13811179/where-how-can-i-download-and-install-the-microsoft-jet-oledb-4-0-for-windows-8 – Guillaume F. Apr 09 '17 at 08:55
-
@GuillaumeF. The MDB opens and its working alright on win7 still . Whats wrong on win10? – ark1974 Apr 09 '17 at 09:06
-
Perhaps you should try an accdb version of the file and see what happens. Be sure to keep the original mdb in case you have to go back to it. – June7 Apr 09 '17 at 17:13
-
accdb solved the issue on win10.Thanks all – ark1974 Apr 19 '17 at 15:00
2 Answers
0
Try changing provider in connection string : "Provider=Microsoft.Jet.OLEDB.4.0;" Like this if not yet done so.
newstockie
- 114
- 1
- 4
0
After testing I found that changing from .mdb to .accdb did solve the problem. I am posting so that I can close this thread and perhaps benefit someone.
ark1974
- 615
- 5
- 16