Lemonde
  • Lemonde
  • Advanced Member Topic Starter
3 years ago
In Monsoon StoneEdge (Microsoft Access) we are seeing the following error:

Visual Basic Runtime Error 3012, Object 'IVAQ1' already exists:

UserPostedImage

So the query still exists in the DB?

I know that this query normally gets removed but the report must have been interrupted before it could delete the query so now we need to remove it manually...

How do we manually remove a temporary query from Microsoft Access Database

Our Monsoon StoneEdge runs in Microsoft SQL by the way.


Sponsor

Want to thank us? Use: Patreon or PayPal or Bitcoins: 12G4A52Znm5s35buKDEmKU2p2vQY69Nsyo

Protect your visitors with SSL, from $3.44

All opinions expressed within these pages are sent in by members of the public or by our staff in their spare time, and as such do not represent any opinion held by sircles.net Ltd or their partners.


Lemonde
  • Lemonde
  • Advanced Member Topic Starter
2 years ago
This value should actually be deleted on completion of the report, but if it is not then you can manually delete by opening the Microsoft Access design view and deleting the IVAQ1 object from the database and running the report again.

You can enter design mode by holding down the SHIFT key when you double click the icon to open Stone Edge.