Finishing my project? "Mommio2" <mommio2[ at ]insightbb.com> 28.07.2006 17:02:15 It's been a learning process, but I am almost done with my first Access 2003 project. Now, I wonder if someone could please give me a brief rundown on what exactly I have to do to get it ready for others to use? I know I have to make an intro screen. I am assuming I make a new form and put buttons on it for finding a record in the table, edit, save, etc. Do I need to make it an MDE file. (I don't know what this is, but I've heard that I need to do it.) What else? None of this was in any of the books I have. Thanks!

Re: Finishing my project? "jahoobob via AccessMonster.com" <u12179[ at ]uwe> 28.07.2006 20:44:06 If this is to be a multiuser db then you will want to split it. This entails putting only the tables in a db (called the backend) and linking those tables to db's for each user (called frontends). You will want the frontends to be MDEs. MS does all the work for you by selecting Tools, Database utilities, Make MDE file with your frontend db open. Store your original frontend mdb file someplace secure (your computer) because if you decide to make changes in the MDEs you have to make them in the MDB and then make a new MDE. Once you make one MDE you can copy it to the various users computers. You amy have to relink the backend tables if the network drives aren't mapped the same way on all the computers but this can be done via Tools, Database Utilities, Linked table manager. As far as the Intro screen, you can "roll your own" menu form, create a Switchboard through Access, or create a Customized toolbar (to use the latter two type switchboard or toolbar in the Access help and select the item that has create for either. You also have Startup options that tell access how to behave when you open that db from Tools, Startup... Hope this helps, Bob Mommio2 wrote: [Quoted Text] >It's been a learning process, but I am almost done with my first Access >2003 project. Now, I wonder if someone could please give me a brief rundown >on what exactly I have to do to get it ready for others to use? > I know I have to make an intro screen. I am assuming I make a new form >and put buttons on it for finding a record in the table, edit, save, etc. > Do I need to make it an MDE file. (I don't know what this is, but I've >heard that I need to do it.) > What else? None of this was in any of the books I have. > >Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200607/1

Re: Finishing my project? "Mommio2" <mommio2[ at ]insightbb.com> 28.07.2006 22:44:25 Thanks, Bob! Let me think on this for a while, and I will probably have more questions when I try it. Appreciate your help! "jahoobob via AccessMonster.com" <u12179[ at ]uwe> wrote in message news:63f00c3348e49[ at ]uwe... [Quoted Text] > If this is to be a multiuser db then you will want to split it. This > entails > putting only the tables in a db (called the backend) and linking those > tables > to db's for each user (called frontends). You will want the frontends to > be > MDEs. MS does all the work for you by selecting Tools, Database > utilities, > Make MDE file with your frontend db open. Store your original frontend > mdb > file someplace secure (your computer) because if you decide to make > changes > in the MDEs you have to make them in the MDB and then make a new MDE. > Once you make one MDE you can copy it to the various users computers. You > amy have to relink the backend tables if the network drives aren't mapped > the > same way on all the computers but this can be done via Tools, Database > Utilities, Linked table manager. > As far as the Intro screen, you can "roll your own" menu form, create a > Switchboard through Access, or create a Customized toolbar (to use the > latter > two type switchboard or toolbar in the Access help and select the item > that > has create for either. > You also have Startup options that tell access how to behave when you open > that db from Tools, Startup... > Hope this helps, > Bob > > Mommio2 wrote: >>It's been a learning process, but I am almost done with my first Access >>2003 project. Now, I wonder if someone could please give me a brief >>rundown >>on what exactly I have to do to get it ready for others to use? >> I know I have to make an intro screen. I am assuming I make a new >> form >>and put buttons on it for finding a record in the table, edit, save, etc. >> Do I need to make it an MDE file. (I don't know what this is, but >> I've >>heard that I need to do it.) >> What else? None of this was in any of the books I have. >> >>Thanks! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200607/1 >