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

On 10/17/2012 06:52 PM, Andrej wrote:
> On 16 October 2012 06:52, <groberge(at)andforthelamb(dot)org> wrote:
> Hi George,
>
>> I have installed and used PostgreSQL at a beginner's level (simple database
>> creation, simple PHP website querying) and would love to use it at work to
>> complement and/or (hopefully) replace Access as our software of choice.
> 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?
>
> May I ask what those other odbc data sources are, and how you utilise
> them with access?
>
>
> Cheers,
> Andrej
>
>
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!

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.

George R.