Re: Which SQL?

ADP can connect only with Microsoft SQL-Server and the language used for MS
SQL-Server is known as T-SQL.

SQL-Server 2005 has bring many enhancements to the version used by
SQL-Server 2000; some of these - like advanced schemas - are not really
compatible with ADP.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Jay" <spam@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eub39CJLIHA.5580@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm reasonably proficient in writing my Access queries in SQL (in a .mdb
file), and obviously I'm aware of the 'quirks' in Access SQL syntax.

Now I'm beginning to explore an .adp to the sql server at work I'm aware
that I need to use different sql syntax to that used in an .mdb

I'm keen to read up on the sql syntax used in .adp's so would like to know
if it has any particular name. I'm a little bemused by all the different
types I see references to i.e. T-sql, MySQL, Ansi ??
Which is the one used in ADPs?

Many thanks.....Jason


.

Relevant Pages

  • Re: Everything I Always Did With Access
    ... If you want to work with SQL-Server, the first thing to do would be to learn ... You don't need a book about ADP and T-SQL for this. ... it means that you shouldn't expect any real new features in the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Inputting case-based conditional statement with wildcard into SQL
    ... You should ask this question in a newsgroup about the version of SQL supported by Access, ... This newsgroup is about ADP and SQL-Server and the answer that you will get will be for T-SQL and not for Access. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Future of ADPs
    ... However, many particularities of SQL-Server ... but like ADP, these are fossils from the past. ... investment of future clients. ... Reports to design your reports. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Question on conversion to ADP
    ... the category of 'Stuff that Jet Doesn't Have, ... I don't think that ADP are a half-baked product. ... support and the ADP projects for working with SQL-Server. ... you call this an amelioration and a victory!?!?! ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server View backed Form
    ... client such as ADP or anything else. ... The design of SQL-Server has been based on ... the use of SP for communicating with the exterior and everything else (Views ... Resync commands are particular to ADP and will help diminushing the number ...
    (microsoft.public.access.adp.sqlserver)
Loading