Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting up Access 2007 options with a vbscript?

Status
Not open for further replies.

mdProgrammer

Programmer
Oct 2, 2004
71
0
0
US
Is it possible to set up Access 2007 options using a vbscript? There are 14 MS Access database applications, plus about 70 read-only databases (SQL backend) for querying that need to have options set on them that are in Access 2003 (some may be Access 2000 format) that aren't set in 2007. I would need to do things like -

Set the default file format to Access 2002-2003.
Uncheck Layout view, Design changes, etc. (basically, the entire 2007 ribbon).
Enable macros and VBA code.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top