M
Mark
Hi
I wonder if anyone else has seen Access issues specific to Server 2003 SP2?
Our Access 2002 runtime application is crashing during the statement that
adds a table definition to the catalog using ADOX.... cat.Tables.Append
tbl. There is a delay executing the statement then Access dissapears,
quitely on some servers and with a GPF dialog on others.
The same applcation works fine on Windows XP SP1 and SP2 and on Server 2003
SP1 and only exhibits this behaviour on Server 2003 SP2 in runtime mode.
Running the code in an mdb on Server 2003 SP2 works.
The sub has error handling but the app crashes on the add statement with no
further execution. MsgBox prompts before every line of code in the sub
confirm it is the above line.
We've tried all the obvious stuff like decompile, compact & repair, creating
a new mdb and importing original objects and making a new mde, making the
mde in a Server 2003 SP2 environment, using correct references in 2003 SP2
environment etc but cannot get around this.
Any help really, *really* appreciated.
Regards
Mark
I wonder if anyone else has seen Access issues specific to Server 2003 SP2?
Our Access 2002 runtime application is crashing during the statement that
adds a table definition to the catalog using ADOX.... cat.Tables.Append
tbl. There is a delay executing the statement then Access dissapears,
quitely on some servers and with a GPF dialog on others.
The same applcation works fine on Windows XP SP1 and SP2 and on Server 2003
SP1 and only exhibits this behaviour on Server 2003 SP2 in runtime mode.
Running the code in an mdb on Server 2003 SP2 works.
The sub has error handling but the app crashes on the add statement with no
further execution. MsgBox prompts before every line of code in the sub
confirm it is the above line.
We've tried all the obvious stuff like decompile, compact & repair, creating
a new mdb and importing original objects and making a new mde, making the
mde in a Server 2003 SP2 environment, using correct references in 2003 SP2
environment etc but cannot get around this.
Any help really, *really* appreciated.
Regards
Mark