logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Lemonde  
#1 Posted : 18 October 2018 10:13:16(UTC)
Lemonde

Rank: Advanced Member

Groups: Registered
Joined: 08/01/2017(UTC)
Posts: 354
United Kingdom
Location: London

In Monsoon StoneEdge (Microsoft Access) we are seeing the following error:

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

Monsoon StoneEdge Reporting Error

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.

Edited by user 18 October 2018 10:21:01(UTC)  | Reason: Not specified

Sponsor
Lemonde  
#2 Posted : 18 October 2019 11:05:05(UTC)
Lemonde

Rank: Advanced Member

Groups: Registered
Joined: 08/01/2017(UTC)
Posts: 354
United Kingdom
Location: London

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.

Edited by moderator 05 November 2019 12:59:27(UTC)  | Reason: Not specified

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.