Cannot Create System Dsn Odbc Data Souce as Administrator

Discussion in 'Windows Vista Administration' started by Ron Aaronson, Apr 23, 2009.

  1. Ron Aaronson

    Ron Aaronson Guest

    I am logged on to Vista 64-bit as an administrator. Using the ODBC
    data source administrator that is in the Control Panel I can create
    and successfuuly test a system dsn odbc data source. But, this data
    source is invisible to Microsoft Access 2007. When I recreate the
    data source as a user dsn, Microsoft Access has no problems with it.
    Based upon reading articles, I thought i would try to create the
    system dsn data source using C:\Windows\syswow64\odbcad32.exe. I did
    not think this was actually a 32/64 bit issue, since Access is able to
    use the data source when it is a user dsn, but what the heck. When I
    try using th3 32-bit odbc administartor I get the message "you are
    logged on with non-administrative privileges" even when I make sure
    the program is run as an administrator.

    Anybody knows what is going on?
     
    Ron Aaronson, Apr 23, 2009
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.