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@free.fr> wrote in message news:44900F9E.3080402@free.fr...
> 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@free.fr |
> +-----------------+
>
> -- Schmitter, Fr�d�ric
>
>
> 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@pzkagis.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
>