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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2006-06-14 17:27:30 | Page fault on connection |
Previous Message | ioguix | 2006-06-14 13:31:10 | Re: Access97/odbcUnicode/pgsql : unable to map text field |