Access 2000 buttons stopped working

[gump]

I have put about 2 days of work into an Access database using 2000 with many
macros and code linked to buttons, when suddenly every button stopped
working. Going to a previous day's backup did not work. As suggested in a
response to another post, I created a new database and imported everything,
but still no buttons work. When I try looking at the "On Click" expression
nothing comes up, I cannot launch the Code Builder (Expression and Macro
Builders work fine) and when I try to add a new button using the wizard it
will get to the point of naming the button and give me a "Subscript out of
range" error with no further explanation. It's like VB is gone for this
database only, and I really don't want to start re-creating all my forms and
reports from scratch without knowing how or why the problem occured. I do
link to another SQL database (SYSPRO) for some tables, but this is the same
in all our existing databases that continue to work fine. There is also a
link to an Excel spreadsheet which is a first for me - could that cause the
VB problems?

 

[Arvin Meyer [MVP]]

Your form is probably corrupt. Working on a copy of the file (Do not work
on the original because you may make it even more corrupt) Try using the
Application.SaveAsText code on my website:

http://www.datastrat.com/Code/DocDatabase.txt

Then use the new database you built to reload the form. There is a very good
chance that it will be fixed.

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Alan]

I have put about 2 days of work into an Access database using 2000 with many
macros and code linked to buttons, when suddenly every button stopped
working.  Going to a previous day's backup did not work.  As suggestedin a
response to another post, I created a new database and imported everything,
but still no buttons work.  When I try looking at the "On Click" expression
nothing comes up, I cannot launch the Code Builder (Expression and Macro
Builders work fine) and when I try to add a new button using the wizard it
will get to the point of naming the button and give me a "Subscript out of
range" error with no further explanation.  It's like VB is gone for this
database only, and I really don't want to start re-creating all my forms and
reports from scratch without knowing how or why the problem occured.  I do
link to another SQL database (SYSPRO) for some tables, but this is the same
in all our existing databases that continue to work fine.  There is alsoa
link to anExcelspreadsheet which is a first for me - could that cause the
VB problems?

Hi,

If you cannot handle the recover by yourself, I think you can try a
utility called Advanced Access Repair to repair your Access MDB file.
It works rather well for my corrupt Access MDB files. Its web address
is http://www.datanumen.com/aar/ Hope this helps.

Alan

 

[Tony Toews [MVP]]

If you cannot handle the recover by yourself, I think you can try a
utility called Advanced Access Repair to repair your Access MDB file.
It works rather well for my corrupt Access MDB files. Its web address
is http://www.datanumen.com/aar/ Hope this helps.

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/