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?
 
kaldrichCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.