Access problems

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Access problems
Date: 1999-12-20 14:23:53
Message-ID: 19991220152353.A585@fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I have installed onshore-timesheet on my machine. It works like a char. No I
tried to access the database via M$ Access and found some problems. The ODBC
connection is up and running. However, Access refuses to link in several
tables.

I attach the table definitions.

It says the following attributes are not correct either in index or in
relationship definition:

table attribute
-------------------------------
category category_id
hours del
job downloaded
notification fkpersonnel_id
personnel personnel_id

Only the client relation is okay.

So far I wasn't able to see what's wrong with these. Maybe anyone on this
list has an idea. Also ODBC logs don't show something special.

Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!

Attachment Content-Type Size
tables.sql text/plain 4.1 KB
indices.sql text/plain 985 bytes

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Kelvin O. Lim 1999-12-20 17:17:20 RE: access97-Recordset not updatable
Previous Message Mike Mascari 1999-12-20 13:17:10 [INTERFACES] Pattern matching fun via ODBC