checkboxes stopped working

[DMainland]

I have been using a database for many years without a hitch. All of a sudden
the checkboxes on a form stopped working. The form is used to update
invoices that are being paid by checking the 'invoicePD' checkbox which then
inserts today's date in a field called 'InvoiceDatePD.' A command button on
the form would then check the math (amount) of the invoices checked off.
That window has stopped working also.

I checked the underlying table and the checkbox fields work. I checked the
underlying query, and the checkboxes do not work. I imported and the forms
and queries involved from a known-good, archived database and the problem
persisted. I am at a loss as to what is causing this to happen. Any help
would be greatly appreciated.

 

[Ken Snell \(MVP\)]

Using ACCESS 2003? Did you recently install the SP3 update? Are you using a
front end that is bound to a SQL Server table?

Perhaps this is the issue:
http://support.microsoft.com:80/kb/945674

If not, post back with more details about the software version, your setup,
etc.

 

[DMainland]

The database is Access 2000 and has been working very well for many years.
Recently, the boss accessed the database from his home pc via 'GotomyPC'.
Shortly thereafter some strange things began to occur (they may have been
coincidental to his home PC access; don't know for sure). Anyway, what
happened was 'Process#'s' were being duplicated and they are autonumbers.
Two were assigned to the same CASE and the same Process# was once assigned to
two different CASEs.

Many strange things occurred when duplicate autonumbers were in the records.
I didn't think such a duplication was possible. After deleting the dups the
database appeared to return to normal. But up pops this problem of
checkboxes not working in forms and underlying queries. Update forms are
used in two major areas of the database; one to help update accounts
receivable and one to update payments made to people who do work for the
company. In both areas of the database which operate with separate forms,
tables, and underlying queries, the checkboxes in the queries and the update
forms stopped working. I have tried importing new known good forms, queries,
etc. I have re-installed Access. I have done virus scans and system
untilities to no avail. Any help or suggestion would be greatly appreciated
as the lost functionality is vital to the office.

 

[KumbiaKid]

You still haven't given us very much detail about your app -- for example, is
the DB replicated or do all users work on one copy of the DB?

In any case, a general "shotgun" approach that crops up a lot on this forum
to fix weird problems with Access is to create a new, empty DB, then import
all objects from the misbehaving DB into the new one. If the problems are due
to corrupt system tables, this seems to fix them. Give this a try. Of course,
you have to make sure that only you have the DB open when you do this and if
the DB is replicated, make sure to synch all replications first. If that
doesn't fix your problem, please provide as much info as you can (OSs and
versions of Access -- does your boss possibly have Access 2007 on his
machine? -- SPs installed, etc.). Good luck.

KumbiaKid

 

[DMainland]

Thanks for the reply. The split database is run in Access 2000 over a peer
to peer network on five machines. Operating systems vary from W2000 Pro
which houses the backend to Win XP and even Windows 98 on one machine. I
have been trying every possibility and now suspect 'tblProcess' is the
problem. I tried importing object by object into an new database and came up
with the same problem.

When I import the tables all at once into a known good front end, the file
inherits the same problem. Yesterday, I got a version to work for 5 minutes
(did the same importing), and then it went inoperative with the checkboxes
the next time I opened it.

Today,I will try to append the data into a new (structure only) tblProcess
and see if that works. Any other suggestions would be greatly appreciated.