Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance

Did you change the names or structures of your tables?

If you've left your structures the same, you should be
able to replace the Access tables with ODBC links with
the same names without changing forms, queries,
reports, etc.  This assumes, of course, that you
didn't create Visual Basic code in your application
that looks specifically for Access tables.

I did this under PostgreSQL 7.0.2.  I think it should
still work under 7.1; but can't make any promises.

Best of luck,

Andrew Gould

--- J�ri Fjodorov <jyri.fjodorov@nowecanspam.ee>
wrote:
> 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


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/