Jeff I use the same format for my payroll. I only let them go into 1 client at a time. I shut the database when they choose to go into a new client. The new client then gets to have the PATH changed to that folder. Thus you can open & shut the Database to your hearts content as they always find it again via the PATH.
Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program Jeff Johnson wrote: > I have multi-site applications where the database name and table structures > are the same and different sites are stored in different folders. > > > > Application\Site1\files.dbc > > Application\Site2\files.dbc > > Etc. > > > > I have been doing this for a long time, only now I have a new app that is > consolidating data from all sites. VFP only recognizes one dbc name > regardless of how many are open with that name. > > > > I can open .\site1\files.dbc and .\site2\files.dbc. I can "SET DATABASE TO > .\site2\files.dbc" and it will not change from site1. This is related to a > thread I started a couple of weeks ago about backing up a dbc. > > > > Does anyone know of a work around? I guess the only solution at this point > is to modify everything to open up tables by full path rather than > dbc!table. > > > > Jeff > > > > Jeff Johnson > > [EMAIL PROTECTED] > > 623-582-0323 > > Fax 623-869-0675 > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/signed > multipart/alternative > text/plain (text body -- kept) > text/html > application/x-pkcs7-signature > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
