Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Access database losing default values for table columns

LEGEND ,
Jan 24, 2007 Jan 24, 2007
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


TOPICS
Server side applications
172
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 24, 2007 Jan 24, 2007
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.

But why this happens is still beyond me.
Anyone?

Regards, Marja


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines