Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slowperfomance

Hi,

Just wondering if you'd like to write this up into an article for the
techdocs.postgresql.org site, as there is a decent level of interest in
moving from MS Access to PostgreSQL. There are a few documents around,
but nothing which mentions this from what I remember.

:-)

Regards and best wishes,

Justin Clift

wsheldah(at)lexmark(dot)com wrote:
>
> This is because of the way Access works, and the way it tries to be extra
> friendly. When you go to change the text box source, it wants to contact the
> back end so that it can get a list of valid choices for you to choose from, and
> to validate your choice so you don't type something in that's going to fail.
> The way to eliminate the wait is to use an unbound form. This means writing
> some VBA code that will run whenever the form info needs to be saved (user
> clicks save, moves to another record, etc.). The VBA code needs to cycle
> through each of the fields, get the values, and update/insert them into the
> database. There's lots of sample code floating around for doing this, in books
> and articles.
>
> The extra code will seem like a pain at first, but it will make your app. run a
> lot faster. This is how Microsoft and other Access developers recommend using
> Access in a client/server environment. All their examples use SQL Server as the
> back end, but in principle, just read those articles and substitute PostgreSQL
> for SQL Server and the principles will apply just the same.
>
> Also, you might notice that by the time you get done unbinding all your forms,
> it's starting to be structured more like a web application. So doing this might
> even lay the groundwork for making it web-based and leaving Access behind
> altogether! :-)
>
> --Wes Sheldahl
>
> Jüri Fjodorov <jyri(dot)fjodorov%nowecanspam(dot)ee(at)interlock(dot)lexmark(dot)com> on 07/10/2001
> 11:18:44 AM
>
> To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
> cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
> Subject: [GENERAL] MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
>
> hi all!
>
> im just trying to migrate my ms access back-end to postgres. i used
> pgadmin for it and now i have tables stored in postgres on mandrake 7.2
> server. frontend is still ms access.(at least im trying redoing it for
> postgres..)
>
> problem is, when i do something(anything) with bounded
> form/report(changing text box source, for example), access makes
> connection to backend. i dont realy know what it do there as i am a
> newbie at postgres, but its real pain in the butt with about 1000K
> records in few tables. you see, i dont like to wait 2 mins just for
> changing text box source.
>
> i have strange feeling that its not normal and something configured
> wrong. why access have to access backend all the time while i am in
> form/report edit mode?
>
> anyone can help me out?
> thanx in advance
> jyri
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly