Error Accessing File

[jasek78]

I have a database in Access 2000.
Table Structure:
Management table (daily information),
Project table (Project info)
Phases (for data entry into 'Phases' field of Management Table)

These tables are stored in a separate database and linked to the Reports database. I created a query that selects all records over a time period for 1 client. I have a report that takes the query and groups it by phase.

In the "Group Footer_Format method I have the following code:

If [Phase] = "Value-Added Service" Then
sngValueAdded = txtSumHours.Text
End If

This adds up all of the records that are "Value-Added Services" so I can subtract them from the Total to give a "Net Hours" total.

This report worked last week. Now when I run it, I get this error message:

"Error Accessing File: Network Connection May Have Been Lost"

Has anyone experienced this before and now how to fix/work around it?

thanks!

Jason

 

[pdldavis]

Yes, I have. If you try viewing the report in design view and view the code behind the report - and you can't, the report is corrupt. Sometimes you can import a back-up report and that will fix the problem. Other times the only solution is to create a new database and import all the items from your current database except the corrupt report.
I think the Microsoft Knowledge database has some information on that specific error as well.

 

[jasek78]

I was afraid that was the problem. I found an older backup and added the 2 lines of code to a report then copied over the database that was messed up. It works perfectly. Gee, go figure?

Thanks for the reply =^)


jason

 

[dawnd3]

have you found a solution to this. I have had this happen to every database on my new Dell laptop. Win 2000. Could it be problem with the network and Access working together. I really need help troubleshooting why this happens. I know how to work around it, but why is it happening?

Dawn

http://www.calliopeconsulting.net