Re: How to create an AutoNumber field with a SQL statement?
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Thu, 4 May 2006 18:45:01 +1000
When Jet 4.0 came out, we were told that:
"But to maintain backward compatibility with earlier versions of Microsoft
Jet, the enhancements to SQL are available only when the database engine is
set to operate in ANSI SQL 92 mode. "
As it turns out, either that was only partly true, or else DAO has since
been extended. I was told that I couldn't use the new ALTER TABLE stuff: it
was years later that someone else pointed out that I could.
(david)
"Lyle Fairfield" <lylefairfield@xxxxxxx> wrote in message
news:1142424368.087379.294820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TTBOMR, when MS-Access went from JET 3.5 to JET 4.0, it was also the
time when ADPs and MSDE were at the fore-front of the glitz message
from MS. Either they forgot to tell us about JET 4.0, or many of us,
including me, forgot to look.
The !!!!!new!!!!! (6 years old?) thingmes in JET 4.0 are discussed at
http://support.microsoft.com/kb/q275561/
but not as extensively as one might wish.
JET 4.0 has some great !!!!!new!!!!! capabilities, but as I see it,
they are 99.44% ignored in CDMA and elsewhere.
.
- Prev by Date: Re: Duplicating RecordsetClone
- Next by Date: Re: Duplicating RecordsetClone
- Previous by thread: Re: Outlook "Security" causing a headache
- Next by thread: Beeping every ten seconds
- Index(es):
Relevant Pages
|
