#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    16
    Rep Power
    0

    ACCESS 2k DSN in CF admin


    I am trying to add an Access 2k dB as DSN in CF Admin but it cannot be verified. However, after I converted the dB to Acess 97 format, the DSN was successfuly verified.
    How can I get the original dB (in Access 2k) verified and added as DSN?

    Thanks.
  2. #2
  3. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,265
    Rep Power
    968
    What version of Windows (if you are using Windows) and CF are you using? I know that with CFMX and Windows 2000/2003 there is no problem setting up an Access 2000 DSN.

    Can you set up the same data source using the ODBC applet in the Windows control panel?

IMN logo majestic logo threadwatch logo seochat tools logo