Access 97 databases

I had been told that if I open Access 97, the whole system or at least most of it are inside some database. Is it true? For example if I write some VB code into it, the whole code is inside some dat开发者_运维技巧abase. I thought before that only the data I fetch from SQL are inside some database.

The "whole system" is inside Access, so if you have forms and such they're mingled in that file along with the data.

Access keeps everything in an .mdb file. When you open up the project you will see your tabs (tables, queries, forms, etc. etc. etc.) Code in Modules is there as are Macros.

It actually keeps a lot more in this file that is generally hidden - basically its meta data for the project. If you go to tools -> options you should see a check box for system objects. Select that and when you look at tables you will see names like this:

MSysACEs MSysModules MSysModules2 MSysObjects MSysQueries MSysRelationships

You play with these tables at your own risk.

The only other thing that is not stored in the main file is security info - if you try to lock down the file. That is in a system.mdw file See here for more http://support.microsoft.com/kb/303941/EN-US. I have only used this or seen it used when we wanted to lock down an 'application'.