Re: Access, ODBC and "other users"

Hello,

Where does your script run? In Access, or in a stored procedure? I guess it's in Access.

Are you using the latest driver, and does this problem continue even if you shut down Access, and start it again? Strange...

-----Message d'origine-----
De : Michelle Murrain [mailto:tech(at)murrain(dot)net]
Envoyé : mardi, 4. novembre 2003 01:11
À : pgsql-odbc(at)postgresql(dot)org
Objet : [ODBC] Access, ODBC and "other users"

We have an interesting problem with Access and ODBC. We have a fairly
complex application, all tables and such are on Postgres. 1/2 the
application is an Access front end (for nice reporting and some data
entry) and 1/2 of the application is a web front end (for "public"
access to some of the data, and interfaces for some remote
administration. There is an overnight script that runs that updates a
couple of tables (some detailed calculations that just take too long to
do on the fly). After this script runs, Access then doesn't let anyone
update the table, because "another user has modified the data".

However, as far as pg is concerned the same exact user has changed data,
the user used in the ODBC driver connection is the same user that's used
both on the web end, and in the overnight script.

Is there a way to tell Access to ignore this? Are there ways around this
that anyone can think of, short of 1) relinking the table every morning
or 2) creating a new table just for the calculation results?

--
.Michelle
---------------------------
Michelle Murrain
mmurrain(at)dbdes(dot)com
Database Designs Associates, Inc.
Boston 617.889.0929
Amherst 413.253.2874
Cell 413.222.6350
www.dbdes.com

AIM:pearlbear0 ICQ:129250575

"Our capacity to make peace with another person and with the world
depends very much on our capacity to make peace with ourselves." -- Thich Nhat Hanh

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly