Re: Problem selecting an ODBC data source

Tech-Archive recommends: Speed Up your PC by fixing your registry

Salad wrote:

I want to link a table to my Access 2003 database. I select ODBC Databases() from the file of type dropdown. As soon as I do that the process of linking to a table stops. Instead of opening up the window to select the ODBC Data Source I get returned to where I started. It's like the process says "Oh, he selected ODBC. I don't know what ODBC is so I'll just quit and die." There's no error message. No nothing.

Can anyone think of a reason why the Select Data Source window would not be opened?

If I do the same thing in Access97 the Select Datasource window opens fine.

I found the solution. It was NAV2006.
http://groups.google.com/group/microsoft.public.access/browse_thread/thread/91e4438566355c02/e8448a10f749897b?hl=en&lnk=st&q=can%27t+see+data+source+odbc#e8448a10f749897b
.

Relevant Pages

  • Re: About Access 2003 ODBC and Jet 3.51
    ... I can link to an ODBC source through Get External Data/Link Tables, ... File Data Source and Machine Data Source. ... if I attempt to select an ODBC source and select "ODBC Databases " the window simply closes and I have no opportunity to select a data source. ...
    (comp.databases.ms-access)
  • RE: Trouble linking tables from sql server via odbc
    ... I assume you have created an ODBC DSN in Control Pannel/Administrative ... Right-click anywhere in the window and select "Link Tables" from the ... When the "Data Source" dialog appears - ...
    (comp.databases.ms-access)
  • Problem selecting an ODBC data source
    ... I select ODBC Databases() from the file of type dropdown. ... Instead of opening up the window to select the ODBC Data Source I get returned to where I started. ...
    (microsoft.public.data.odbc)
  • Re: About Access 2003 ODBC and Jet 3.51
    ... I have Access 2003 SP2 and Jet Core Components list Jet 4.0 and ODBC as both Not ... File Data Source and Machine Data Source. ... window simply closes and I have no opportunity to select a data source. ...
    (comp.databases.ms-access)
  • Re: If then else containing value not at the end or in the beginni
    ... ODBC, and you have the necessary bits of the Jet database engine on ... b.open your mail merge main document and disconnect from the data source. ... Now you either need some VBA, or you need a DATABASE field. ... Sub MyConnect() ...
    (microsoft.public.word.mailmerge.fields)