Access - allow find/replace in query SQL view

[Guest]

I do a lot of creating/testing SQL statements in Access that pull data from
MS SQL Server or FoxPro or other data sources, then copy and past that SQL
statement into ASP pages. However, sometimes the syntax is slightly
different. For example, Access talks to my linked SQL tables using "dbo_" as
a prefix, whereas an ASP page using a sqloledb provider uses "dbo.". So when
I copy SQL statements back and forth to Access, I have to use notepad as an
intermediary to do a text find/replace to change dbo. to dbo_ and vice versa.
It would be great if I could to a text find and replace right inside of the
SQL view of the query within Access rather than having to use notepad to do
that text editing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...af0208e782&dg=microsoft.public.access.queries

 

[Michel Walsh]

Hi,


in MS SQL Server, dbo is the user, or the schema (with MS SQL Server 2005),
while in Jet, the prefix dbo_ is the default table NAME. You can change
the table name to remove that prefix (of an ODBC linked table) as example.
As for when dbo. appears, personally, I use the Query Analyzer, so when a
SQL statement works like I wish, I can cut and paste it where I want,
without the dbo-dot. Sure, that is another story for saved query, but I
doubt you can get the two different departments, in Microsoft, to
collaborate together to accomplish what you describe. You are better to put
you hope in finding a "find and replace" tool, that can change (replace) all
the dbo-dot to dbo-underscore, or vice-versa.

It is preferable to post your suggestion on the Microsoft web site, in their
suggestion box... or wait a public beta. While some people from Microsoft
may read your wishes, HERE, it is unlikely they have the political power to
define the development priorities, neither the resources allocations to
their internal projects.



Vanderghast, Access MVP