Is it possible to use Access as front-end for POstgreSQL and how ?
What about Access Projects (.adp) and PostgreSQL ? 13 7189
Zlatko Matiæ wrote: Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
As an experiment I once set up an Access/PostgreSQL (Windows/Linux,
respectively). It worked. You have to have the Windows ODBC driver for
PostgreSQL. Use the following search words at Google.com to find some
drivers:
postgresql "odbc driver"
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQjX+9oechKqOuFEgEQJXpwCg+9gKJ8XJmv1c1lzRjYRBSE +4Dx8AoIEj
49GWU6D+yE6axnMNznWmCJsb
=+aXy
-----END PGP SIGNATURE-----
"Zlatko Matiæ" <zl***********@sb.t-com.hr> wrote in message
news:d1**********@ls219.htnet.hr... Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
================================================== ====================
Yes, it's possible to use Access as a frontend to PostgreSQL. You'll need
to find an ODBC driver for PostgreSQL. I don't know if PostgreSQL itself
now runs under windows; as far as I know, it only runs under Linux. Your
Access frontend(containing the forms, pass-thru queries, reports, etc.)
would run on a windows machine networked to a Linux machine running the
PostgreSQL server containing your tables.
It is NOT possible to use an ADP with PostgreSQL. ADP's work strictly (at
this time, and for the fore-seeable future, anyway) with MS SQLServer.
HTH
Ruben
On Mon, 14 Mar 2005 15:25:58 -0800, "Ruben Baumann" <ry**@yahoo9.com> wrote: "Zlatko Matiæ" <zl***********@sb.t-com.hr> wrote in message news:d1**********@ls219.htnet.hr... Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
================================================= =====================
Yes, it's possible to use Access as a frontend to PostgreSQL. You'll need to find an ODBC driver for PostgreSQL. I don't know if PostgreSQL itself now runs under windows; as far as I know, it only runs under Linux. Your Access frontend(containing the forms, pass-thru queries, reports, etc.) would run on a windows machine networked to a Linux machine running the PostgreSQL server containing your tables.
It is NOT possible to use an ADP with PostgreSQL. ADP's work strictly (at this time, and for the fore-seeable future, anyway) with MS SQLServer.
... to the extent they work at all.
"Ruben Baumann" <ry**@yahoo9.com> wrote in
news:sb********************@megapath.net: I don't know if PostgreSQL itself now runs under windows
Yes, it does.
But, last I checked, it runs on top of the CYGWIN libraries, and as
Steve J. has pointed out, this leads to certain security
vulnerabilities. From my perspective this means that for prototyping
it's great to run it on Windows, but for production use, it still
belongs on a non-Windows server.
Now, the project to create a full Windows version that isn't based
on CYGWIN has been around for a long time. I don't know if it's made
any progress. According to this: http://techdocs.postgresql.org/guides/Windows
the conversion is not done yet.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Tue, 15 Mar 2005 02:59:56 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote: "Ruben Baumann" <ry**@yahoo9.com> wrote in news:sb********************@megapath.net:
I don't know if PostgreSQL itself now runs under windows
Yes, it does.
But, last I checked, it runs on top of the CYGWIN libraries, and as Steve J. has pointed out, this leads to certain security vulnerabilities. From my perspective this means that for prototyping it's great to run it on Windows, but for production use, it still belongs on a non-Windows server.
Now, the project to create a full Windows version that isn't based on CYGWIN has been around for a long time. I don't know if it's made any progress. According to this:
http://techdocs.postgresql.org/guides/Windows
the conversion is not done yet.
The Beta running on Windows has been out for months now with fairly good
reviews. I see that now, the production release is out as well. http://www.postgresql.org/docs/whatsnew
Thank you all for answers!
My additional question is concerning migration from MSDE to PostgreSQL. Is
there any easy way to migrate, at least tables (if not possible to migrate,
for example, stored procedures) ?
I am devoloping an .adp/MSDE aplication for a quite long time. The prototype
was in mdb, but then I migrated to MSDE because of triggers (for audit
trail) etc. I belived it will be easy to attach it to SQL Server if needed.
Now, I tried to attach it to new SQLEXPRESS and was told that it is not
possible and it was not intended to make it possible to use any variant of
SQL Server 2005 with Access. It makes me wondering whether Access Projects
have future. What if I won't be able to use my .adp aplications with new SQL
Server ? That would make my .adp aplication obsolete...
That is the reason why I consider migration to PostgreSQL...
Greetings,
Zlatko
"Steve Jorgensen" <no****@nospam.nospam> je napisao u poruci interesnoj
grupi:2r********************************@4ax.com.. . On Tue, 15 Mar 2005 02:59:56 GMT, "David W. Fenton" <dX********@bway.net.invalid> wrote:
"Ruben Baumann" <ry**@yahoo9.com> wrote in news:sb********************@megapath.net:
I don't know if PostgreSQL itself now runs under windows
Yes, it does.
But, last I checked, it runs on top of the CYGWIN libraries, and as Steve J. has pointed out, this leads to certain security vulnerabilities. From my perspective this means that for prototyping it's great to run it on Windows, but for production use, it still belongs on a non-Windows server.
Now, the project to create a full Windows version that isn't based on CYGWIN has been around for a long time. I don't know if it's made any progress. According to this:
http://techdocs.postgresql.org/guides/Windows
the conversion is not done yet.
The Beta running on Windows has been out for months now with fairly good reviews. I see that now, the production release is out as well.
http://www.postgresql.org/docs/whatsnew
Steve & Everybody,
Yay! If you have followed my posts over the years you will remember I tend
to answer most queries with "anything but Access." PostGRE here I come!
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:2r********************************@4ax.com... On Tue, 15 Mar 2005 02:59:56 GMT, "David W. Fenton" <dX********@bway.net.invalid> wrote:
"Ruben Baumann" <ry**@yahoo9.com> wrote in news:sb********************@megapath.net:
I don't know if PostgreSQL itself now runs under windows
Yes, it does.
But, last I checked, it runs on top of the CYGWIN libraries, and as Steve J. has pointed out, this leads to certain security vulnerabilities. From my perspective this means that for prototyping it's great to run it on Windows, but for production use, it still belongs on a non-Windows server.
Now, the project to create a full Windows version that isn't based on CYGWIN has been around for a long time. I don't know if it's made any progress. According to this:
http://techdocs.postgresql.org/guides/Windows
the conversion is not done yet.
The Beta running on Windows has been out for months now with fairly good reviews. I see that now, the production release is out as well.
http://www.postgresql.org/docs/whatsnew
"Alan Webb" <kn*****@hotmail.com> wrote in
news:QO********************@comcast.com: Yay! If you have followed my posts over the years you will remember I tend to answer most queries with "anything but Access." PostGRE here I come!
Well, if you're talking back end, Access is not a back end -- *Jet*
is a db engine that can be used as a back end, and if that's what
you mean, you should say Jet, not Access.
I reviewed PostgreSQL a while back and it seemed vastly superior to
MySQL at the time (and performed well in comparison, too). If I were
embarking on a project that needed a server back end, I'd definitely
start with PostgreSQL at the top of my list of back ends, especially
because I don't like being tied to Microsoft at every level of a
product.
I also find that SQL Server is not a simple product, and the
complexities of other server DBs don't look too daunting in
comparison to those of SQL Server.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Alan Webb" wrote Yay! If you have followed my posts over the years you will remember I tend to answer most queries with "anything but Access." PostGRE here I come!
I'd say that is about as self-defeating an attitude as "always Access" (no
matter what the requirements).
However, just as a reminder: Access is the UI for user-direct use of the
product and the tool for database application generation; it can be used
with the Jet database engine that is installed by default, or with any
ODBC-compliant database engine.
PostgreSQL is a database engine. It does not provide the end-user interface
nor database application generation of Access, so you cannot use it to
replace Access. It would be an alternative to MySQL, MS SQL Server, Oracle,
DB2, Informix, or the various Sybase server products, not an alternative to
Access.
Larry Linson
Microsoft Access MVP
Let's talk about Access as front-end to PostgreSQL...
Deployment of Access Projects with MSDE seems to be easy, since Access part
has a Connection wizard by which client can eysily connect to any MS SQL
Server.
When using MDB as a client front-end, it can be used only by ODBC drivers
either by linked tables or pass-through queries. In any case, ODBC string
must be specified. If that is true, it seems to be complex for installation
on client...
My question is: if I will use linked tables to PostgreSQL, for example, how
can I install front-end on clients without linking tables separately on
every client ?
I have never used linked tables and ODBC connections to other databases, so
forgive me if my question is trivial.
Thanks in advance.
"Larry Linson" <bo*****@localhost.not> je napisao u poruci interesnoj
grupi:ILOZd.5528$b_6.2228@trnddc01... "Alan Webb" wrote
Yay! If you have followed my posts over the years you will remember I tend to answer most queries with "anything but Access." PostGRE here I come!
I'd say that is about as self-defeating an attitude as "always Access" (no matter what the requirements).
However, just as a reminder: Access is the UI for user-direct use of the product and the tool for database application generation; it can be used with the Jet database engine that is installed by default, or with any ODBC-compliant database engine.
PostgreSQL is a database engine. It does not provide the end-user interface nor database application generation of Access, so you cannot use it to replace Access. It would be an alternative to MySQL, MS SQL Server, Oracle, DB2, Informix, or the various Sybase server products, not an alternative to Access.
Larry Linson Microsoft Access MVP
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
When using ODBC connection strings you can use the IP address of the
database server instead of the server name. You can connect to a
PostgreSQL db server that way, also.
For distributing an Access front-end to clients you can use a DSN-less
connection string in the linked tables. E.g.(just guessing for the
PostgreSQL connection string. Used Local Host as the IP address. Use
your correct IP address, instead.):
ODBC;Driver=PostgreSQL;Server=127.0.0.1;Database=M yDatabase
The default port that PostgreSQL uses is 5432.
Using MSDE (all one line):
ODBC;Driver=SQL Server;Server=127.0.0.1,1433;Database=MyDatabase;
Trusted_Connection=Yes
SQL Server (MSDE) listens on port 1433. If you've changed the port
number, be sure to change the connect string.
With each ODBC linked table having a DSN-less connection each client you
give the front-end to, if they have an Internet/Intranet connection, can
access the db.
If you have a local network w/ PostgreSQL on a Linux server you can use
Samba (a connection program for *nix to other OS) to link to PostgreSQL.
I did this about 5 years ago: Linux -> Windows NT 4. I was able to
link PostgreSQL tables to Access 97, but did nothing more than the proof
of-concept set up. I never used PostgreSQL as a production data source.
I downloaded the Windows version of PostgreSQL 8.0.1 today & am having
problems linking Access XP to it. Still reading the PostgreSQL
documentation & trying out ADO OleDB connection (not working 'cuz of
start up permissions).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQjf9tIechKqOuFEgEQLuNgCgnaWM9mCMvlZcb8ighCX/J3ACyaMAoNUD
TIHVbUZwXpgc+ucKHe0QPnT+
=gRh9
-----END PGP SIGNATURE-----
Zlatko Matiæ wrote: Let's talk about Access as front-end to PostgreSQL... Deployment of Access Projects with MSDE seems to be easy, since Access part has a Connection wizard by which client can eysily connect to any MS SQL Server. When using MDB as a client front-end, it can be used only by ODBC drivers either by linked tables or pass-through queries. In any case, ODBC string must be specified. If that is true, it seems to be complex for installation on client... My question is: if I will use linked tables to PostgreSQL, for example, how can I install front-end on clients without linking tables separately on every client ? I have never used linked tables and ODBC connections to other databases, so forgive me if my question is trivial.
< SNIP >
Try ODBC driver instead OLE DB...
I migrated tables from MSDE to PostgreSQL succesfully today...but I had to
set keys manually.
Also, I linked tables from MDB to database on PostgreSQL using ODBC driver.
You can download ODBC driver from http://www.postgresql.org/download/
I didn't have enough time to read PostgreSQL documentation, but I'm
wondering what is the Postgre's equivavalent of stored procedures...
Greetings,
Zlatko
"MGFoster" <me@privacy.com> je napisao u poruci interesnoj
grupi:Z4******************@newsread1.news.pas.eart hlink.net... -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
When using ODBC connection strings you can use the IP address of the database server instead of the server name. You can connect to a PostgreSQL db server that way, also.
For distributing an Access front-end to clients you can use a DSN-less connection string in the linked tables. E.g.(just guessing for the PostgreSQL connection string. Used Local Host as the IP address. Use your correct IP address, instead.):
ODBC;Driver=PostgreSQL;Server=127.0.0.1;Database=M yDatabase
The default port that PostgreSQL uses is 5432.
Using MSDE (all one line):
ODBC;Driver=SQL Server;Server=127.0.0.1,1433;Database=MyDatabase; Trusted_Connection=Yes
SQL Server (MSDE) listens on port 1433. If you've changed the port number, be sure to change the connect string.
With each ODBC linked table having a DSN-less connection each client you give the front-end to, if they have an Internet/Intranet connection, can access the db.
If you have a local network w/ PostgreSQL on a Linux server you can use Samba (a connection program for *nix to other OS) to link to PostgreSQL. I did this about 5 years ago: Linux -> Windows NT 4. I was able to link PostgreSQL tables to Access 97, but did nothing more than the proof of-concept set up. I never used PostgreSQL as a production data source.
I downloaded the Windows version of PostgreSQL 8.0.1 today & am having problems linking Access XP to it. Still reading the PostgreSQL documentation & trying out ADO OleDB connection (not working 'cuz of start up permissions). -- MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQjf9tIechKqOuFEgEQLuNgCgnaWM9mCMvlZcb8ighCX/J3ACyaMAoNUD TIHVbUZwXpgc+ucKHe0QPnT+ =gRh9 -----END PGP SIGNATURE-----
Zlatko Matiæ wrote: Let's talk about Access as front-end to PostgreSQL... Deployment of Access Projects with MSDE seems to be easy, since Access part has a Connection wizard by which client can eysily connect to any MS SQL Server. When using MDB as a client front-end, it can be used only by ODBC drivers either by linked tables or pass-through queries. In any case, ODBC string must be specified. If that is true, it seems to be complex for installation on client... My question is: if I will use linked tables to PostgreSQL, for example, how can I install front-end on clients without linking tables separately on every client ? I have never used linked tables and ODBC connections to other databases, so forgive me if my question is trivial.
< SNIP >
Zlatko Matic wrote: Try ODBC driver instead OLE DB... I migrated tables from MSDE to PostgreSQL succesfully today...but I had to set keys manually. Also, I linked tables from MDB to database on PostgreSQL using ODBC driver. You can download ODBC driver from http://www.postgresql.org/download/
I didn't have enough time to read PostgreSQL documentation, but I'm wondering what is the Postgre's equivavalent of stored procedures...
They have functions that can act as SPs.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Google Mike |
last post by:
You readers in comp.lang.php may use PostgreSQL, so you might find
this review useful...
ISBN 0-7357-1257-3 "PostgreSQL", Copyright 2003 by Sams Publishing.
Authors: Korry Douglas, Susan...
|
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from...
|
by: E. Zorn |
last post by:
Hi,
i use Access as a frontend via ODBC to an Linux-based postgresql.
I have a problem in a form where I use a lot of subforms. In some
cases ( i couldn't detect when - but I really try to) the...
|
by: Jeff Bowden |
last post by:
For ease of configuration and other reasons, I would like for my
single-user GUI app to be able to use postgresql in-process as a library
accessing a database created in the users home directory. ...
|
by: phil campaigne |
last post by:
On Mon, 1 Mar 2004, phil campaigne wrote:
>> Nigel J. Andrews wrote:
>>
>
>
>>> >On Mon, 1 Mar 2004, Phil Campaigne wrote:
>>> >
>>> >
|
by: Chris Ochs |
last post by:
We have a number of tables in a CRM that is written in MS access that I need
to be able to provide a web interface to. I can export the tables just fine
using pgadmin II, but I cant' think of a...
|
by: Randy Yates |
last post by:
Is opening up port 5432 (R/W both directions) all that is required
of a firewall in order to access a postgres database outside the
firewall?
--
% Randy Yates % "My Shangri-la...
|
by: jptpjs via AccessMonster.com |
last post by:
I have an application I built in Access 2003. It is an electronic medical
records program split into front end (8 computers) and back end.
This runs flawlessly. Purchased a billing program that...
|
by: Patvs |
last post by:
I use poker software (HoldemManager) to keep track of the statistics (and show nice graphs) of millions of poker hand histories.
This software (also PokerTracker 3) imports all the poker hands in...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
|
by: SueHopson |
last post by:
Hi All,
I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...
| |