is access a relational database?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • rameshpi
    New Member
    • Jan 2007
    • 5
    #1

    is access a relational database?

    is access a relational database?
    Tags: None
    • PEB
      Recognized Expert Top Contributor
      • Aug 2006
      • 1418
      #2
      Yeas it is!

      :)

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387
          #3
          Originally posted by rameshpi
          is access a relational database?
          As long as the rules of relational databases are used correctly then yes it is. Unfortunately, a number of applications are designed not following those rules. These applications will work after a fashion if not very well. However, if you apply full relational database rules to Access then it is as powerful as any other database particularly when used with VBA code. The only restriction is one of size. Around 2GB for Access 2000 and above and the size restrictions of for example 255 fields per table or query. These last ones are not necessarily bad restrictions as a properly designed system should never need to break these rules.

          Mary

            Comment

            • rameshpi
              New Member
              • Jan 2007
              • 5
              #4
              Originally posted by mmccarthy
              As long as the rules of relational databases are used correctly then yes it is. Unfortunately, a number of applications are designed not following those rules. These applications will work after a fashion if not very well. However, if you apply full relational database rules to Access then it is as powerful as any other database particularly when used with VBA code. The only restriction is one of size. Around 2GB for Access 2000 and above and the size restrictions of for example 255 fields per table or query. These last ones are not necessarily bad restrictions as a properly designed system should never need to break these rules.

              Mary
              thanks mary...
              here,my problem is..
              iam developing a j2me application.i want to maintain ms access on pocket pc 2003(mobile device).how can i connect ms access on mobile device from midlet programming?

                Comment

                • MMcCarthy
                  Recognized Expert MVP
                  • Aug 2006
                  • 14387
                  #5
                  Originally posted by rameshpi
                  thanks mary...
                  here,my problem is..
                  iam developing a j2me application.i want to maintain ms access on pocket pc 2003(mobile device).how can i connect ms access on mobile device from midlet programming?
                  That I'm not sure about. Normally access is connected to via DSN or odbc driver. You could see if their is an odbc driver available. I know there are a number of java variations.

                  Mary

                    Comment

                    Previous template Next
                    Working...