By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

synchronizing MS access and postgresql tables

P: n/a
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 clean way to import them from
postgresql back to access. Synchronizing only needs to happen once a day
at the most.
I was also thinking of using the MS access forms with access tables that are
just odbc links to the postgresql database. Does anyone know off hand if
changing the MS access tables from a native table to a linked table would
require changes in the forms (not counting having to tweak/change data
types) ?

Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.669 / Virus Database: 431 - Release Date: 4/28/2004
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hello,

I was also thinking of using the MS access forms with access tables that are
just odbc links to the postgresql database. Does anyone know off hand if
changing the MS access tables from a native table to a linked table would
require changes in the forms (not counting having to tweak/change data
types) ?
This does work, we have done it. However you will want to over time move
a lot of the stored queries etc... to PostgreSQL versus Access for
performance reasons.

Sincerely,

Joshua D. Drake

Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.669 / Virus Database: 431 - Release Date: 4/28/2004
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

P: n/a
Hello,

I was also thinking of using the MS access forms with access tables that are
just odbc links to the postgresql database. Does anyone know off hand if
changing the MS access tables from a native table to a linked table would
require changes in the forms (not counting having to tweak/change data
types) ?
This does work, we have done it. However you will want to over time move
a lot of the stored queries etc... to PostgreSQL versus Access for
performance reasons.

Sincerely,

Joshua D. Drake

Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.669 / Virus Database: 431 - Release Date: 4/28/2004
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #3

P: n/a
On Fri, Apr 30, 2004 at 09:29:53AM -0700, Chris Ochs wrote:
I was also thinking of using the MS access forms with access tables that are
just odbc links to the postgresql database. Does anyone know off hand if
That's exactly what I would propose.
changing the MS access tables from a native table to a linked table would
require changes in the forms (not counting having to tweak/change data
types) ?


I don't think so.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: me****@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #4

P: n/a
On Fri, Apr 30, 2004 at 09:29:53AM -0700, Chris Ochs wrote:
I was also thinking of using the MS access forms with access tables that are
just odbc links to the postgresql database. Does anyone know off hand if
That's exactly what I would propose.
changing the MS access tables from a native table to a linked table would
require changes in the forms (not counting having to tweak/change data
types) ?


I don't think so.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: me****@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.