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.fjodorov%nowecanspam.ee@interlock.lexmark.com> on 07/10/2001
11:18:44 AM
To: pgsql-general%postgresql.org@interlock.lexmark.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