By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

is access a relational database?

P: 5
is access a relational database?
Jan 3 '07 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
PEB
Yeas it is!

:)
Jan 3 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 3 '07 #3

P: 5
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?
Jan 3 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.