Results 1 to 2 of 2
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Code for Driver installed

    Hi,



    My Front End is linked to tables on a SQL Server.

    The driver "SQL Driver" doesn't read Date fields correctly from SQL Server. If I use the driver "ODBC Driver 13 for SQL Server" everything works fine.

    Does anyone know any code to use to verify if a "Driver is installed on a computer"? Maybe API? I wanted tp place the code in the macro AutoExec and inform the user that correct Driver isn't installed when the project opens.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try looking at the connection path....
    in the Immediate window (Ctl-G) type the path of 1 of the tables:

    ?currentdb.tabledefs("table").connection

    If that does not have the info you want, then you may need an api to display more detail.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Error Driver 1
    By N7925Y in forum Import/Export Data
    Replies: 1
    Last Post: 05-17-2016, 12:19 PM
  2. Path to ODBC Driver
    By cbouley in forum Access
    Replies: 3
    Last Post: 04-23-2013, 10:00 AM
  3. Oracle ODBC 11g Driver
    By GregZip in forum Access
    Replies: 6
    Last Post: 03-21-2012, 03:49 PM
  4. Qucik question about the ODBC driver
    By baseborn in forum Access
    Replies: 1
    Last Post: 12-14-2010, 06:11 AM
  5. oledb not installed?
    By bbxrider in forum Access
    Replies: 0
    Last Post: 04-20-2010, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums