Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
d0153030
Starting Member
8 Posts |
 Posted - 2004-10-25 : 04:18:31
|
| Hello This is what a comment i had viewed in one of the mail group. I did not know the solid background why this comment has been made. But how much do you agree!!!Leave Your Marke Wherever You Go |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-25 : 04:23:41
|
well it all depends on what you want to do...sql server is great and all. but if you're doing an app that doesn't require all it can offer, then access is the way to go (or MSDE as it's free). access has made reporting preety easy...it can do great stuff so i don't think that comment holds water...it just depends on what you need and want to achive... it's all about proper tools to use  Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-25 : 08:09:20
|
| Hmmm ... from the use I've made of Access my experience is different. We converted all our Access apps to use MSDE as the data container, and that did away with all the rebuilds and corrupt databases that we had to deal with before. But maybe new/current versions of Access have multi-user contention and power-cuts cracked.Kristen |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-10-25 : 08:31:12
|
| I constantly use Access as my front end to SQL. And if you’re talking a small environment like a small family business you can’t beat it for value.JimUsers <> Logic |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-25 : 08:40:38
|
| There is a lot that Access can do, reporting and interface building are its greatest strengths. But what it cannot do well is handle lots of concurrent users and store more than 1 GB of data. I've seen quite a few people grumbling about why their 500-750 MB Access DB's are slow, lock up and must be repaired constantly, lost data, and how it can't prevent people from doing what they're not supposed to do. These are things that Access is weak on and MSDE/SQL Server can do much better. As long as the limitations are kept in mind and not stretched to the limit, Access is a great tool. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-25 : 09:02:32
|
| If you were making a brand new application in Access wouldn't you start out with the data in MSDE? I know that I would ...Kristen |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-10-25 : 09:06:49
|
| Access has great forms, reports, and VBA support.The single key concept to understand is: There is no server. Users of Access all run their own instance of the MSAccess.exe and <SomeDataBase>.mdb files on their local PC, and if you are accessing a "multi-user" database, it is because the MDB is a shared file on a file server. Which means multiple PC's are opening, reading, locking, etc the same file on the file server at the same time. As opposed to sending requests to a server application (like SQL Server), which is the ONLY process that touches the database file. In that model, that single application can queue requests, prioritize, handle securty, and return results in an orderly and efficient manner -- which is simply not possible the way Access is set up.It's almost like a text file on a file server somewhere, and multiple users have that text file open at once on their PC's. Just thinking about that, it's amazing that Access works as well as it does at all ! Less than 5 users works the best, any more than 4 or so it is definitely not recommended to use Access. And of course, you must have a fast LAN since, potentially, each user accessing the database must read it the entire thing into their PC to find data (if no indexes are present). Which leads to file locking problems, etc.But overall, it works very well. Most people don't realize that Access has full support for indexes on your tables; using them properly can really improve performace.- Jeff |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-25 : 09:11:33
|
| so it basically rounds down to:it depends on what you need to do Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
|
|
"Ms-Access not a database for serious programmer"