ODBC drivers for Access in WinXP
-
Hi all. My problem is pretty simple. I was just wondering if a application based on a Access mdb file database can be deployed in a System that doesnt have MS Access installed. The OS is Windows XP. The question is: Are the odbc drivers and the jet drivers for Access databases installed with MS Access or do they come with the OS? I know the app will run if the drivers are present, doesn't matter if Access is installed or not. I cant test any similar environment because all computers here have Office installed and even uninstalling I cant be sure if the drivers are left behind or they really did come with Windows. P.d. If drivers dont come with OS, is there a way (legal please) to install them without having to install MS Access? Thanks for any help.
-
Hi all. My problem is pretty simple. I was just wondering if a application based on a Access mdb file database can be deployed in a System that doesnt have MS Access installed. The OS is Windows XP. The question is: Are the odbc drivers and the jet drivers for Access databases installed with MS Access or do they come with the OS? I know the app will run if the drivers are present, doesn't matter if Access is installed or not. I cant test any similar environment because all computers here have Office installed and even uninstalling I cant be sure if the drivers are left behind or they really did come with Windows. P.d. If drivers dont come with OS, is there a way (legal please) to install them without having to install MS Access? Thanks for any help.
hmmm... yes, I there is no need to install Access driver on client machine. If no office is installed, it will work. I remember that I have tested this and it was working fine. MS Access installation would be required if you are creating objects of certain ActiveX components exposed by Access. But I am very much sure you are not doing so. So, I think it will work fine. Also, another guess, I think to access Access Database, MDAC (or watevva it is) is required on client machine, and Windows XP by default contains this. Another supporting argument: What MS Access installation has got to do with database connectivity? On servers, Microsoft discourages the installation of MS Office products. And all MS based servers still support Access connectivity. So bottom line: No need to worry about. Good Luck fadee! ------------------- Therez No Place like ... 127.0.0.1
-
hmmm... yes, I there is no need to install Access driver on client machine. If no office is installed, it will work. I remember that I have tested this and it was working fine. MS Access installation would be required if you are creating objects of certain ActiveX components exposed by Access. But I am very much sure you are not doing so. So, I think it will work fine. Also, another guess, I think to access Access Database, MDAC (or watevva it is) is required on client machine, and Windows XP by default contains this. Another supporting argument: What MS Access installation has got to do with database connectivity? On servers, Microsoft discourages the installation of MS Office products. And all MS based servers still support Access connectivity. So bottom line: No need to worry about. Good Luck fadee! ------------------- Therez No Place like ... 127.0.0.1
Thanks for the reply Fadee! glad to here there will be no problem. As a matter of fact, if I would have stopped to think about MDAC I wouldnt have wasted yout time :p... you are absolutely right, MDAC contains the drivers for all standard DB connectivity including Access.