Access 2003 Unicode
Posted on 2010-03-25
A real challenge here ... I am building an access 2003 database on a Windows XP platform which takes data from another non access database via an ODBC connnection.
I want to have a series of linked tables to the source database.
Here's where the issue comes in ... I have established the ODBC connection all fine, but I cannot link the tables, I can however import the tables which work all fine, but these tables definitely need to be linked.
The other thing I noticed was that in the source database the table names contain a "." so when it's linked it keeps the same name, but when it's imported it changes the "." to an underscore eg... FFUsers.AllAssignments to FFUsers_AllAssignments - could this be the reason (if so what can I do about it, I assume changing the name won't help as access has already done this for me?)
Access gives me no error messages but overwrites the data with "#deleted" in each field. So I tried excell and got a bit of info from that ... The error message was " system does not support conversion between unicode and the requested character set, substituting the current ANSI code page".
I spoke to the makers of the source database who couldn't work this one out but said that it was written (or outputted (can't remember which as my brain was fried by this stage)) in sybase UCA collation sequence
Please help - if I was allowed to award 1000,000 points for this I would!