Postgresql with Access 97
Hi all,
I'm trying to migrate to a postgresql server backend with an existing
Access 97 application. However Access 97 crashes all the time if I
update any records The error I see says something about "SQL_ASCI"
encoding when I look at the error report that Access generates to send
to Microsoft.
What encoding should I use? I'm using postgresql 8.0.7 with pgsqlodbc
8.00.01.03.
Thanks,
Dave
You can try SQL_ASCII encoding in the following way in PostgreSQL:
CREATE DATABASE test
WITH ENCODING='SQL_ASCII';
In the past I have used this good tool for conversion between Access and
PostgreSQL. You can give it a try as well
http://www.data-conversions.net/access-to-postgresql-pro-converter.html
/Shoaib
Show quoted text
On 8 Apr 2006 17:04:41 -0700, zagman <daveh@allheller.net> wrote:
Hi all,
I'm trying to migrate to a postgresql server backend with an existing
Access 97 application. However Access 97 crashes all the time if I
update any records The error I see says something about "SQL_ASCI"
encoding when I look at the error report that Access generates to send
to Microsoft.
What encoding should I use? I'm using postgresql 8.0.7 with pgsqlodbc
8.00.01.03.Thanks,
Dave
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?