Access 2003 to Access 2007 .select error

[tbassngal]

Hi all, we have been upgraded to Access 2007 without our knowledge of it coming and a critical program for us is halted now as a result. Some of the code that it is stopping on is:

XLTemplateWorksheet.select

I get an Access error box that says: Automation Error, The server threw an exception.

What the heck does that mean? If anyone can assist, it would be greatly appreciated. I've never even used MS Access 2007 - not even once yet! Please help!

Additionally, does the holding of the shift button now not work to bring up the database window? We set the switchboard to come up for our users so they can't see the database objects, now we are having a heck of a time too!
Thank you, Tina

 

[Remou]

Have you checked your references?

The shift-key should work. Here is some more information:

http://support.microsoft.com/kb/826765

These may help.

http://allenbrowne.com/Access2007.html

http://technet.microsoft.com/en-us/library/cc178943.aspx