How to change a BTRieve field name in a table...
Posted on 2006-10-20
Pervasive SQL 8.6 (using standard DDF files)
Protech Vision AMS
I am trying to link tables from this AMS database into an Access database. Mostly for the purpose of enhanced reporting and data view capability.
However, some of the tables have field names with periods, # signs or other characters in them. When trying to link the tables in MS Access, I get the message that:
" 'Reason for Term. ' Is not a valid name. Make sure that it does not include invalid characters or punctuation or is too long".
I'm guessing there's no magic fix for this in Access, so my question is.... exactly how can I change the field names in question, what would the SQL syntax look like for this and are there any other issues like rebuilding the DDF files or indexes I'd need to do?