date() and now() function not working

[Jbliss503]

I am having a peculiar issue right now. I have a database that is used by multiple people. Everything has been working fine until, all of a sudden, access isn't recognizing the date() and now() functions, which is causing all manners of errors. I could understand if the error was specific to one, or even a few machines; however, this is a network-wide issue all of a sudden. Anyone out there have any ideas what could be causing this? I have checked all of the references in access and none are missing. I am currently trying to repair my installation of access (2007) and am running windows XP (as are all of the other users).

Thanks in advance

 

[boblarson]

Is this a split database with backend (tables only) on the file server and then a frontend with a copy on each user's machine? If not, it should be.

But if it is a single file or single frontend on the server (which isn't good when using multiple users), you probably need to run a DECOMPILE on the database file.

See here for more about that:
http://www.granite.ab.ca/access/decompile.htm

(and make sure to make a copy of the file BEFORE you decompile in case something bad happens)

 

[Jbliss503]

It is a single replicated access 2000 database... I know... replication... blah!!! At any rate, compacting or decompiling will remove the "make table replicable" property from all tables. I am not sure what happened to this database, but I fixed the problem by restoring a previous version of it.

Thanks for the help