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 <[EMAIL PROTECTED]> on 07/10/2001 11:18:44 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
