[Webinar] Streamline your web hosting managementRegister Today


Access 2003 Unicode

Posted on 2010-03-25
Medium Priority
Last Modified: 2013-12-03
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!

Question by:correlate
  • 2
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 28555813
What do you mean by "cannot link the tables"? Do you get an error, or does it simply fail, or are you unable to proceed at some point? Describe exactly what's happening (and what your "non access database" is) and we can probably be a bit more focused.

However, I'd bet is due to the fact that Access cannot use a period in the table name:

Can the owners of that source database define a "view" (i.e. a query) that you could link to, and name that query without special characters?


Author Comment

ID: 28556656
The database is a piece of software called FileFinder 9

As far as what's happening on the links... It appears to set up ok and you can open it etc, but the data inside is replaced with "#DELETED".

The owners could produce a query that I could link to but I would prefer to avoid this for a whole host of reasons.
LVL 53

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1000 total points
ID: 28558258
One or more of the fields probably holds a data type not supported by Access.
Ask the owner to create a query or view with only the fields you need. Note that the ID must be included if the view should be updatable. If this, however, is a BigInt (larger than Long) it cannot be used.


Accepted Solution

correlate earned 0 total points
ID: 28684658
Dear All

Thanks for the suggestions. I had another go at it today and realised that what I had been doing was to assign a unique record ID to the source database's unique record ID field and it didn't like it.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Why WooCommerce is one of the majorly favored choices when it comes to having an eCommerce store. This article will acquaint you with some reasons that I believe make it one of the best eCommerce platforms available.
Starting up a Project
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question