Thread: 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!
Attachment
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!