Is Access a RDBMS???

[Arijit Chatterjee]

I heard that MS Access is not at all a RDBMS.But why?
Only the security feature in Access is low.We can't create multiple logins or...
Other than that everything is available.So why not a RDBMS.Please explain me.
Regards
Arijit Chatterjee

[Deano]

Re: Is Access a RDBMS???

Arijit Chatterjee wrote:[color=blue]
> I heard that MS Access is not at all a RDBMS.But why?
> Only the security feature in Access is low.We can't create multiple
> logins or...[/color]

What? Sure you can create multiple logins or accounts using workgroup
security.

Other than that everything is available.So why not a[color=blue]
> RDBMS.Please explain me. Regards
> Arijit Chatterjee[/color]

This is probably an opinion forged from the fire of debate about what
constitutes a truly relational database. There are many, and not
definitive, views on the characteristics of such a database and I imagine
Access falls foul of some of these requirements. In reality though what
does it matter? As long as your database is well designed and works, it's
not something that should keep you up at night.

If you need more info I imagine a trawl through Google Groups would be
useful, http://www.google.co.uk/grphp?hl=en&tab=wg&q=

[Terry Kreft]

Re: Is Access a RDBMS???

EF Codd defined 12 rules (a version of the rules can be seen at
http://www.itworld.com/nl/db_mgr/05072001/ ) which described a RDBMS. To
date there is no database system which fully meets all 12 rules, so on that
basis Access is not an RDBMS (but then neither is any other database
system).

If you look at the rules and see how they apply to Access you will see that
by any everyday definition of an RDBMS Access fits the model.

Essentially you are misinformed.

--
Terry Kreft
MVP Microsoft Access


"Arijit Chatterjee" <arijitchatterj ee123@yahoo.co. in> wrote in message
news:ea01504d.0 405180323.31711 04e@posting.goo gle.com...[color=blue]
> I heard that MS Access is not at all a RDBMS.But why?
> Only the security feature in Access is low.We can't create multiple[/color]
logins or...[color=blue]
> Other than that everything is available.So why not a RDBMS.Please explain[/color]
me.[color=blue]
> Regards
> Arijit Chatterjee[/color]

[David W. Fenton]

Re: Is Access a RDBMS???

"Terry Kreft" <terry.kreft@mp s.co.uk> wrote in
news:oGmdnX-d75FFlDfdSa8jmw @karoo.co.uk:
[color=blue]
> If you look at the rules and see how they apply to Access you will
> see that by any everyday definition of an RDBMS Access fits the
> model.
>
> Essentially you are misinformed.[/color]

Even if he weren't misinformed, if it gets the job done, why would
it matter if Access were *not* technically an RDBMS?

What matters is not the definition, but suitability to a particular
task.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Terry Kreft]

Re: Is Access a RDBMS???

Agreed.

--
Terry Kreft
MVP Microsoft Access


"David W. Fenton" <dXXXfenton@bwa y.net.invalid> wrote in message
news:Xns94ED804 35C453dfentonbw aynetinvali@24. 168.128.78...[color=blue]
> "Terry Kreft" <terry.kreft@mp s.co.uk> wrote in
> news:oGmdnX-d75FFlDfdSa8jmw @karoo.co.uk:
>[color=green]
> > If you look at the rules and see how they apply to Access you will
> > see that by any everyday definition of an RDBMS Access fits the
> > model.
> >
> > Essentially you are misinformed.[/color]
>
> Even if he weren't misinformed, if it gets the job done, why would
> it matter if Access were *not* technically an RDBMS?
>
> What matters is not the definition, but suitability to a particular
> task.
>
> --
> David W. Fenton http://www.bway.net/~dfenton
> dfenton at bway dot net http://www.bway.net/~dfassoc[/color]