Code causes Access 97 to close when using 2003 server

[nickpin]

Hi all,

I have a database written in Access 97 used as a front end to MySQL and SQL server. On opening, it has a form with a Search button. The search button uses the code:

DoCmd.openform "frm_rpt_date"

This works on all PC's that I've tested on (XP Pro using Access 97), but now I have moved it to a Windows 2003 Server box and clicking the button causes Access 97 to close, leaving the lock file in the directory. All the tables still work if I open them, queries run if clicked on, macros run as normal. The problem is buttons with any VBA code.

I figure this is a security issue on server 2003 but I have no idea how to sort it. To pre-empt some questions:

This was entirely written in Access 97, it's never been converted or opened in any other version.

I've tried creating a new database on the 2003 server using Access 97 and it gives the same problem.

I've tried importing all objects into a new database and it gives the same problem.

Help! Please!

Thanks,
Nick

 

[PHV]

Double check the references
menu Tools -> References ...
Does the database compile properly ?
menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886