[Tfug] MSAccess frontend to PostgreSQL?

[Nate]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've done this before, but as soon as I could I wiped the horrible
nightmare^H^H^H experience from my brain.  So I don't remember all the
details, but it wasn't hard.  You just need to install the postgres
client drivers (available for download on postgresql.org) then set up a
ODBC connection in the ODBC control panel.  From there I think you just
create external links in access or something.  My memory definitely
fades from there.

I can tell you that it's not going to be the greatest performance wise,
but it does the job.  When I had to do this I did the same thing...
ported the VBS code out of Access into Perl and got 500% faster results,
but still used Access for "pretty reports."

Some searches on google I'm sure will turn up more details.  Look for
"enhanced data provider" and stuff.

GL and god speed.

Nate

Bexley Hall wrote:
| Hi,
|
| I have a datastore running on a PostgreSQL server.
|
| I need an easy way to build some reports/forms for
| newbie/casual users (i.e., "Visual" tools).  Ideally,
| web based but I don't imagine I'll find that as easy
| to come by as something like Access  :<
|
| [*I* am not keen on building these interfaces so I
| would like to dumb-down the tools used to the point
| where someone "inexperienced" can *almost* do it...]
|
| Any suggestions?
|
| Anyone try to wire Access to such a beast?
|
| I'll grep the Postgres web site and see if anything
| turns up.
|
| Thanks!
| --don
|
|
|
|
| _______________________________________________
| Tucson Free Unix Group - tfug at tfug.org
| Subscription Options:
| http://www.tfug.org/mailman/listinfo/tfug_tfug.org

- --
Nate
System Admin Manager
System Administration
Ext 220
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIbUP0RMRYK1K/wKQRAhcjAJ9zOtXxBGUx4h+ZWc2tlfs/ta72rgCgm7PQ
o8GpQizwfHrKU+VM8jeTnbY=
=Ptg3
-----END PGP SIGNATURE-----