Skip site navigation (1) Skip section navigation (2)

Re: Access97/odbcUnicode/pgsql : unable to map text field

From: "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Date: 2006-06-14 13:45:38
Message-ID: e6p3tr$149o$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
When I know I'm going to use MS Access as a front end to a Postgresql 
database I like to keep to the following guidelines:

- Use a serial number as my primary key on each table.
- Any text fields I need to search or index use varchar(<255)
- Turn "Row Versioning" and "Text as LongVarChar" on in the dataset options. 
(I also use "Bools as Char" but I'm not sure if I need to).

Hope this helps.

Ben

"ioguix" <igxnews(at)free(dot)fr> wrote in message news:44900F9E(dot)3080402(at)free(dot)fr(dot)(dot)(dot)
> Yes, I had  problems...
>
> I just had an Office2k CD today and I hadn't lot of time to make tests.
>
> Presently, I just make a clean environnement : removed everything,
> installed the psqlodbc 8.02.02 version without Hiroshi customed dll.
>
> My test application work fine for text to memo mapping with the unicode
> driver, but don't work anymore about the #deleted behaviour of Access
> without vba stuffs :/
>
> Maybe memo type arn't used by Access to check the record ?
>
> I hope I will find some more time tomorrow to complete my tests.
>
> Postgresql and more generaly database world really miss more
> applications like Access...
> Is anyone knows an application with at least easy an form design feature ?
> Do you know some project I could join to give help (If I have the skills) 
> ?
> Does anyone would be interrested by such a project ?
>
> Thanks.
>
> -- 
> +-----------------+
> | IoGuiX          |
> | igxnews(at)free(dot)fr |
> +-----------------+
>
> -- Schmitter, Frdric
>
>
> Ludek Finstrle wrote:
>>>Unfortunately, I am in a mixed network with win98/win2k and winXP.
>>>I don't know if Office2000 could be installed on win98, but if not, I'll
>>>gonna
>>>have a big problem to migrate the Access database to Postgres :s
>>>
>>>Thanks to both of you for your help, I'll try monday with Office2000
>>>and report
>>>here what's append.
>>
>>
>> Any progress?
>> BTW there is ANSI psqlodbc driver on Hiroshi page:
>> http://www.geocities.jp/inocchichichi/psqlodbc/index.html
>>
>> Luf
>>
>>
>>>Quoting Ludek Finstrle <luf(at)pzkagis(dot)cz>:
>>>
>>>
>>>>>But mystery is going deeper...
>>>>>I use Jet 4.0 on my winXP SP2. I followed the instructions describes in
>>>>>the last
>>>>
>>>>What about MS Access 2000? Isn't problem in Access 97 itself?
>>>>BTW It seems I'll have access to computer with MS Access installed.
>>>>I have no experience with it. Could you post me your test app?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
> 



In response to

pgsql-odbc by date

Next:From: AndrusDate: 2006-06-14 17:27:30
Subject: Page fault on connection
Previous:From: ioguixDate: 2006-06-14 13:31:10
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group