Microsoft Access
--
Questions
--
Followers
Top Experts
Access drivers and MDAC
Hi, we have a small application which has been written in vb6 and connects to a small access db file. The install script is set to create a System DSN connection during the install process.
We installed the application on a new server SBS Server 2011. I found that the ODBC connection was not created and then when i tried to create a new entry there are no Access drivers installed on the server. By installing MDAC will this then install the MS Access drivers needed, and if so which version of MDAC must i install
thanks
We installed the application on a new server SBS Server 2011. I found that the ODBC connection was not created and then when i tried to create a new entry there are no Access drivers installed on the server. By installing MDAC will this then install the MS Access drivers needed, and if so which version of MDAC must i install
thanks
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
MDAC 2.8 is the last version, I believe.
 All the Access stuff has been depreciated from MDAC as of version 2.6.  You'll need to use the JET SP8:
http://office.microsoft.com/en-us/downloads/about-microsoft-jet-4-0-sp8-or-later-HA001048935.aspx
Jim.
Ahh, Jim is right. It's been such a long time since I've had to install the Jet drivers on a standalone machine.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
<<if your using a 32bit version of office.>>
 Oops, you said you were using VB6<g>.  You need to use the 32 bit version of ODBC manager if your on a 64 bit version of the OS.
Jim.
 Oops, you said you were using VB6<g>.  You need to use the 32 bit version of ODBC manager if your on a 64 bit version of the OS.
Jim.
Hi guys thanks for the comments
Will check this evening on the server and let u know
Thanks
Will check this evening on the server and let u know
Thanks
Thanks a lot
perfect
perfect
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.