Re: Access DB grows too fast.
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 06/29/04
- Next message: George Hester: "Re: Session or Application?"
- Previous message: Nate Clark: "Re: Access DB grows too fast."
- In reply to: Nate Clark: "Re: Access DB grows too fast."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Jun 2004 17:49:37 -0700
Be advised that the current version of MSDE is limited to 2 GB as well--per
database. However, I suspect that this will not be an issue. Ask me again
about this after TechEd... I think MSDE will be far (far) better suited to
your needs. Remember, it's really SQL Server. The easiest approach to get
started is to pick up the $35 ($49 SRP) Developer Edition that has all the
tools you'll ever need.
hth
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "Nate Clark" <ntclark@attglobal.net> wrote in message news:40E0B620.60504@attglobal.net... > Thanks very much for the advice Bill. It helps me more than you might know. > > I didn't even know about MSDE. A quick search found it and that is > something I think I can really use. > > This particular application is one that I inherited a few months ago and > it had been completely built with an Access database. Thare are huge > processing requirements all throughout the application that are done in > SQL over Access and quite frankly bring it (Access), to it's knees. > > Even though this application is in that stage between Beta test and > delivery, I think that given the circumstances and problems I've been > encountering with the more "real world" data sets, having any different > client only DB is going to ward off substantial problems in the future. > Not the least of which is this "rumor" of problems with an Access DB > over 2 GB. It is certainly worth a try ! > > I also have another system that makes heavy use of a client side DB for > which I've had to dance around it's limitations for 5 years now, > currently using the precursor to Adapaptive Server Anywhere for this > system. I have been wanting to replace it's client side DB and this > looks like just the ticket ! > > > Thanks again ! > > Nate Clark > > > William (Bill) Vaughn wrote: > > I expect that there's some "modifying" going on. I don't recommend > > SQLPrepare for SQL Server as all of the more recent drivers/providers don't > > need it. If I were you I would switch to MSDE where the operations can be > > more closely monitored and it's designed for more throughput. > > >
- Next message: George Hester: "Re: Session or Application?"
- Previous message: Nate Clark: "Re: Access DB grows too fast."
- In reply to: Nate Clark: "Re: Access DB grows too fast."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
