I am having troubles running a "docmd.runsql" statement on a machine with the Access 2000 runtime version installed. The statement (and code) works fine on any machine with full Access on it but shuts down the database on my runtime machine. The command looks like:
The "sqlstring" is a delete command something to the effect of "Delete * from tblTableName ..."
The interesting thing about this ( to me anyways) is that it doesn't give a error message. It pops ups a window with the message "Microsoft Access for Windows has encountered a problem and needs to close. We are sorry for the inconvenience." and gives the option to send or not send a notification to Microsoft.
Is this an error with just that copy of Access Runtime or should I go about this delete a different way for my runtime machines