Splitting Database but Macro Error Developes

Question

Hi All, Merry Christmas!! I need HELP!!! I have an Access 2016 Database developed and when I go through the splitting process (For multi users) it says it works just fine. The tables all move to the new "BE" database. When I go into the front end it says that a macro cant be found. Then none of my reports or forms work and throw the same macro error.

My boss is yelling to get it deployed, I need a answer and it will be the best christmas present ever.

Scott

Answer 1

This database first needs to be converted to a Desktop database then split.  The example below is for Access 2010 but should work for Access 2013.

Yes it is possible to convert the 2010 Northwind Web Database into a client version. It will, however, take some manual work on your part.

Follow these steps:

• You first need to create a new empty client ACCDB file.
• Once that is open, you can import all the web tables, client forms, and client reports from the web copy into the client file. The web tables will be converted into client tables but you cannot import web queries, web forms, web reports, and web macros into the client version.
• Close the client copy now and open the web copy
• You can individually change a web object and save out a copy of the object as a client object.
• To do this, highlight a web query for example in the Navigation Pane. Click File tab, then Save & Publish area on the left, then Save Object As in the middle of this pane, and finally click the Save As Client Object button on the right side. You'll be prompted to give a name for the client object. Since it can't be the same name as the original at the moment, just use the same name and append the word Client at the end.
• You'll see a client copy of that web query in the Navigation Pane. To make sure the application still works, you'll need to delete that web query, and rename the client version to match the original name (remove the appended Client word from the name you gave it earlier.)
• You will need to repeat these steps for each and every web query, web form, web report, and web macro in the application. Yes, it will take some time to do that.
• Once complete, you can import all of these remaining client objects into your client only ACCDB file. Your file should now only have client copies of the Northwind web database.

From http://www.access-programmers.co.uk/forums/showthread.php?t=219350

Posted by AccessJunkie

Answer 2

Your screen shots indicate this is a WEB template. It was meant to be used as an Access Web App, not a desktop app.

Converting such an app to a desktop app, is not easy.

Answer 3

I am fairly new to Access, the template that I used already had the Macros in it. Her is one of the Macro details

So can I get rid of the Macros? If so do I need to do anything to repalce them?

Answer 4

Data macros are attached to tables, by linking the tables the data macros are no longer there. 

What does this macro do? If this is a desktop app (as it appears to be if you are splitting it), why use macros at all?