Data Macro Nightmare!!!

[jerem]

Ok, I have been programming in VBA for quite a while on Excel. I am pretty new to Access. So I decided to take an existing template in Access 2010 (a web template that I converted to a client one), brought the modifications here and there. Added a bit of VBA and, after some learning, modified all the data macro coding to my needs. It took me quite a while but I got the application I wanted. Then I went on to split my database (I can already see experienced users smiling...), and sure enough I hadn't counted on the fact that data macros don't work with linked tables!!!



Now I guess I need to convert all these data macro to VBA... Is that the best and quickest way to resolve the issue? I am looking for some experienced opinions. Thanks a lot!

[June7]

I have converted some regular macros to VBA but have never used data macros so can't say how well that will go. Make a copy of your db and try it.

[jerem]

Ok, after a lot of reading: There is a difference between Standard Macros (SM) which are independent and Data Macro (DM) which are bound to tables. When you split a database into FE and BE, these both work independently. This means that a SM cannot call a DM. DM will still work within the BE environment and so will the SM within the FE environment.
The solution to my issue was to replace all the DM called from SM by database formulas (Dlookup, Dsum, Dcount...) and by Action queries.

[jerem]

It would have been easier to write the whole thing in VBA but as I was modifying an existing database, I didn't want to re-write the whole thing. Plus, now I got to learn DM.

[RuralGuy]

Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?