fpodbc

[Robert Haussmann]

[....]
> 
 I select it and after several seconds the system 
> comes back to the define files program and asks for the 
> Unique ID field.  I then receive the message Cannot open 
> table.  

Does anything happen between the prompt for unique ID and
the "cannot open table" message?

> I also tried going into the ODBC interface through 
> Control Panel and created the dsn there as well and I get the 
> same message.  

Are you saying that in control panel/ODBC, if you simply create 
the system DSN for this file, you obtain the "cannot open table" 
message?  If so, this implies a Windows-level issue.

Is it possible that the Palm application remains open and is
locking the MDB file?  This may or may not be obvious (e.g.,
their might be a synchronization program running on the desktop,
or simply something running in the taskbar).

> I have a field in the table that is record id 
> but is not an auto incrementing field and thus I do not have 
> a unique id field in the file.  Could this be why it cannot 
> open the  the table?  

It shouldn't be.  To the best of my knowledge, fp_id does not
have to be an auto-incrementing field (although it often is).
It simply has to be guaranteed unique.

> If this is true, how can I convert that 
> field to auto incrementing?  

I wouldn't even try to do this, for fear of impacting the 
original application.

Bob Haussmann
Tabor Children's Services, Inc.