Re: [GENERAL] Playing with PostgreSQL and Access VBA

2005-04-25 Thread Tony Caduto
I guess I was thinking more of the "big picture" Your right of course, for someone just fooling around at home or for a very small business Access is great, but I am saying from experience that Access is a poor choice for any kind of large project or corp use. Access may be a poor choice for a De

Re: [GENERAL] Playing with PostgreSQL and Access VBA

2005-04-25 Thread Jeff Eckermann
"Tony Caduto" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In a real application that uses a client/server type database you should > NEVER construct queries that return a million rows. > You have to keep in mind that each record has to be sent accross the wire > via TCP/IP and

Re: [GENERAL] Playing with PostgreSQL and Access VBA

2005-04-23 Thread Joshua D. Drake
I was very impressed by what one member said regarding Delphi, but, when I looked at pricing,... well I would have to lie through my teeth to get the cheap academic version, and the personal version sounds like it doesnt have the file access abilities for PostgreSQL. And the prices for enter

Re: [GENERAL] Playing with PostgreSQL and Access VBA

2005-04-22 Thread Tony Caduto
In a real application that uses a client/server type database you should NEVER construct queries that return a million rows. You have to keep in mind that each record has to be sent accross the wire via TCP/IP and it is going to take a lot of time to bring back 1 million rows and I am sure your

[GENERAL] Playing with PostgreSQL and Access VBA

2005-04-22 Thread Typing80wpm
It was something of a struggle to get Access to talk to PostgresSQL using ODBC.   It was even more of a struggle, since I know nothing about Access or VBA, to create a "Form" in Access, and a Button on the Form, to execute the VBA code, below.   If it were not for the Internet, and Google, I