/t5/dreamweaver-discussions/access-database-losing-default-values-for-table-columns/td-p/692512Jan 24, 2007
Jan 24, 2007
Copy link to clipboard
Copied
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.
/t5/dreamweaver-discussions/access-database-losing-default-values-for-table-columns/m-p/692513#M194037Jan 24, 2007
Jan 24, 2007
Copy link to clipboard
Copied
LATEST
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.