Hi Rick,

Yes I am reading and writing to Paradox tables. The program I have written populates customer tables with up to 60,000 records, stock table with up to 30,000 records and many sundry files.

Some of these sundry tables require newly created tables to be read for their auto inc values which are used as PK fields.

Regards
Doug Johnston


>Hello Doug:
>
>Are you able to read and update Paradox tables using ODBC?
>
>Or can you only read them?
>
>Rick
>
>>Hi All,
>>
>>I found the problem after many hours of frustration and thought that it may help someone else.
>>
>>Microsoft deemed it necessary to place a hidden space in the Paradox driver name... "Microsoft Paradox Driver (*.db^). The ^ represents the space.
>>
>>Regaqrds
>>Doug Johnston
>>
>>>Hi,
>>>
>>>I am programatically trying to create a data source to Paradox datafiles (manually through ODBC Admin works fine). I've got the information from Microsoft but am still unable to successfully create the source.
>>>
>>>I can create data sources for all other ODBC drivers except the Paradox one.
>>>
>>>I would be most appreciative of anyone who could help out.
>>>
>>>Regards
>>>Doug Johnston