Subject Re: USING SECOND DATABASE From Cornelius <jcmsoftware@gmail.com> Date Sat, 22 Nov 2014 01:45:12 -0500 Newsgroups dbase.getting-started Mervyn Bick Wrote: > On Wed, 19 Nov 2014 10:15:28 +0200, CORNELIUS <jcmsoftware@gmail.com>   > wrote: > > > Hi there, > > > > I have a problem switching database on local disc c: > > > > I started of with a local database (stellocal) in the same folder as the   > > program (c:\hpstel\jcmcps) > > > > The database with customer info is in database stelsystem (c:\hpstel\dbf) > > When working the program will open and set database to the above and it   > > works well. > > > > That is until I wanted to add next customer with database  stelsystem2   > > under c:\hpstel\dbf2 > > > >  Is there a way to let the program on one database at a time or do I   > > have to also have to make a different folder and have a second program   > > running there (taking up space) > > > > I am used to dbase 5 where we simple used the set path to command that   > > worked very nice. > > > > If anyone can please help me I will be very grateful for the help. > > All you need to do is firstly set up a folder for each customer with the   > appropriate files and then set up a BDE alias for each folder.  You can   > either use the BDEAdministrator or bdealias.cc in the dUFLP to set up   > these aliases. > > In you program, to change customers, set the database object and all query   > objects active properties false, change the databasename property to the   > alias for the next customer and then set the database active property true   > before you set the query objects' active properties true. > > You only need one copy of your program if you only want to work on data   > for one customer at a time. > > Mervyn. Hi Merlyn Thanks a lot.  It works like a dream. Have a nice weekend. Cornelius.