I have a program that creates an .mdb file.
I can import that file into Excel 2007 via the >Data>From Access menu chain.
When I try to do the same thing in Excel 2013 I am presented with a Data Link Properties box with the connection tab selected.
In Box 1 - The Data Source information appears correct (it's got the correct file and path name in it).
But Box 2 Requires me to provide information to log onto the server (Username is initially provided as "Admin" and Password is initially grayed out, both bland password and Allow saving password boxes are initially checked). When I click the "Test Connection" button - I get a message that reads:
"Test connection failed because of an error in initializing provider. Cannot open a database created with a previous version of your application".
When I change the login information to provide my username and password for the computer, I get a message that reads:
"Test connection failed because of an error in initializing provider. Cannot start your application. the workgroup information file is missing or opened exclusively by another user".
Is there any way that I can get Excel 2013 to open the same .mdb file that Excel 2007 was able to handle?
Thanks
Mike
I can import that file into Excel 2007 via the >Data>From Access menu chain.
When I try to do the same thing in Excel 2013 I am presented with a Data Link Properties box with the connection tab selected.
In Box 1 - The Data Source information appears correct (it's got the correct file and path name in it).
But Box 2 Requires me to provide information to log onto the server (Username is initially provided as "Admin" and Password is initially grayed out, both bland password and Allow saving password boxes are initially checked). When I click the "Test Connection" button - I get a message that reads:
"Test connection failed because of an error in initializing provider. Cannot open a database created with a previous version of your application".
When I change the login information to provide my username and password for the computer, I get a message that reads:
"Test connection failed because of an error in initializing provider. Cannot start your application. the workgroup information file is missing or opened exclusively by another user".
Is there any way that I can get Excel 2013 to open the same .mdb file that Excel 2007 was able to handle?
Thanks
Mike