Stored Procedure text editor

[Joe Stern]

I upgraded from Access 2000 to Access 2002. I miss the color-coded Stored
Procedure text editor - everything looks like notepad now. Is there an
option to get the chromatics back?

Thanks for your help.

- Joe

[Ki Yi [MS]]

Hi Joe,

The SQL Text Editor no longer supports color-coded text. See following
Microsoft kb article for detail information:

ACC2002: No Color-Coded Text in SQL Text Editor [acc10kb]
ID: Q279443
http://support.microsoft.com/default.aspx?scid=kb;en-us;q279443

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.

[Ananda Sim]

Hi Ki Yi, Joe

Yes, I was just gonna say that.

<rant>

Ki Yi, I am hoping that you can be a Change Agent within Microsoft and push
the Product Lead or Product Manager to do something about Access.

I use and earn my keep with Access and SQL Server. So, MS wants to kill off
Jet - but the attempts to migrate experienced and very committed Access
people to the abomination of .ADP are very under funded or under resourced
or un-imaginative.

Already it is a hard job - Jet+Access was an integrated environment. Access
+ SQL Server using ADP is really hard, so hard that one might just go VB +
SQL Server or some other client tool. That is not the culture of Access.

Access was all about integrated solution - VBA + SQL + Queries were all one
piece. The latest efforts by MS to replace this with .ADP is awful - I
believe .ADP uses ADO and not SQLDMO so how can you make the product
"seamless" even.

There has to be a middle layer that shields you from the intricacies of SQL
Server back end and makes you feel that you are programming against a
virtual Jet. We need it now, not in 2005 when app.net framework is realised.

And the product doco? Ugh! We are used to Access Help - one piece. Now
Access Help is neither here nor there - we have to keep remembering to look
up SQL BOL which is not the same culture, friendliness of Access Help
otherwise we don't know what to code.

Please can you get things going?

</rant>

Joe, if you need syntax colouring, you can use some freeware editors e.g.

gVim
Personal Notepad

to help you - they're not the same as Access Designer, but at least you get
colour.

Ananda

"Ki Yi [MS]" <ki...@online.microsoft.com> wrote in message
news:5hvfDNvTCHA.1892@cpmsftngxa08...

[Klaus Oberdalhoff [MVP]]

Hi,

pmji,

i just placed you <rant> uncommented in a private access MVP forum and i got
the following answer from MS:

>>>>>>>>>>>>>

Hi Klaus,
It sounds like this person is ranting about Access 2000. With Access
2002, we added the middle layer that this person suggested. Also, SQLDMO is
available when you install MSDE. Access actually will use SQLDMO for many of
it's admin operations against SQL Server like - Transfer Database.

Bill

<<<<<<<<<<<<<

--
mfg Klaus Oberdalhoff ko...@gmx.de

"Ananda Sim" <anan...@optushome.com.au> schrieb im Newsbeitrag
news:ObBtfrvTCHA.1648@tkmsftngp08...

[Ananda Sim]

Hi Klaus,

Many many thanks for treating my rant as a positive initiative. That's all
I'm trying to do - put out proposals and initiatives.

I've started to play with Wiki - it is as much fun as Newsgroups - see:

http://c2.com/cgi/wiki?WhyCurrentAttemptsToEvolveAccessWithoutJetLackLustre

It may be more effective in consolidating discussions towards a positive
destination than the adversarial nature that NG can develop. Or it may be
worse <grin>

Feel free to make yourself at home - everyone can edit Wiki - there is no
security as such.

"Klaus Oberdalhoff [MVP]" <ko...@gmx.de> wrote in message
news:akoek5$jfr$06$1...@news.t-online.com...

> It sounds like this person is ranting about Access 2000. With Access
> 2002, we added the middle layer that this person suggested. Also, SQLDMO
is
> available when you install MSDE. Access actually will use SQLDMO for many
of
> it's admin operations against SQL Server like - Transfer Database.
>
> Bill

Please thank Bill for me. Two important things highlighted.

SQLDMO IS used by Access (a thread in another NG had proof that it was not).

CDM (Client Data Manager) essentially Microsoft.Access.OLEDB.10.0 data
provider was an acknowledgement that Access 2000 .adp was heavily broken
compared to Jet/mdb. That is good initiative on MS side. However, lots of
other things need even more wrapping - like Server Filters not working with
StoredProcedure recordsources and having to painfully remember what to do.

Ananda