Comparing MSAccess 2003 with MSDE ??? plz
- Thread starter betimd
- Start date
kulrom
Well-known member
try to find some threads on this forum that are explaining exactly what are the differencies btween Access 2003 and MSDE. Above i'll i would recommend Access just because it is avoidning all those confusions while you install and configure MSDE because Access is file based DB and doesn't ask for any kind of setting on target PC. Just copy/paste and you are IN. Also don't forget that with MSACCESS you can you can design your DB visualy while MSDE comes without designer and you are able to create tables/fields and stuff only through code.
Reagrds
Reagrds
kulrom
Well-known member
An Expert about what? expert for comparing MSDE vs. Access? OK wait
waitI'm pretty sure this is going to be taken the wrong way, but what you have asked for is the same as walking onto a car lot and asking for a comparison of a Pick-up vs a Semi.
While both are trucks, they serve different purposes and needs. In the same manner, Access and MSDE server two different purposes and have different capabilities.
So, now, let me ask you, for what purpose do you plan to use a database for? What kind of an application are you writing? What kind of capabilities do you need?
Then and only then can the pro & cons of each DB type be discussed.
-tg
ps: I'd consider Kulrom an expert in this realm - he & I spar over this all the time.
While both are trucks, they serve different purposes and needs. In the same manner, Access and MSDE server two different purposes and have different capabilities.
So, now, let me ask you, for what purpose do you plan to use a database for? What kind of an application are you writing? What kind of capabilities do you need?
Then and only then can the pro & cons of each DB type be discussed.
-tg
ps: I'd consider Kulrom an expert in this realm - he & I spar over this all the time.
kulrom
Well-known member
MSDE vs Access
Hey TG, thanks for the support
Beti@ althrough you were not so kind as for the first time i will answer your question anyway. First off, my appologize cuz i have forgoten to wellcome you ... well, wellcome to the forum i hope you will collect only good experiences from here
Ok let's start !!!
Assuming that you are MSDE fan that is obviously i would say ... be my guest.
IF you really want to compare these totaly different backends i suppose you should consider their advantages and limitations. Well, to be honest i've used both these but i haven't noticed any MSDE advantage over MSAccess even the "claimed" speed. Let's consider the speed for a while. How do you imagine speed of Microsoft Data Engine? Data that come with speed of flash? Nah ... it comes in consideration if there are thousands concurent users that MSDE doesn't support at all (i'd ignore any speed score if it is measured with single user) then how you can claim that MSDE is faster? However, speed mostly depends on application architecture.
The following are Access table limitations:
MS Access database table specifications:
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables open internally by MS Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255
The following are general Access limitations:
MS Access database general specifications
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
And because MSDE cannot be compared with MSAccess but rather with SQL Server i will show you the MSDE limitations in comparison with SQL Server (taken from MSDN):
MSDE Database Limitations:
No Enterprise Manager
No Query Analyzer
No Index Tuning Wizard
Only 2GB RAM
Only 2GB database size limit
Only 2 CPUs
Only five concurrent batch workloads or 25 concurrent connections for websites
No Database Server Failover Support
No Full-text search
No SQL Server Profiler
No Import and Export Wizards
No OLAP
No English Query
No SQL Books Online
No Full or Bulk-Logged recovery model support (only simple)
notice that this list covers most of the MSDE limitations but not all !!!
And finally did you know that if you install MSDE you can use Access to manage it. It's not intuitive but it does work. You can design tables, stored procedures, assign permissions, backup the database, and almost everything else you can do with Enterprise Manager. How about this?
HTH,
Regards
note:
1. even MSAccess is not free it worths each peny $$$
2. If you really want something free then go for mySQL incomparable better than MSDE
Hey TG, thanks for the support
Beti@ althrough you were not so kind as for the first time i will answer your question anyway. First off, my appologize cuz i have forgoten to wellcome you ... well, wellcome to the forum i hope you will collect only good experiences from here
Ok let's start !!!
Assuming that you are MSDE fan that is obviously i would say ... be my guest.
IF you really want to compare these totaly different backends i suppose you should consider their advantages and limitations. Well, to be honest i've used both these but i haven't noticed any MSDE advantage over MSAccess even the "claimed" speed. Let's consider the speed for a while. How do you imagine speed of Microsoft Data Engine? Data that come with speed of flash? Nah ... it comes in consideration if there are thousands concurent users that MSDE doesn't support at all (i'd ignore any speed score if it is measured with single user) then how you can claim that MSDE is faster? However, speed mostly depends on application architecture.
The following are Access table limitations:
MS Access database table specifications:
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables open internally by MS Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255
The following are general Access limitations:
MS Access database general specifications
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
And because MSDE cannot be compared with MSAccess but rather with SQL Server i will show you the MSDE limitations in comparison with SQL Server (taken from MSDN):
MSDE Database Limitations:
No Enterprise Manager
No Query Analyzer
No Index Tuning Wizard
Only 2GB RAM
Only 2GB database size limit
Only 2 CPUs
Only five concurrent batch workloads or 25 concurrent connections for websites
No Database Server Failover Support
No Full-text search
No SQL Server Profiler
No Import and Export Wizards
No OLAP
No English Query
No SQL Books Online
No Full or Bulk-Logged recovery model support (only simple)
notice that this list covers most of the MSDE limitations but not all !!!
And finally did you know that if you install MSDE you can use Access to manage it. It's not intuitive but it does work. You can design tables, stored procedures, assign permissions, backup the database, and almost everything else you can do with Enterprise Manager. How about this?
HTH,
Regards
note:
1. even MSAccess is not free it worths each peny $$$
2. If you really want something free then go for mySQL incomparable better than MSDE
kulrom
Well-known member
Above are 7 posts so, would you mind to tell us which one exactly .. thanks
Regards
Regards
kulrom
Well-known member
oic ... i didn't know that ... thank you for the idea
Similar threads
- Question
