Debugging Access...(not VBA)

[neillovell]

Hi,
I've got an Access database and users enter data over the network via a series of ASP pages. One of these fields is the week number, and is used to note what records to display in the 2 week and 8 week views.

However for two people the week number, although on the asp pages it states it is the correct week, is logged into the system as a much greater or lower number. So whereas we are on week 21 PersonA has 42 in their week field in the database, and PersonB has 2 (PersonA is a local network user, personB is connecting to the network from the US).

How can you check information as it comes into the database? is there some way to log the data in a text file or something?

 

[jrbarnett]

Access itself doesn't support triggers which is unfortunate in this situation, but you could run a server side script in the ASP form post routine
to append debugging information to a log table with their SQL statement, username and date/time of transaction.
John