B
Bret
I am using access 97 on a windows 2003 server. Even though the install
of access goes cleanly I believe I have a problem with reports using
vba in any way.
All reports, regardless of record source, complexity or function call,
will crash it any vba event is called. I have tried:
1. uninstall access and reinstall access
2. check the reports from other machines ( they work properly)
3. check for refrences. (they are all there)
4. create a new report from scratch.
5. create a new database.
6. create a report with now recordset, and just call the function with
no code in the call
7. reinstall the printers
8. use different printers
I can call macros and use vba code from a module, no report events
like format or retreat or print can be used without access crashing.
Windows does not pormpt me of what the error is and the lock files
remain even though I'm the only one accessing the file right now.
The purpose of this is that I have auto exports and reports that come
from a vb6 application. everything works except for the reports.
I have found that my msjet.dll is not the current version and I am
attempting to update with service pack 1 but since it happens even if
there is no recordset at all i don't know if this will work or not.
Please someone, Help!!
of access goes cleanly I believe I have a problem with reports using
vba in any way.
All reports, regardless of record source, complexity or function call,
will crash it any vba event is called. I have tried:
1. uninstall access and reinstall access
2. check the reports from other machines ( they work properly)
3. check for refrences. (they are all there)
4. create a new report from scratch.
5. create a new database.
6. create a report with now recordset, and just call the function with
no code in the call
7. reinstall the printers
8. use different printers
I can call macros and use vba code from a module, no report events
like format or retreat or print can be used without access crashing.
Windows does not pormpt me of what the error is and the lock files
remain even though I'm the only one accessing the file right now.
The purpose of this is that I have auto exports and reports that come
from a vb6 application. everything works except for the reports.
I have found that my msjet.dll is not the current version and I am
attempting to update with service pack 1 but since it happens even if
there is no recordset at all i don't know if this will work or not.
Please someone, Help!!