I have a few individuals that have created seperate Access Bases for and now that data is collecting I have another utility I have put together that grabs data from these other databases and puts them together and reports, exports etc. I would like to make it simpler from as cross training standpoint and make a seperate set of menus that open these individual data bases so corrections can be made with out closing one, navigating to the other and so on. It seems that in the past I could create a button to run a macro that would run a command to open a seperate access data base. Whats was it, or is there a better way?
It was a Macro Action, in moving to a newer version of Access, I discovered there was a "Show All Actions" button up top. Why we would hide actions in the new version now baffles me, but there it was, "RunApp" and all I had to do was put in the path. I supose it's ok to answer your own question!
You could giving the appearance of different databases, having a consolidated database in the first place and customising the each user's front end. To the user the database is different when in essence its data source is common to all.