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.
"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 ?
> | 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
>>>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
>>>here what's append.
>> Any progress?
>> BTW there is ANSI psqlodbc driver on Hiroshi page:
>>>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
>>>>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
In response to
pgsql-odbc by date
|Next:||From: Andrus||Date: 2006-06-14 17:27:30|
|Subject: Page fault on connection|
|Previous:||From: ioguix||Date: 2006-06-14 13:31:10|
|Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field|