Re: Beginner's question about ODBC and/or foreign data sources

On 18 October 2012 13:57, George Roberge <groberge(at)andforthelamb(dot)org> wrote:
>> Maybe I completely misunderstood this initial paragraph of your mail,
>> but how does using postgres to look at other windows data sources comprise a
>> replacement for access?

> Oh sure.
>
> That was just a very broad (and useless as far as my actual questions go)
> statement legitimizing my question's existence on the planet!

LOL ...

> It is a long-term goal to break PostgreSQL into the workplace, and
> eventually use it enough that perhaps Access will disappear. It's a battle
> against "The Machine" of course, but hey....
>
> The data source is a Syspro ERP ODBC source. Access naturally readily
> connects to this source, and we supplement the ERP with a few Access
> databases when we need to use its data in ways that the ERP doesn't handle.

So you're primarily using access as a front-end/GUI to your ERP system, with
a little extra ooomph? If that's the case postgres probably isn't the cure for
your access ailments :}

Most likely you'll need a custom made GUI app, and possibly use postgres
for the "and then some" bits from the same app.

>
> George R.

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.georgedillon.com/web/html_email_is_evil.shtml