Fwd: fpodbc

[Rod Caddy]

--- Original Message ---
From: "Rod Caddy" <rcaddy at pro-set.com>
To: <filepro-list at lists.celestial.com>
Cc:
Sent: Wed, 15 Sep 2004 08:52:44 -0500
Subject: fpodbc

> I am having a problem setting up fpodbc.  I am sure it is something
> I am doing wrong but I am at the end of my patience so I will ask
> those of you that are more patient than I.  I have a .mdb file
> called journal that is created from a palm sync.  In setting up
> Fpodbc, I goto define files and give my file the name odbc-journal
> then I press 3 to start the setup of the link to my mdb file.  The
> first time that I did this it brought up a blank screen in the file
> data source screen.  I muddled my way through and created a dsn
> named journal and it brings up the fpodbc interface to look at all
> of the tables.  The table name is FORM_ID_191449693 that I want to
> select.  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.  I also tried going
> into the ODBC interface through Control Panel and created the dsn
> there as well and I get the same message.  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?  If this is true, how can I
> convert that field to auto incrementing?  Access, I am not nor do I
> desire to be an access guru, says that I can not convert a field to
> auto incrementing once there is data in the file.  I would
> appreciate any bones that can be thrown my way.
>
> Rod Caddy
> Pro-Set Systems
> rcaddy at pro-set.com
> http://www.pro-set.com
> http://www.towtruck2000.com
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list

I sent this out  on the 15th and that was about the time the list was hung then all three of my forwards hit the list at the same time.  If you responded I have not gotten any response on my system.  I am having issues with my mail provider so if you respond other than to the list could you respond to rcaddy at towtruck2000.com.  Thanks for any help.


Rod Caddy
Pro-Set Systems	
rcaddy at pro-set.com
http://www.pro-set.com
http://www.towtruck2000.com