H
Howard Huntley
Is MS Access 2007 a relational database??
T
tina
no.
A
Allen Browne
Are you are Troll? Student? Theorist? Oracle fan?
If this is a serious question, you might read something like this:
http://www.regdeveloper.co.uk/2006/12/22/access_not_relational_myth/
If this is a serious question, you might read something like this:
http://www.regdeveloper.co.uk/2006/12/22/access_not_relational_myth/
G
Guest
Access is a Relational DataBase Management System (RDBMS) program. You can
use it to create relational databases. Or you can misuse it to create
glorified spreadsheets or a flat file database.
use it to create relational databases. Or you can misuse it to create
glorified spreadsheets or a flat file database.
A
Albert D. Kallal
Howard Huntley said:
You have a bunch of interesting responses here.
Based on the strictest interpretation of relational rules, Oracle, MySql,
Sybase, Sql-server, and ms-access ARE NOT relational databases.
If you loosen up the definition a bit, then ALL of the above databases are
relational.
If you asking does ms-access/jet work with relational data, and maintain
relationships..then the answer is yes..it is relational.
by most "industry" definitions, ms-access would be considered relational.
However, by the strictest interpretation of codd's rules, none of the major
vendors of systems are relational.
J
James A. Fortune
Howard said:
If anyone is trying to use the the degree of relationality
to bashAccess, tell them Access is just about as relational as most of the
others. If they're Access fans, tell them that being relational isn't
all that people make it out to be. The relational model is quite old
and not very good at modeling reality IMO. However, many problems can
be shoehorned into the simplified reality of the relational model. Such
problems save the customer money because that simplification is possible.
James A. Fortune
(e-mail address removed)
D
David W. Fenton
What definition of "relational" are you using to arrive at that
answer?
And does any other so-called RDBMS meet your definition?
(hint: I think have have an answer to the second question without
knowing the answer to the first)
D
David W. Fenton
Great article, but it does get one thing wrong: it claims
transactions were introduced in Jet 4, and they've existed since at
least Jet 2.x.
A
Allen Browne
Yes, I notcied that error also, David.
My favourite part was:
... it's a database argument and, by definition,
no-one ever updates their views.
My favourite part was:
... it's a database argument and, by definition,
no-one ever updates their views.
T
Tony Toews [MVP]
Allen Browne said:
Thanks for posting that URL. I meant to save that last time that
article was mentioned.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
T
Tony Toews [MVP]
Allen Browne said:
Nah, Sharepoint. <smile>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
T
tina
Access isn't a database at all. Access is a software tool that you can use
to *build* a relational database.
hth
to *build* a relational database.
hth
D
David W. Fenton
Well, it's both a database and an application-building tool.
Technically, Access is not the database (Jet is), but the usage is
so widespread as to be impossible to fight against.
In any event, do you *really* think that the original questioner was
asking about Access and not about the db engine of Access (i.e.,
Jet)? I can't see how anyone would think that, so I think an
unqualified answer of "no" is remarkably unhelpful.
J
John W. Vinson
LOL!!!!
John W. Vinson [MVP]