VBA, Existing Database Path

Existing Database Path

Author	Message
Craig McLaughli #1 / 7	Existing Database Path How do I find out the exisiting database file path. THEN - most of the database path does not change, but I want to determine the bit that does eg: C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not I need to be able to do a function which finds the bit that changes and store it. So I am thinking of first a expression that looks up the whole file path, which I think is on Dev Ash's site. But how do I find from that full path the bit that changes? Any help is appreciated Craig
Tue, 02 Mar 2004 18:38:08 GMT

michk #2 / 7	Existing Database Path Where on earth do you plan to store the old path? So that you have the two paths to compare? What is the point of the exercise, exactly? -- MichKa Michael Kaplan (principal developer of the MSLU) Trigeminal Software, Inc. -- http://www.trigeminal.com/ the book -- http://www.i18nWithVB.com/ Quote: > How do I find out the exisiting database file path. > THEN - most of the database path does not change, but I want to determine > the bit that does eg: > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > I need to be able to do a function which finds the bit that changes and > store it. So I am thinking of first a expression that looks up the whole > file path, which I think is on Dev Ash's site. But how do I find from that > full path the bit that changes? > Any help is appreciated > Craig
Tue, 02 Mar 2004 19:20:36 GMT

Craig McLaughli #3 / 7	Existing Database Path The database will be copied to different machines and stored in a folder which will be made up of firstly the standard system name, then the name of the company, followed by the rest of the structure. EG: C:\System\ClientCompany\D_data\ The need is that the system needs determine the Client Company name in the directory, in order to enclose that in another module. At the moment I require to manually alter all the references when we transfer the software to another system, I want to establish a module which will look up the path where the database is stored and then to strip out from that the Client Company name which will be used for various purposes. I trust this is a little more clearer? Craig Quote: > Where on earth do you plan to store the old path? So that you have the two > paths to compare? > What is the point of the exercise, exactly? > -- > MichKa > Michael Kaplan > (principal developer of the MSLU) > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > the book -- http://www.i18nWithVB.com/ Quote: > > How do I find out the exisiting database file path. > > THEN - most of the database path does not change, but I want to determine > > the bit that does eg: > > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > > I need to be able to do a function which finds the bit that changes and > > store it. So I am thinking of first a expression that looks up the whole > > file path, which I think is on Dev Ash's site. But how do I find from > that > > full path the bit that changes? > > Any help is appreciated > > Craig
Wed, 03 Mar 2004 00:10:17 GMT

michk #4 / 7	Existing Database Path Well, CurrentDb.Name gives you the name of the database, with the full path. From there some basic use of InStr(), Mid$, and Left$ would allow you to parse the string. The one thing that I do not understand is what you are comparing the big path to (to try to find the "different" part). -- MichKa Michael Kaplan (principal developer of the MSLU) Trigeminal Software, Inc. -- http://www.trigeminal.com/ the book -- http://www.i18nWithVB.com/ Quote: > The database will be copied to different machines and stored in a folder > which will be made up of firstly the standard system name, then the name of > the company, followed by the rest of the structure. > EG: > C:\System\ClientCompany\D_data\ > The need is that the system needs determine the Client Company name in the > directory, in order to enclose that in another module. At the moment I > require to manually alter all the references when we transfer the software > to another system, I want to establish a module which will look up the path > where the database is stored and then to strip out from that the Client > Company name which will be used for various purposes. > I trust this is a little more clearer? > Craig in > > Where on earth do you plan to store the old path? So that you have the two > > paths to compare? > > What is the point of the exercise, exactly? > > -- > > MichKa > > Michael Kaplan > > (principal developer of the MSLU) > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > the book -- http://www.i18nWithVB.com/ > > > How do I find out the exisiting database file path. > > > THEN - most of the database path does not change, but I want to > determine > > > the bit that does eg: > > > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > > > I need to be able to do a function which finds the bit that changes and > > > store it. So I am thinking of first a expression that looks up the > whole > > > file path, which I think is on Dev Ash's site. But how do I find from > > that > > > full path the bit that changes? > > > Any help is appreciated > > > Craig
Wed, 03 Mar 2004 00:18:34 GMT

Craig McLaughli #5 / 7	Existing Database Path There are two reasons, firstly protection but secondly the following The database has 5 parts to it. The first part requires all the table and customising data. The other parts has links embedded in code to various locations. Each install the software has the directory format C:\System\ClientCompany\D_data\ --- Where the client name becomes the different factor. I need to create a module which I can include in the other parts of the database which will: Find the current location of the database Find from that string the Client Company name part of the path Then apply that as a string within that part of the database, for various purposes. I can understand that to a professional developer such as yourself this is a long way for a short cut, but trust me I have a plan!!! Thanks for your help to date Craig Quote: > Well, CurrentDb.Name gives you the name of the database, with the full path. > From there some basic use of InStr(), Mid$, and Left$ would allow you to > parse the string. The one thing that I do not understand is what you are > comparing the big path to (to try to find the "different" part). > -- > MichKa > Michael Kaplan > (principal developer of the MSLU) > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > the book -- http://www.i18nWithVB.com/ > > The database will be copied to different machines and stored in a folder > > which will be made up of firstly the standard system name, then the name > of > > the company, followed by the rest of the structure. > > EG: > > C:\System\ClientCompany\D_data\ > > The need is that the system needs determine the Client Company name in the > > directory, in order to enclose that in another module. At the moment I > > require to manually alter all the references when we transfer the software > > to another system, I want to establish a module which will look up the > path > > where the database is stored and then to strip out from that the Client > > Company name which will be used for various purposes. > > I trust this is a little more clearer? > > Craig wrote > in > > > Where on earth do you plan to store the old path? So that you have the > two > > > paths to compare? > > > What is the point of the exercise, exactly? > > > -- > > > MichKa > > > Michael Kaplan > > > (principal developer of the MSLU) > > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > > the book -- http://www.i18nWithVB.com/ > > > > How do I find out the exisiting database file path. > > > > THEN - most of the database path does not change, but I want to > > determine > > > > the bit that does eg: > > > > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > > > > I need to be able to do a function which finds the bit that changes > and > > > > store it. So I am thinking of first a expression that looks up the > > whole > > > > file path, which I think is on Dev Ash's site. But how do I find from > > > that > > > > full path the bit that changes? > > > > Any help is appreciated > > > > Craig
Wed, 03 Mar 2004 00:32:55 GMT

Bruce M. Thompso #6 / 7	Existing Database Path Ishmael had a plan, too <g> -- Bruce M. Thompson Quote: > There are two reasons, firstly protection but secondly the following > The database has 5 parts to it. The first part requires all the table and > customising data. The other parts has links embedded in code to various > locations. > Each install the software has the directory format > C:\System\ClientCompany\D_data\ --- Where the client name becomes the > different factor. > I need to create a module which I can include in the other parts of the > database which will: > Find the current location of the database > Find from that string the Client Company name part of the path > Then apply that as a string within that part of the database, for various > purposes. > I can understand that to a professional developer such as yourself this is a > long way for a short cut, but trust me I have a plan!!! > Thanks for your help to date > Craig > > Well, CurrentDb.Name gives you the name of the database, with the full > path. > > From there some basic use of InStr(), Mid$, and Left$ would allow you to > > parse the string. The one thing that I do not understand is what you are > > comparing the big path to (to try to find the "different" part). > > -- > > MichKa > > Michael Kaplan > > (principal developer of the MSLU) > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > the book -- http://www.i18nWithVB.com/ > > > The database will be copied to different machines and stored in a folder > > > which will be made up of firstly the standard system name, then the name > > of > > > the company, followed by the rest of the structure. > > > EG: > > > C:\System\ClientCompany\D_data\ > > > The need is that the system needs determine the Client Company name in > the > > > directory, in order to enclose that in another module. At the moment I > > > require to manually alter all the references when we transfer the > software > > > to another system, I want to establish a module which will look up the > > path > > > where the database is stored and then to strip out from that the Client > > > Company name which will be used for various purposes. > > > I trust this is a little more clearer? > > > Craig > wrote > > in > > > > Where on earth do you plan to store the old path? So that you have the > > two > > > > paths to compare? > > > > What is the point of the exercise, exactly? > > > > -- > > > > MichKa > > > > Michael Kaplan > > > > (principal developer of the MSLU) > > > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > > > the book -- http://www.i18nWithVB.com/ > > > > > How do I find out the exisiting database file path. > > > > > THEN - most of the database path does not change, but I want to > > > determine > > > > > the bit that does eg: > > > > > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > > > > > I need to be able to do a function which finds the bit that changes > > and > > > > > store it. So I am thinking of first a expression that looks up the > > > whole > > > > > file path, which I think is on Dev Ash's site. But how do I find > from > > > > that > > > > > full path the bit that changes? > > > > > Any help is appreciated > > > > > Craig
Wed, 03 Mar 2004 02:36:04 GMT

Bruce M. Thompso #7 / 7	Existing Database Path Whoops! That's "Ahab" /:-( -- Bruce M. Thompson Quote: > Ishmael had a plan, too <g> > -- > Bruce M. Thompson > > There are two reasons, firstly protection but secondly the following > > The database has 5 parts to it. The first part requires all the table and > > customising data. The other parts has links embedded in code to various > > locations. > > Each install the software has the directory format > > C:\System\ClientCompany\D_data\ --- Where the client name becomes the > > different factor. > > I need to create a module which I can include in the other parts of the > > database which will: > > Find the current location of the database > > Find from that string the Client Company name part of the path > > Then apply that as a string within that part of the database, for various > > purposes. > > I can understand that to a professional developer such as yourself this is a > > long way for a short cut, but trust me I have a plan!!! > > Thanks for your help to date > > Craig > > > Well, CurrentDb.Name gives you the name of the database, with the full > > path. > > > From there some basic use of InStr(), Mid$, and Left$ would allow you to > > > parse the string. The one thing that I do not understand is what you are > > > comparing the big path to (to try to find the "different" part). > > > -- > > > MichKa > > > Michael Kaplan > > > (principal developer of the MSLU) > > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > > the book -- http://www.i18nWithVB.com/ > > > > The database will be copied to different machines and stored in a folder > > > > which will be made up of firstly the standard system name, then the name > > > of > > > > the company, followed by the rest of the structure. > > > > EG: > > > > C:\System\ClientCompany\D_data\ > > > > The need is that the system needs determine the Client Company name in > > the > > > > directory, in order to enclose that in another module. At the moment I > > > > require to manually alter all the references when we transfer the > > software > > > > to another system, I want to establish a module which will look up the > > > path > > > > where the database is stored and then to strip out from that the Client > > > > Company name which will be used for various purposes. > > > > I trust this is a little more clearer? > > > > Craig > > wrote > > > in > > > > > Where on earth do you plan to store the old path? So that you have the > > > two > > > > > paths to compare? > > > > > What is the point of the exercise, exactly? > > > > > -- > > > > > MichKa > > > > > Michael Kaplan > > > > > (principal developer of the MSLU) > > > > > Trigeminal Software, Inc. -- http://www.trigeminal.com/ > > > > > the book -- http://www.i18nWithVB.com/ > > > > > > How do I find out the exisiting database file path. > > > > > > THEN - most of the database path does not change, but I want to > > > > determine > > > > > > the bit that does eg: > > > > > > C:\Main\Sub\THEN_THIS_BIT_CHANGES\and_this_bit_does_not > > > > > > I need to be able to do a function which finds the bit that changes > > > and > > > > > > store it. So I am thinking of first a expression that looks up the > > > > whole > > > > > > file path, which I think is on Dev Ash's site. But how do I find > > from > > > > > that > > > > > > full path the bit that changes? > > > > > > Any help is appreciated > > > > > > Craig
Wed, 03 Mar 2004 02:52:14 GMT

Page 1 of 1

[ 7 post ]