I'm trying to use Access 2002 as a front end to postgresql on a small LAN,
with several local users and a few intermittent users via VPN from home.
Server : SCO OSR 5.0.7
postgresql 7.3.4 - binary version that came with a recent SCO
update; will build a new version from source when time
allows.
Workstations: XP Pro or Windows 2000
cygwin version 7.4.1 on two XP boxes, along with
PGAdminIII and
psqlodbc 7.03.02.
Hope to asynchronously replicate from the server to the Windows boxes at
night in addition to server DAT and DVD backups. The workstations will
eventually get Office XP Developer runtime versions of the planned
application.
Some of the tables will need something analogous to an Access autonumber
field. Postgresql sequences used to populate an int8 column seem similar. A
short VBA procedure could set the field value to nextval(sequence_name) as
the BeforeUpdate event for a data entry form. Would this be the correct
approach?
Should queries be passthrough whenever possible, for speed?
Thanks,
David P. Lurie