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 |
|
kelly
Starting Member
6 Posts |
 Posted - 2005-08-08 : 08:40:17
|
| We use SQL Server 2000 on the back-end of our directory web site and ASP on the front end which works fine. However, for my own uses (since I don't create the asp and have to pay a programmer), would it be better to set up an Access 2003 project for my own data entry forms, standard reports and quick searching?What would be the negatives of this approach. Remember, this is just for me.Thanks in advance,Kelly |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-08-08 : 16:03:38
|
| Hi Kelly,Are you opposed to simply using SQL Server to perform these tasks?I think querying the database directly would be the best approach. I think with a little practice (and some Sqlteam help) you would become very comfortable using tools like DTS / Query Analyzer to navigate the data.Are there specific tasks that you feel would be too difficult to accomplish using these tools?Nathan Skerl |
 |
|
|
kelly
Starting Member
6 Posts |
Posted - 2005-08-09 : 08:06:55
|
| Hi Nathans,Correct me if I'm wrong but that seems like a poor way to handle things like data entry where complex forms with sub forms filled with data tell you everything you need to know about a client history. Also, tabular layouts are a terrible way to read a record's data on a bunch of fields compared to a form.Am I missing something here?Kelly |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-09 : 08:09:37
|
| It depends on what you want to do. The real issue though is that Access front-ends to SQL Server can have significant performance problems. Since you are the only person using it then it should not be too bad, but beware of the situations where multiple people start using Access to query SQL Server data. Access does not handle concurrent users that well. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-08-09 : 13:12:16
|
Well, I guess I am a bit biased as I have zero experience using Access as a front-end to administer SQL Server. We have some legacy tasks that are setup this way but they are riddled with bugs and rarely work (im sure this has more to do with our implementation than the limitations/shortcomings of Access).I guess it comes down to which solution you feel comfortable with. I think the best solution performance-wise would be for you to learn some ASP and build your own admin tools that interact with SQL Server directly via stored procedures. But like RV said, it really depends on how you want to use it and how complex these tasks are. When I first read your post I envisioned you doing some simple data entry (new customer, update phone number, etc.) or specific reporting (total sales in June, etc.) but it sounds like things may be a bit more involved  Nathan Skerl |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-09 : 15:17:22
|
| you need noting more than sql server to administer sql server. all front end tools for administering sql (except for doing data entry and reporting) are uneccessary and are for people who do not know how to use SQL.Get a copy of The Book and read it all.http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-08-09 : 19:14:38
|
| Kelly, If I can go against the flow here.... ADP's would be an acceptable solution IMO. I've used them in the past and have been impressed. If you want to show your data in some meaningful format you can't really use QA/EM. Rob's comments are valid, but I haven't seen instances where data was corrupted using ADP's. Access does have some integrity issues but that's more to do with it's own database engine, which is obviously not used when you play around with ADP's.Just my two penneth, anyway,Tim |
|
|
|
|
|
|
|
|
Access 2003 Projects as Front-end?