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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

simple question

Status
Not open for further replies.

Onslaughtdave

Programmer
Jan 24, 2005
59
CA
Hi,

If i can recall my earylier semesters, we made an access database run like a windows app. I have two questions regarding this.

1- how do I get access to do that again :D cant recall how...

2- once that is done, will the created file still communicate with access. ie - if i make a new table or something will it show up in the created file. or if i make a query etc...

thanks

dave
 
You should make a backup of your database.

Then in your database go to Tools - Startup and uncheck the Display Database Window checkbox, Allow Full Menus etc.
Basically uncheck what you don't want. The more you scale back the more it looks like a Windows app.

If you need to add tables, make modifications, etc hold down Shift - Enter when opening the database and it should display in Design mode allowing you to make all the modifications you need.

Also, depending on what menus you leave in the Startup you can click F11 to display the database window.

Furthermore, you might look at splitting the database; have a front end (for forms) and a back end (for data). Create an mde for the front end portion.

I could go on, but this should get you started.

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top