L
liya.tansky
Hi,
I have am Access application which is going to move to .NET + SQL
Server.
The first stage, however, is to use Access as front-end to SQL Server.
The application should be able to use english and hebrew.
Right now saving and retreiving text with nvarchar works fine.
Problem:
when trying to write something that was Memo in Access to ntext it gets
all "?????" instead of hebrew string. knowing that nvarchar works this
seems very strange to me.
Tried to insert string in hebrew directly in the db table and it is
fine and shows fine in the application. What am I missing?
Another problem that happens only with several memo (and I can't manage
to trace it )
is that trying to change it gives me a system message box error in
hebrew (since Access is in hebrew at this computer), so I can't give
the specific message. But it tells that this record was changed by
another user and changing it will kill his changes and suggests to drop
the changes or to copy them to clipboard. Since I'm the only one at
home, this means something else. I know about dbSeeChanges but when
form is created I don't know where I can put it and in this case the
table has no identity.
Please help
and thanks in advance
Liya
I have am Access application which is going to move to .NET + SQL
Server.
The first stage, however, is to use Access as front-end to SQL Server.
The application should be able to use english and hebrew.
Right now saving and retreiving text with nvarchar works fine.
Problem:
when trying to write something that was Memo in Access to ntext it gets
all "?????" instead of hebrew string. knowing that nvarchar works this
seems very strange to me.
Tried to insert string in hebrew directly in the db table and it is
fine and shows fine in the application. What am I missing?
Another problem that happens only with several memo (and I can't manage
to trace it )
is that trying to change it gives me a system message box error in
hebrew (since Access is in hebrew at this computer), so I can't give
the specific message. But it tells that this record was changed by
another user and changing it will kill his changes and suggests to drop
the changes or to copy them to clipboard. Since I'm the only one at
home, this means something else. I know about dbSeeChanges but when
form is created I don't know where I can put it and in this case the
table has no identity.
Please help
and thanks in advance
Liya