Skip to main content
Inspiring
January 24, 2007
Question

Access database losing default values for table columns

  • January 24, 2007
  • 1 reply
  • 171 views
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 has been closed for replies.

1 reply

Inspiring
January 24, 2007
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