Buttons have stopped working?

[Kirstie Adam]

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

 

[Steve]

Your file is most ikely corrupted beyond repair. Trying to fix the buttons
probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Kirstie Adam]

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

Your file is most ikely corrupted beyond repair. Trying to fix the buttons
probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

 

[Steve]

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 Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

Your file is most ikely corrupted beyond repair. Trying to fix the
buttons probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

 

[Kirstie Adam]

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

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 Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

Your file is most ikely corrupted beyond repair. Trying to fix the
buttons probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)


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

 

[Steve]

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 Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

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 Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

Your file is most ikely corrupted beyond repair. Trying to fix the
buttons probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)


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

 

[Kirstie Adam]

Steve,

I now do need to import something into my database, so i followed the steps
below. BUT when i click Debug - Compile, nothing happens?
There is no compile dialog which i can see.

Any suggestions?

Kirstie

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 Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

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

Your file is most ikely corrupted beyond repair. Trying to fix the
buttons probably will not work. Hope you have a backup

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)


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