473,587 Members | 2,487 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is Access a RDBMS???

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
Nov 12 '05 #1
4 6255
Arijit Chatterjee wrote:
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...
What? Sure you can create multiple logins or accounts using workgroup
security.

Other than that everything is available.So why not a RDBMS.Please explain me. Regards
Arijit Chatterjee


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=
Nov 12 '05 #2
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" <ar************ *****@yahoo.co. in> wrote in message
news:ea******** *************** ***@posting.goo gle.com...
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

Nov 12 '05 #3
"Terry Kreft" <te*********@mp s.co.uk> wrote in
news:oG******** ************@ka roo.co.uk:
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.


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
Nov 12 '05 #4
Agreed.

--
Terry Kreft
MVP Microsoft Access
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.78...
"Terry Kreft" <te*********@mp s.co.uk> wrote in
news:oG******** ************@ka roo.co.uk:
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.


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

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1899
by: Limey | last post by:
Hi All, I want to write an application that will talk to a RDBMS. The application needs to be platform neutral from both an operating system and database backend point of view. I have decided to create a prototype in Python, the RDBMS will be PostgreSQL running on a Linux box.
8
5134
by: wlcna | last post by:
mysql v4.0.16: I had been using mysql with innodb and thought that was fine, until i used it for something requiring a few - perhaps slightly involved - joins, and have now seen the performance become totally unacceptable. I have a query that takes over 35 seconds using mysql and innodb, for reasons that are completely a mystery to me, in a result set consisting of only a handful of items.
10
2389
by: Mike | last post by:
I recently had a Microsoft Access 97 database corrupt on me. The setup is a split database (front end/back end) setup with about 10-15 users. This is the first corruption in something like a year. The database has about 25 tables, and the total size is about 15MB, after a compact. The front end sits on users Windows 2000 Professional desktops, and the file server is a Windows 2000 Server. I've been thinking of migrating the back end,...
4
5591
by: Sujeet | last post by:
Hey guys, I want to import a database from SQL Server 2000 to MS Access with all indices and keys along with the tables. DTS does not export indices and keys, only the structure and the data. When used "Import External Data" through Access(linking through ODBC) it creadted liked tables, however with indices and keys. Can remove these links and preserve only th stucture back. How do I do it. Thanks
14
2121
by: Roy Gourgi | last post by:
Hi, I need to store and retrieve information from a database. It looks as though there is a lot more support for SQLServer than there is for Access, correct me if I am wrong. What do I have to do to get SQLServer and which version should I be using. Or is SQLServer already part of the VS.Net? Are there any good examples that you know of.
17
2476
by: DaveG | last post by:
Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a thousand items and the accounting side will be used for hopefully many years so the entries are likely to be vast. The delema is what is best to use ase the DB engine, Access I have as part of Office 2002 or should I really be looking at SQL...
43
2879
by: sinister | last post by:
Is MS Access a true RDBMS?
37
5200
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end development tool? Let's get serious. Microsoft continues to publish numerous articles and videos on how you...
1
1646
by: laura | last post by:
I am new to Access, trying to figure it out on my own. I am trying to create a form to input the same information in 3 different tables. The 3 tables each have a different number as the primary key, although they each do contain the other 2 numbers in their tables. I have been unsuccessful and am wondering if perhaps my relationships are inaccurate.
0
7923
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8216
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8349
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8221
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5719
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5395
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3882
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2364
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1455
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.