View Single Post
  #1  
Old March 11th, 2007, 09:39 AM
psinkiws psinkiws is offline
Registered User
 
Join Date: Dec 2005
Posts: 35
Songbook trouble, field truncated

It would seem that the songbook error involving {} has been corrected. However, if these characters are in a field would put its field length at greater than 64 after doing a search/replace { with \{ and } with \} then the end characters are chopped off. Perhaps when you setup the field lengths in the temporary table, you can increase them by 5 (which should more than accommodate any of these characters) in order to allow for the addition of the \ characters. Right now, I have to import the Access 97 mdb into Access 2003, run a query for all of my fields that contain { and } that are 63 or 64 characters long and then manually search the Songbook to add the missing characters.
Reply With Quote