[Tfug] MSAccess frontend to PostgreSQL?

[TR]

I'd recomend a tool like AquaDataStudio, DbViz orOracleSqlDeveloper
They use JDBC  drivers and the first two include them in the download.
 The provide a good interface if SQL is known or learnable.

TR

On Thu, Jul 3, 2008 at 2:26 PM, Nate <nate at torzo.com> wrote:
> -----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-----
>
> _______________________________________________
> Tucson Free Unix Group - tfug at tfug.org
> Subscription Options:
> http://www.tfug.org/mailman/listinfo/tfug_tfug.org
>