Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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!

Responses

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group