x-post to microsoft.public.access.odbcclientsvr, microsoft.public.access,
microsoft.public.it.office.access
follow-up to microsoft.public.access
§
Hello
The procedure is currently running on Windows XP, with Access 2003, ODBC
driver to access some external databases VisualFoxPro, driver v.
6.01.8629.01: it's working fine ;)
Now I'm testing Windows Vista...
1st try, with Access 2007, failed due to too many errors running the
application (don't want to spend ages on thousands of code lines, now)
2nd try, with Access 2003, the problem is the following: when I read
alphanumeric fields from the FoxPro database, they come in with a CHR(0) -
zero - at the end of the valid data, thus generating errors because the
lenght is one more than the allowed (destination field in Access). I spent
few time changing instructions, i.e. from A=B into A=Left(B,4) but there
are tons of code lines I should change, and I don't have time now.
So the question is: where is the problem?
TIA
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
|
|