Access 2002 - default value does not appear in table

[larry]

A table in an application has default values set in the table design view.
In particular there is a SetupDate field that has a default value =Now().

I am using Windows98 SE and Office 97 except for Access 2002 and I have no
problems.

A user, far enough away that I can't visit him, has problems with this
application. He sent me copies of the database files after he entered some
data and the default values, in particular the SetupDate, are blank.

He has tried this application with Windows XP and Windows 98 SE, both of
them using Office XP.

Nothing in the application ever tries to modify the SetupDate field.

Is there any know problem with the default values for tables in Access 2002?
I checked the support.microsoft.com Knowledge Base but the closest I could
find was a reference a problem with Dataview forms.

Thanks.


larry

 

[Arvin Meyer]

It may be references. When a reference is marked as MISSING, any function
may not work correctly. I suspect that the Now() function may be suffering
from this lost reference. Open any code window (Ctrl+G) and find any
reference marked as "MISSING".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[larry]

It may be references. When a reference is marked as MISSING, any function
may not work correctly. I suspect that the Now() function may be suffering
from this lost reference. Open any code window (Ctrl+G) and find any
reference marked as "MISSING".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I thought of that and I think that is not the problem but I'll try to check
again. The problem is that I can't actually visit him and do this myself. I
have to instruct him via email and he is only semi computer literate (it's
amazing what MDs don't know) but his (apparently) very computer literate son
(a research type for Cisco) was visiting last weekend and he could not find
any problems. I gave instructions to check the references and I assume he
did.

I'm trying to confirm if this is just a problem with initializing the date
fields or if all default values, most of them zeroes, are affected. I
suspect the latter.

Thanks.

larry