Well I am newbie to VBA(Access).

I am developing a system for tracking employee work hours,they use common network server to share data so initially i used ASP to do so, but later on found that reporting is difficult, so decided to switch to Access 2003 (Is it fine to switch to? what about security as database will be on a commmon server?), further when I tried to go for option "Tools-Db uitilies-make MDE file" it says that "Cannot make MDE from 2000 file format".

So how to make .mde file in Access 2003?

Can I make .exe from Access file? or only .MDE is the solution?

If only .mde then what about security, as if I open .mde with shift key, it will open database which shows all the codes/forms.

Please guide any web-site (other than microsoft, as it is too much loaded)for ms access.

Thanks in advance.

To make the MDE in 2003, your file has to be in 2002-2003 format. Go to Tools | Database Utilities | Convert Database | To 2002-2004 File Format. If you will never be developing under Access 2000, go to Tools | Options... and on the Advanced tab change the "Default File Format".

MDE is your only solution.

The shift key will only keep the startup options from running. You can disable the shift key for the database (current database project). This is done manually in code that you will run yourself. Don't try to put it in your start-up procedure because by the time the start-up runs, you have already missed the opportunity to disable the shift key. See http://support.microsoft.com/default...b;en-us;826765

The easiest way to disable it is to go to the Immediate window in the VBE and enter:

CurrentProject.Properties.Add "AllowBypassKey", False

Save the database and the shift key is disabled the next time the database opens. To renable the key for your testing:

CurrentProject.Properties.Remove "AllowBypassKey"

BTW, to find the KB on this I went to http://search.microsoft.com and typed

Access shift disable

in the search box. The article was the first to show in the list.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org