Re: Access DB grows too fast.

From: Nate Clark (ntclark_at_attglobal.net)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 00:21:30 GMT

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.
>

Relevant Pages

  • Re: MSDE 1.0 and Win2000 Server. Performance
    ... > 1.0 engine. ... > have been tests with only one client attached to the server at a time. ... > Service packs for the MSDE engine have not done any good. ... MSDE has a built in workload query governor that kicks ...
    (microsoft.public.sqlserver.msde)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... Upgrade MSDE to SP4: not ok. ... Windows 2003 Server ships with SSEE preinstalled (for ... > port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: Setup & Installation
    ... > auf jedem Client PC die volle MSDE installiert werden muss ??? ... Für den Datenzugriff auf Datenbanken ist bei VB-Programmen der jeweils ... wird i.d.R. auf Grund der Verweise im Projekt vom Setup erkannt und ...
    (microsoft.public.de.vb)
  • RE: Distribution
    ... Create your application, an MSDE client/consumer. ... If your client does NOT run on the same machine as the server, ... The deployment project checks for MDAC as a Launch Condition (e.g., ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: off-site adp
    ... it depends on how many users use the ADP client concurrently. ... Since clients can query the same msde db on client side, Using SQL ...
    (microsoft.public.access.adp.sqlserver)