Error Message Help

[petercummins]

When I run a report I created, a VB error box appears stating: -

'Error Accessing File. Network connection maybe have been lost.'

Any idea what this means and how it can be fixed?

 

[KenHigg]

I'm guessing it simply means your network went offline for second or two...

Have you tested the network?

 

[petercummins]

Network is fine. I was told to always compile my VB Code before returning to work on Access however I think i didnt at some point. If this is the cause, any idea how you reverse it?

 

[KenHigg]

Hum... Pre-compiling simply causes errors in the code like syntax and spelling mistakes to surface so you can fix them ahead of time. So it kind of don't make sense to reverse it(?). Maybe the next thing I would try would be to check the references...

Or you doing anything other than attaching to the backend .mdb (tables) through the network?

 

[petercummins]

Not doing anything other than attaching to the backend tables. Its got me stuck this one.

 

[KenHigg]

Hum...

Do a new, real simple report based on the same query or table and see if you get the same error...

 

[petercummins]

That seems to work. Only problem is I have a fair amount of reports that are bringing up the same message. Looks like Ill have to redo all the reports!

 

[KenHigg]

I suppose you've compacted and repaired the db?

 

[petercummins]

yeah that was done after every session.

 

[KenHigg]

Hum...

And you can't find anything odd and common through out the reports, like maybe some kind off system function in the code or maybe a common logo type image?

 

[RV]

Sounds like your reports got corrupted.
Only option I know of is to rebuild your reports from scratch

RV

 

[petercummins]

I think even rebuilding them wont stand much of a chance now. Just redone one report and when it came round to saving it Access crashed. There could be a phone call to the IT helpdesk on the cards.

 

[KenHigg]

Have you tried tinkering with it on a different workstation?

 

[petercummins]

Apparently the problem is that there is a fault with a patch that is installed to help solve my problem. however this patch isnt working correctly. Now having to import all table, queries, reports, macros and modules into a blank DB along with all references used.

 

[KenHigg]

Let us know if/how you end up fixing it