Hello,
I'm a Visual Basic 6 programmer. I’m developing an application that is provided to users by an USB-stick. The users only have to plug-in the stick and are able to use the application. They do not have to install anything to use our tool. The application has to work on Windows 2000, XP, Vista, …. Also when Office is not installed on the PC!
Recently we have decided to change the database we use from Access 2003 to Access 2007. To make a connection with access 2007 one needs a Microsoft.ACE.OLEDB.12.0 connection string (http://www.connectionstrings.com/access-2007). To be able to use this connection string to connect to access you need to have some drivers installed. When you have Office 2007 or 2007 Office System Driver: Data Connectivity Components (http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en), these drivers are available on your PC. However, when this software is not installed, these drivers are not available.
We want our users to be able to use our application on USB-stick, such that they do not have to install anything. Therefore we want to include the Microsfot.ACE.OLEDB.12.0 drivers on our stick. Could you please help which drivers/components are needed to store on the stick. Furthermore, could you please help how I should load these drivers dynamically into Visual Basic 6, such that each PC is able to connect to our Access 2007 database.
Thank you very much!!!!
Kind regards, Peter
I'm a Visual Basic 6 programmer. I’m developing an application that is provided to users by an USB-stick. The users only have to plug-in the stick and are able to use the application. They do not have to install anything to use our tool. The application has to work on Windows 2000, XP, Vista, …. Also when Office is not installed on the PC!
Recently we have decided to change the database we use from Access 2003 to Access 2007. To make a connection with access 2007 one needs a Microsoft.ACE.OLEDB.12.0 connection string (http://www.connectionstrings.com/access-2007). To be able to use this connection string to connect to access you need to have some drivers installed. When you have Office 2007 or 2007 Office System Driver: Data Connectivity Components (http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en), these drivers are available on your PC. However, when this software is not installed, these drivers are not available.
We want our users to be able to use our application on USB-stick, such that they do not have to install anything. Therefore we want to include the Microsfot.ACE.OLEDB.12.0 drivers on our stick. Could you please help which drivers/components are needed to store on the stick. Furthermore, could you please help how I should load these drivers dynamically into Visual Basic 6, such that each PC is able to connect to our Access 2007 database.
Thank you very much!!!!
Kind regards, Peter
Store the A2007 driver on the same USB stick as your application, then in your code point to this location so the driver can be loaded correctly
