Skip to main content
Inspiring
Jan 24, 2007 9:28 AM UTC
Question

Access database losing default values for table columns

I have a problem with an Access database that feeds the website of one of my
clients.

In the database there is a members table that has several columns that were
originally defined to have default values, eg. 0 for numeric columns or
Now() for date/time columns.
But somehow these default values get lost while using the webapplication,
although there are no SQL statements that alter the database structure to be
found in the application.

Does anyone here have an idea what might cause this?
Thanks in advance.

Regards, Marja


This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

Inspiring
Jan 24, 2007 10:29 AM UTC
Some more information:
It is an Access2000 database, and I've now found out that it is the "compact
database" action, triggered from the webapplication using JRO.JetEngine,
that causes this.

But why this happens is still beyond me.
Anyone?

Regards, Marja


Translate