Where used query
in [General]
|
From: Todd Heiks on 11 Feb 2010 12:47 Is there a utility that I can use to see if a table or query is used in an Access database? Is there a way to open a module as a searchable string? Thanks.
From: Daryl S on 11 Feb 2010 14:04 Todd - You can open any existing module, or clik on the New tool in the Modules Window to open the VBA editor. From there, Ctrl F or the binocular tool to bring up the Find dialog box. In here, select 'Current Project' to search all code in the database for the table or query name you enterin the 'Find What:' box. As for looking for a table or query in queries, I wrote this query a while back to do that - you enter the table or query name at the prompt, and it will list the queries that use that table/query. PARAMETERS QueryTableName Text ( 255 ); SELECT MSysObjects.Name FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId = MSysObjects.Id WHERE (((MSysQueries.Name1)=[QueryTableName])) OR (((MSysQueries.Name2)=[QueryTableName])) OR (((MSysQueries.Expression) Like "*" & [QueryTableName] & "*")) GROUP BY MSysObjects.Name; -- Daryl S "Todd Heiks" wrote: > Is there a utility that I can use to see if a table or query is used in an > Access database? > > Is there a way to open a module as a searchable string? > > Thanks. > > > . >
From: Larry Linson on 11 Feb 2010 18:40 "Todd Heiks" wrote > Is there a utility that I can use to see if a table > or query is used in an Access database? Two third-party utilities (not freeware) for this purpose are Rick Fisher's Find and Replace (http://www.rickworld.com) and Speed Ferret (http://www.moshannon.com). The last time I looked at Speed Ferret, it did not work directly with Access versions later than 2002, but that was some time ago. In the past, I have used both of these programs with satisfactory results. Either of them will find a given string used anywhere in the database. > Is there a way to open a module as a searchable string? You can access the lines in a module, or you can use the unsupported (but not-at-all-secret SaveAsText option, for which a search of newsgroup archives or Google or Bing should return many references). Both of these allow you to search one line/record at a time, but neither, as far as I know, will open the whole module as one "searchable string". Larry Linson Microsoft Office Access MVP
From: Todd Heiks on 12 Feb 2010 08:19 "Larry Linson" <bouncer(a)localhost.not> wrote in message news:e6lmaO3qKHA.4220(a)TK2MSFTNGP05.phx.gbl... > "Todd Heiks" wrote > > > Is there a utility that I can use to see if a table > > or query is used in an Access database? > > Two third-party utilities (not freeware) for this purpose are Rick > Fisher's Find and Replace (http://www.rickworld.com) and Speed Ferret > (http://www.moshannon.com). The last time I looked at Speed Ferret, it > did not work directly with Access versions later than 2002, but that was > some time ago. In the past, I have used both of these programs with > satisfactory results. Either of them will find a given string used > anywhere in the database. > > > Is there a way to open a module as a searchable string? > > You can access the lines in a module, or you can use the unsupported (but > not-at-all-secret SaveAsText option, for which a search of newsgroup > archives or Google or Bing should return many references). Both of these > allow you to search one line/record at a time, but neither, as far as I > know, will open the whole module as one "searchable string". > > Larry Linson > Microsoft Office Access MVP > > Thanks, Todd
From: Todd Heiks on 12 Feb 2010 08:20 Thanks, "Daryl S" <DarylS(a)discussions.microsoft.com> wrote in message news:0B59EBC9-3917-4B8F-BD2D-4736B25B2EAE(a)microsoft.com... > Todd - > > You can open any existing module, or clik on the New tool in the Modules > Window to open the VBA editor. From there, Ctrl F or the binocular tool > to > bring up the Find dialog box. In here, select 'Current Project' to search > all code in the database for the table or query name you enterin the 'Find > What:' box. > > As for looking for a table or query in queries, I wrote this query a while > back to do that - you enter the table or query name at the prompt, and it > will list the queries that use that table/query. > > PARAMETERS QueryTableName Text ( 255 ); > SELECT MSysObjects.Name > FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId = > MSysObjects.Id > WHERE (((MSysQueries.Name1)=[QueryTableName])) OR > (((MSysQueries.Name2)=[QueryTableName])) OR (((MSysQueries.Expression) > Like > "*" & [QueryTableName] & "*")) > GROUP BY MSysObjects.Name; > > -- > Daryl S > > > "Todd Heiks" wrote: > >> Is there a utility that I can use to see if a table or query is used in >> an >> Access database? >> >> Is there a way to open a module as a searchable string? >> >> Thanks. >> >> >> . >>
|
Pages: 1 Prev: Adding background color to an existing field in a table Next: fdfs |