Обсуждение: Access problems

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@Fam-Meskes.De           | Use PostgreSQL!

Michael Meskes wrote:

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

I am a bit rusty on the internals on the psqlODBC driver as it relates to MS
Access.  But as I seem to recall, Access cannot have a key column over 256
bytes.   Text columns are virtually unbounded.    This may explain some of your
tables linking problems.   If you can, try changing some of those primary key
fields to varchar(255) or smaller.

Ultimately what you  need to do is activate the logging feature in the driver
and attach a minimalist failure log file.

On Mon, Dec 20, 1999 at 02:45:19PM -0500, David C Hartwig Jr wrote:
> I am a bit rusty on the internals on the psqlODBC driver as it relates to MS
> Access.  But as I seem to recall, Access cannot have a key column over 256
> bytes.   Text columns are virtually unbounded.    This may explain some of your
> tables linking problems.   If you can, try changing some of those primary key
> fields to varchar(255) or smaller.

I did and now it works without a problem.

Thanks a lot.

> Ultimately what you  need to do is activate the logging feature in the driver
> and attach a minimalist failure log file.

I did but did not find much of an explanation. But then maybe I didn't check
closely enough.

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@Fam-Meskes.De           | Use PostgreSQL!