Solved

Can't update lined SQL server table with Hebrew

Posted on 2002-05-12
3
289 Views
Last Modified: 2012-08-13
I am linking to an SQL server 2000 backend via ODBC from Access. My tables that have Hebrew characters in some fields are not updateable in Access. I get a message that "another user is trying to update this record....". Any tables that are only English are fine. I guess there is some conflict with the code page. I tried all availabel settings in the ODBC datasource but couldn't get it to work. Anybody have any ideas?
0
Comment
Question by:kellykln
3 Comments
 
LVL 4

Expert Comment

by:MacRena
ID: 7004398

hmmm, don't know.
maybe the latest Service Pack will help:

Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290211

good luck!

mac
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7220127

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7240333
Question has been moved to PAQ and points not refunded as per recommendation

JGould-EE Moderator
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

815 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now