Where is the Osage Inside Access data stored?

Does Osage Inside Access change my application in any way?

My app changes all the time -- how can I refresh the parent list, or the dependency lists?

What things does Osage Inside Access not do?

Where is the Osage Inside Access data stored?

• In 3 tables, inside every MDB that runs the add-in.  
• These tables are:  zIA_OsageInsideAccess, zIA_OsageInsideAccessChildren, and zIA_Prefs.
• No other changes to your applications are made.
• Note: It is possible to move these tables to a data-only MDB, and link to these. Click here for instructions.

Does Osage Inside Access change my application in any way?

• It only adds the 3 tables:    zIA_OsageInsideAccess, zIA_OsageInsideAccessChildren, and zIA_Prefs.
• No other changes to your applications are made.

My app changes all the time -- how can I refresh the parent list, or the dependency lists?

• It is normal that during development forms, tables, etc. are added, changed, and removed.
• To refresh the parent list
  • Click on Populate
  • Under Parent Records, Select the Refresh option (that is the default)
  • Make sure the Find Dependencies for Every Object is deselected, unless you want that of course (can take some time, depending on the number of objects in your application, and the speed of your computer.)
• To completely rebuild the parent list and the child lists.
  • Click on Populate
  • Under Parent Records, Select the Start From Scratch option. (This will delete everything and start all over!)
  • Make sure the Find Dependencies for Every Object is deselected, unless of course you want that (can take some time, depending on the number of objects in your application, and the speed of your computer.)
• To refresh all the dependency lists
  • Click on Populate
  • Under Parent Records, Select the Refresh or the Start From Scratch option, as you prefer. (The Start From Scratch will delete everything)
  • Select the Find Dependencies for Every Object option, under Dependency Records. As you prefer, select Used By options, and/or Uses options.  (Used By can take some time, depending on the number of objects in your application, and the speed of your computer. Typically, Uses is very quick.)

What things does Osage Inside Access not do?

• It does not search inside data access page definitions (only Access 2000 and beyond have DA Pages.)
• It does not automatically sense when you have added or removed or modified the objects in your application.
• At this time, it does not incorporate a replace function.
• The Find Uses dependencies feature does not (yet) handle certain infrequently used SQL situations.
  This will be added in future versions.