Greetings All,
I've been searching for a solution to this problem for quite some time. The company I work for has been in the process of migrating vb6 code to .NET for a while now. The vb6 code used Access MDB for its data storage, and when compiled and deployed to client machines, it worked perfect WITHOUT having to have any soft of MS Office product installed on the end user's machine.
So to clarify: VB6 Code + MDB worked fine without requiring clients to install MS Office.
Now on to the problem. As the code has been migrated from vb6 to .Net using VS2005, everything was coded and modified line by line and the structure and original source code are pretty much the same. (aside from syntax obviously). The main difference between the two is that with the advent of Office 2007, the database was upgraded to the new ACCDB format. A reference has been made to the MS Office 12.0 Access Database Engine 12.0.0.0... now when the software is run on a machine without any office installed, I get an unhandled exception, could not load "Microsoft.Office.Interop.Access". If I publish the software and then try and run the setup, I get "Microsoft.Office.Interop.Access Version 12.0.0.0 be installed in the GAC".
I've tried running the MS Office 2007 PIA redistributable, but that requires That MSO2007 be installed first.
So I guess the main question is, how can I make it so that this software can access an accdb, or maybe even return to mdb for that matter, without having MS Office installed on the end user's machine? The source code doesn't use any Office automation, it only read and writes out of the accdb using basic SQL.
Any help would be greatly appreciated. Thanks in advance to all that reply.
Cordially,
Russ
I've been searching for a solution to this problem for quite some time. The company I work for has been in the process of migrating vb6 code to .NET for a while now. The vb6 code used Access MDB for its data storage, and when compiled and deployed to client machines, it worked perfect WITHOUT having to have any soft of MS Office product installed on the end user's machine.
So to clarify: VB6 Code + MDB worked fine without requiring clients to install MS Office.
Now on to the problem. As the code has been migrated from vb6 to .Net using VS2005, everything was coded and modified line by line and the structure and original source code are pretty much the same. (aside from syntax obviously). The main difference between the two is that with the advent of Office 2007, the database was upgraded to the new ACCDB format. A reference has been made to the MS Office 12.0 Access Database Engine 12.0.0.0... now when the software is run on a machine without any office installed, I get an unhandled exception, could not load "Microsoft.Office.Interop.Access". If I publish the software and then try and run the setup, I get "Microsoft.Office.Interop.Access Version 12.0.0.0 be installed in the GAC".
I've tried running the MS Office 2007 PIA redistributable, but that requires That MSO2007 be installed first.
So I guess the main question is, how can I make it so that this software can access an accdb, or maybe even return to mdb for that matter, without having MS Office installed on the end user's machine? The source code doesn't use any Office automation, it only read and writes out of the accdb using basic SQL.
Any help would be greatly appreciated. Thanks in advance to all that reply.
Cordially,
Russ