Access 2000 startup menu

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

AMD2800

Thread Starter
Joined
May 3, 2005
Messages
165
HI everyone,

I have a question about this project I am working on.. I want to put 10 application in one database. So I can have one Menu with 10 buttons and when click on one an specific application will open. Right now all this application are on a different databases.. We do have split the databases to back and front ends.
I tried to leave the application like that and just have a menu application so when they click a button I direct them to the database but then another access will open and ask for password so everytime they click a button it will open access and asked for a passwords kind of annoying. That's why I wanted to just move all the forms, queries, reports, etc to one database.
It that would be okay or there is a simple way to do this. I would appreciate any suggestion you may have.

Thanks
AMD2800 :D
 

OBP

Joined
Mar 8, 2005
Messages
19,896
AMD, there are a couple of ways to tackle this, you could bring all of the Objects (tables, queries, forms and reports) in to one database by simply "Importing" them, however you would have to reset the various "Relastionships" between the tables.
You could bring all of the Queries, Forms and Reports in to on database (front end) and leave the tables where they are and "Link" to them in the new database.
If the database are connected in any way, say by using common Parts, or Customers or Suppliers then in the long term it would be better to Import everything in to one database and then "Rebuild it" taking advantage of those "commonalities" to reduce the number of tables, queries, forms and reports.
 

AMD2800

Thread Starter
Joined
May 3, 2005
Messages
165
Thanks OBP for some reason I may head start hurting right now.
I really appracite the responce and I better get to work.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top