Re: Buttons have stopped working?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Way to go!! That was great thinking!

Yes about service packs.

You might want to consider splitting your database. I have never seen your
problem occur in a backend file. If you have a split database and you
experience this problem, the problem will be i the frontend file. It is most
likely that your backup of the frontend is current so all you need is to put
a copy of the backup into operation. You shouldn't have to do anything with
the backend file and all your data will be current.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx




"Kirstie Adam" <kirstiea@xxxxxxxxxx(nospam)> wrote in message
news:OzPDCYswHHA.3796@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for that, is good to know!

I got around the problem without too much hassle - I took the back up
database from a couple of weeks ago which had all correct forms and
reports etc, but had out of date table information and deleted the tables.
Then i imported into it the tables from the database which had corrupted
the forms, as the info in the tables was up to date and still ok. So now
database back to normal.

Just to clarify though SR-2 and SR-3 - is that the service packs?

Kirstie

"Steve" <sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:4fxki.5331$rR.2813@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
It was caused by your importing. It's a bug in Access2000.

When you do an import into Access2000, you need to do the following
BEFORE CLOSING THE DATABASE:

1. At the database window, press Alt + F11
2. Click Debug - Compile in the menu at the top of the screen
3. Close the Compile dialog then save the database file.

SR-2 and SR-3 cured this bug.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx



"Kirstie Adam" <kirstiea@xxxxxxxxxx(nospam)> wrote in message
news:uvXgsqjwHHA.4588@xxxxxxxxxxxxxxxxxxxxxxx
do you know why this would have happened?

i import and export all the time and it's never happened before

i do have a backup, but sadly is a couple of weeks old :(

kirstie

"Steve" <sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ZVrki.6412$zA4.4966@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Your file is most ikely corrupted beyond repair. Trying to fix the
buttons probably will not work. Hope you have a backup :(

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx


"Kirstie Adam" <kirstiea@xxxxxxxxxx(nospam)> wrote in message
news:uU9wrZjwHHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I have been in and out of my database throughout today, and i just
went in to update it and all the buttons have stopped working!

I get the following message whenever i click one of the buttons on any
of the formss:

"The expression On Click you entered as the event property setting
produced the following error: Error accessing file. Network connection
may have been lost.

- The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
- There may have been an error evaluating the function, event, or
macro."

The only thing i did today different from normal was to import the
contents of this database into another database so i could play about
with the format of the forms and reports. However the database i
imported into is also showing this error.

Could this have been caused by me importing? Can it be easily fixed
without redoing all my buttons?

Kirstie













.

Quantcast