Are all objects being used? "CEV" <chadv[ at ]advancebkg.com> 26.09.2006 20:02:15 I am fairly new to Access Databases. I have created a few for work here. As I have been working on them I would experiment with a query for example. If that qry was working but did not give me exactly what I was looking for I would try a different qry and keep the previous one because I thought that data would be useful later. Well now the deal is I have a query that I am not sure if it is being used for any reports. Instead of going through all the objects I am wondering if there is an easy way to find out if this qry is linked to any other objects. And thinking of this it would be nice to have something that showed how all the objects in a database are linked to eachother. Is there a way for this? Thanks, Chad

Re: Are all objects being used? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 26.09.2006 21:08:31 Easiest way is to get a 3rd party tool like Total Access Analyzer http://www.fmsinc.com/products/analyzer/index.html Other options include Find & Replace: http://www.rickworld.com/products.html Speed Ferret: http://www.moshannon.com/speedferret.html Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/ -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "CEV" <chadv[ at ]advancebkg.com> wrote in message news:enuztaa4GHA.1200[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] >I am fairly new to Access Databases. I have created a few for work here. As >I have been working on them I would experiment with a query for example. If >that qry was working but did not give me exactly what I was looking for I >would try a different qry and keep the previous one because I thought that >data would be useful later. Well now the deal is I have a query that I am >not sure if it is being used for any reports. Instead of going through all >the objects I am wondering if there is an easy way to find out if this qry >is linked to any other objects. And thinking of this it would be nice to >have something that showed how all the objects in a database are linked to >eachother. Is there a way for this? > > Thanks, > > Chad >

Re: Are all objects being used? John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 26.09.2006 21:20:48 On Tue, 26 Sep 2006 15:02:15 -0500, "CEV" <chadv[ at ]advancebkg.com> wrote: [Quoted Text] >I am fairly new to Access Databases. I have created a few for work here. As >I have been working on them I would experiment with a query for example. If >that qry was working but did not give me exactly what I was looking for I >would try a different qry and keep the previous one because I thought that >data would be useful later. Well now the deal is I have a query that I am >not sure if it is being used for any reports. Instead of going through all >the objects I am wondering if there is an easy way to find out if this qry >is linked to any other objects. And thinking of this it would be nice to >have something that showed how all the objects in a database are linked to >eachother. Is there a way for this? > >Thanks, > >Chad > THere are some good third-party tools to do so: Free: http://www3.bc.sympatico.ca/starthere/findandreplace Find and Replace: http://www.rickworld.com Speed Ferret: http://www.moshannon.com Total Access Analyzer: http://www.fmsinc.com John W. Vinson[MVP]

Re: Are all objects being used? "CEV" <chadv[ at ]advancebkg.com> 26.09.2006 22:12:30 WOW!!! The Total Access Analyzer looks just like what I'm looking for. I doubt though that our small non-profit organization would allow the $300 for it though. Anyone know if they have a discounted price for non-profits? Thanks, Chad "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:Oqt2t$a4GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Easiest way is to get a 3rd party tool like Total Access Analyzer > http://www.fmsinc.com/products/analyzer/index.html > > Other options include > Find & Replace: http://www.rickworld.com/products.html > Speed Ferret: http://www.moshannon.com/speedferret.html > Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/ > > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "CEV" <chadv[ at ]advancebkg.com> wrote in message > news:enuztaa4GHA.1200[ at ]TK2MSFTNGP02.phx.gbl... >>I am fairly new to Access Databases. I have created a few for work here. >>As I have been working on them I would experiment with a query for >>example. If that qry was working but did not give me exactly what I was >>looking for I would try a different qry and keep the previous one because >>I thought that data would be useful later. Well now the deal is I have a >>query that I am not sure if it is being used for any reports. Instead of >>going through all the objects I am wondering if there is an easy way to >>find out if this qry is linked to any other objects. And thinking of this >>it would be nice to have something that showed how all the objects in a >>database are linked to eachother. Is there a way for this? >> >> Thanks, >> >> Chad >> > >

Re: Are all objects being used? "Larry Daugherty" <Larry.NoSpam.Daugherty[ at ]verizon.net> 26.09.2006 23:05:33 Keep looking. Find and Replace is shareware. HTH -- -Larry- -- "CEV" <chadv[ at ]advancebkg.com> wrote in message news:ucQ9fjb4GHA.3364[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > WOW!!! The Total Access Analyzer looks just like what I'm looking for. I > doubt though that our small non-profit organization would allow the $300 for > it though. Anyone know if they have a discounted price for non-profits? > > Thanks, > > Chad > > > > "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message > news:Oqt2t$a4GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... > > Easiest way is to get a 3rd party tool like Total Access Analyzer > > http://www.fmsinc.com/products/analyzer/index.html > > > > Other options include > > Find & Replace: http://www.rickworld.com/products.html > > Speed Ferret: http://www.moshannon.com/speedferret.html > > Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/ > > > > > > -- > > Doug Steele, Microsoft Access MVP > > http://I.Am/DougSteele > > (no private e-mails, please) > > > > > > "CEV" <chadv[ at ]advancebkg.com> wrote in message > > news:enuztaa4GHA.1200[ at ]TK2MSFTNGP02.phx.gbl... > >>I am fairly new to Access Databases. I have created a few for work here. > >>As I have been working on them I would experiment with a query for > >>example. If that qry was working but did not give me exactly what I was > >>looking for I would try a different qry and keep the previous one because > >>I thought that data would be useful later. Well now the deal is I have a > >>query that I am not sure if it is being used for any reports. Instead of > >>going through all the objects I am wondering if there is an easy way to > >>find out if this qry is linked to any other objects. And thinking of this > >>it would be nice to have something that showed how all the objects in a > >>database are linked to eachother. Is there a way for this? > >> > >> Thanks, > >> > >> Chad > >> > > > > > >

Re: Are all objects being used? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 27.09.2006 11:03:55 Just remember that shareware doesn't mean freeware. If you do use Find & Replace, you really should pay Rick the $37 for which he's asking. On the other hand, http://www3.bc.sympatico.ca/starthere/findandreplace/ is completely free (afraid I've never used it, though, so I can't comment on it) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Larry Daugherty" <Larry.NoSpam.Daugherty[ at ]verizon.net> wrote in message news:O2Sng5b4GHA.1544[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Keep looking. Find and Replace is shareware. > > HTH > -- > -Larry- > -- > > "CEV" <chadv[ at ]advancebkg.com> wrote in message > news:ucQ9fjb4GHA.3364[ at ]TK2MSFTNGP02.phx.gbl... >> WOW!!! The Total Access Analyzer looks just like what I'm looking > for. I >> doubt though that our small non-profit organization would allow the > $300 for >> it though. Anyone know if they have a discounted price for > non-profits? >> >> Thanks, >> >> Chad >> >> >> >> "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in > message >> news:Oqt2t$a4GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... >> > Easiest way is to get a 3rd party tool like Total Access Analyzer >> > http://www.fmsinc.com/products/analyzer/index.html >> > >> > Other options include >> > Find & Replace: http://www.rickworld.com/products.html >> > Speed Ferret: http://www.moshannon.com/speedferret.html >> > Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/ >> > >> > >> > -- >> > Doug Steele, Microsoft Access MVP >> > http://I.Am/DougSteele >> > (no private e-mails, please) >> > >> > >> > "CEV" <chadv[ at ]advancebkg.com> wrote in message >> > news:enuztaa4GHA.1200[ at ]TK2MSFTNGP02.phx.gbl... >> >>I am fairly new to Access Databases. I have created a few for work > here. >> >>As I have been working on them I would experiment with a query for >> >>example. If that qry was working but did not give me exactly what > I was >> >>looking for I would try a different qry and keep the previous one > because >> >>I thought that data would be useful later. Well now the deal is I > have a >> >>query that I am not sure if it is being used for any reports. > Instead of >> >>going through all the objects I am wondering if there is an easy > way to >> >>find out if this qry is linked to any other objects. And thinking > of this >> >>it would be nice to have something that showed how all the objects > in a >> >>database are linked to eachother. Is there a way for this? >> >> >> >> Thanks, >> >> >> >> Chad >> >> >> > >> > >> >> > >