Re: Postgresql with Access 97

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

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

On 8 Apr 2006 17:04:41 -0700, zagman <daveh@xxxxxxxxxxxxx> 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?

               http://archives.postgresql.org