I have a network database, using by many people in the company. I have data macros attached to the table and it was working fine until I split the database. I split the database and I sent all my tables to the back end, linked front end with back end tables. Now from the front end forms through command button, I am trying to run the data macros, it won't recognize. It gives a message that " Data macro does not exist". But when I go to the back end table and see, it is already there.
I have searched in the web and see that data macro wont work with linked tables. I assume that data macros assigned to a table of one database cannot be accessed from other database, even we create a link to that table. But this is the same database, we just split to back end and front end for some purpose.
Can anybody help me please. Am I doing something wrong here or missing to do something?
Thank you very much for assistance.