Unable to access my SQL files on the Network

[EPNICO]

Hello:

I have an access 2003 program that reads a sql database, this is accomplished using ODBC connection and produces a very complex report.
This report has been running for several years with no problems. Randomly I get an error stating "Network error" or "disk error". I have plently of disk space and network connectivity is there. Any ideas are welcome.

Regards,

Nico

 

[Hap007]

Hi Nico,

I have seen that error come up when you have a bad VBA code module in your MS Access program.

This can happen at any time, but seems to occur more often if you import or rename a form or report or module or module file.

Whenever you do an import of a form or report or a rename, the very next step is to open up the design window, then the VBA Code window.
Select the option 'Debug' and then pick Compile.

These are the steps that you should do during development.

For your problem now, just do the compile.

Note: To solve the potential problem, you must get a full clean compile.

Sometimes, when you do the compile, the compile process itself will report a network error. At that point, the module that will not compile has gone bad will need to be replaced, so makesure you have good backups.

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121