Error 3219 Invalid Operation

Hi
On my app I am getting the error '3219 Invalid Operation' after splitting the DataBase. I have checked and it is on the statement opening a record set as per the following screen shots:

Screen-Shot-2018-02-27-at-15.59.46.png
Screen-Shot-2018-02-27-at-16.09.56.png
If I directly open the table, then it opens and allows all inputs and edits.

Can anyone help?
João serras-pereiraAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
You cannot use the dbOpenTable option for a linked table, at least not when referring to it using currentdb, change the type to dbOpenDynaset.

Either that, or change your db definition like:

set db = dbengine.opendatabase("BackEndPathAndFilename.accdb")
0
 
João serras-pereiraAuthor Commented:
Ah! Thanks (and I think that this hint is going to solve another issue on my previous app that you also helped... will let you know)
0
 
João serras-pereiraAuthor Commented:
Thanks! works perfectly
0
 
Dale FyeCommented:
you are welcome
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.