Recordsetclone ? Underlying table ?

Hi experts,

In a macro in access 2.0 which does some simple
runsql statements, which contain only a few simple delete and update sql's i have an error. This macro run's at night and then i have the error, when i rerun it in the daytime i have no error.

the error : 'Can't open form whose underlying query contains a user-defined function that attempts to set or get the forms recordsetclone property.'

I am not opening a form. I don't have a clue.
In the macro i don't use the recordsetclone property.

Jan

jan_l_keersmaekersAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
kaldrichConnect With a Mentor Commented:
Your macro is too simple to be causing this problem.  Let's try this: build your query in Query Builder.  Instead of using a RunSQL, try OpenQuery to run your built query.  Hope this helps.

Kevin
0
 
Victor SpiridonovCommented:
Post here  your macro code that produces an error.
0
 
jan_l_keersmaekersAuthor Commented:
it contains statemens as

RUNSQL
Delete * from TITB006

this mdb contains no forms

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Victor SpiridonovCommented:
What statement is producing error? Post it here. Where do you see this error?
0
 
kaldrichCommented:
Are you running a connection to a database other than Access (via ODBC?)
0
 
jan_l_keersmaekersAuthor Commented:
no

0
All Courses

From novice to tech pro — start learning today.