I've just installed Access03 and I'm having some issues with an odbc connection to a Centura SQLBase database (ADP's PCPW). The connection works fine the first time after linking a table, but if I shut down the db and then reopen, the odbc connection fails. If I go into "Get External Data," select either import or link, choose the datasource, and then bail out of the reconnection process by clicking cancel, the link is restored again! It's as if Access is not pulling all of the necessary information from the DSN until I manually forge the link from Access to the data source.
Anyone experienced anything like this?
I would create a DSN-less connection to run on_load, but I haven't found the connection string for the PCPAYWIN datasource.