Re: Access 97 to a more powerfull platform!?

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 14:00:12 -0600

"Rick" <Rick@discussions.microsoft.com> wrote in message
news:2C2EA83B-8264-48BB-9C5E-6F588F6D798E@microsoft.com...
> Can someone point me in the direction of a web site or news group that
might
> contain usefull information for someone who has several Access97 projects
> that are growing beyong their capacity and need to be converted to SQL or
> some version of Access beyond 97 that might improve the applications
> performance?? I am especially interested in any tools that might assist
in a
> conversion and the benifits of subsequent versions of Access (2002??)
>
> I am waist deep in this problem and am going to have to find a solution
> rather quickly!

It is very unlikely that moving to a different version of Access will
improve performance (more likely it will be worse). As with most software
the newer versions of Office consume more system resources and disk space
so when run on identical hardware typically perform worse than older
versions.

Moving to SQL Server (or similar) is common when a database "outgrows"
Access/Jet, but this usually gains advantages in concurrency, volume (size
capability), and security, not really performance per se.

Design problems are far and away the usual reason why a database
application performs poorly. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: Cant read from database ??
    ... You also may need to worry about some permissions. ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: HELP on How to move database files
    ... http://www.support.microsoft.com/?id=314546 Moving DB's between Servers ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ... > What I want to do is to move the transaction log file to a different> location or even better get rid of it and create a new log file in its new ...
    (microsoft.public.sqlserver.server)
  • Re: moving data in a database to another file on a SAN
    ... http://www.support.microsoft.com/?id=314546 Moving DB's between Servers ... for SQL Server ... I seem to remember that there is a way to move data from the file that stores the data for a database to another file and then delete the original file. ... I thought that might work for moving the data to a SAN. ...
    (microsoft.public.sqlserver.server)
  • Re: best method for switching to a new server
    ... I can get the moving the db thing, no prob, but it's the in between part ... > a Restore ... > for SQL Server ... >> to move the Sql Server 2K database from the old to the new. ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)