synchronizing MS access and postgresql tables

Chris Ochs

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

Subscribe Reply

1783

Joshua D. Drake

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 YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #2

Joshua D. Drake

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

Nov 23 '05 #3

Michael Meskes

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.o rg
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

Michael Meskes

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) ?

Nov 23 '05 #5

Similar topics

2407

Access Corruption / MySQL

by: Mike | last post by:

I recently had a Microsoft Access 97 database corrupt on me. The setup is a split database (front end/back end) setup with about 10-15 users. This is the first corruption in something like a year. The database has about 25 tables, and the total size is about 15MB, after a compact. The front end sits on users Windows 2000 Professional desktops, and the file server is a Windows 2000 Server. I've been thinking of migrating the back end,...

Microsoft Access / VBA

1562

Synchronizing Microsoft Access

by: Phil Matish, MCSE | last post by:

I have an Access database that I use frequently. Often, I take it to a home PC, or laptop to work on at night. The next day, I overwrite the old one with the one I have been working on. The only problem is - during this time, others may want to add records at the office. This causes an obvious data loss problem if I overwrite their edition of the database. Is there a way to synchronize the database? If someone made additions at...

Microsoft Access / VBA

7293

PostgreSQL and MS Access

by: Zlatko Matiæ | last post by:

Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?

Microsoft Access / VBA

1306

Access Conversion

by: Mark Lubratt | last post by:

Hello, I'm trying to convert an Access application to have its backend be PostgreSQL. I've created the schema and imported the data without a problem. My problem is that the Access application wasn't written by me and has numerous queries and table relationships that I want to replace in place with tables linked to the new backend.

PostgreSQL Database

296

synchronizing MS access and postgresql tables

by: Chris Ochs | last post by:

PostgreSQL Database

3571

Rows created by a stored proc prompt Access' dreaded "write conflict"

by: Eric E | last post by:

Hi all, I am using an Access client linked to a PG 7.4 server via ODBC. I have a stored proc on the server that inserts rows into a table.particular table, accomplished via an INSERT within the body of the stored proc. The procedure does not explicitly commit this data, as no transactions are invoked. The problem is that Access will not modify these records via table or form view, giving its generic "Write conflict: another user has...

PostgreSQL Database

5487

PostGreSQL to Access Updatable recordset

by: Sim Zacks | last post by:

I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to AdOpenStatic, even if I choose adOpenDynamic. If anyone has any thoughts, please let me know. The form works great for viewing, but I cannot update or insert any new records. Below is the code I am using: connectstr = "DSN=SAP_PG;uid=postgres" Set conn...

PostgreSQL Database

2917

Is There a Client/Server Version of Access ?

by: B1ackwater | last post by:

We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...

Microsoft Access / VBA

2610

Access and Postgresql

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 uses Postgresql. This resides on the same computer as our Access backend. We keep getting knocked out of the new billing program and never get knocked out of my Access program. The billing software provider says that Access and Postgresql running...

Microsoft Access / VBA

9647

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9489

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10357

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10162

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10101

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

5396

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5528

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3665

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2893

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General