Re: Upgrading Access 97 application to dotNet

im not sure that A97 vs A2000 makes much difference.

A97 would most likely be SMALLER than 2000 because of doublebyte
character strings (everything is double-byte in 2000) of course unicode
compression was suposed to make this somewhat smaller..

in general; I would expect marginally larger databases in 2000 with
marginally larger cpu utilization.

so yeah; im not sure I would change it just for the sake of changing
it.

and I think that Jet 4.0 works just as well with Access 97 database as
it does with Access 97.. right?

I htink that you're fucked if you're going to build a database in the
year 2006; it would just be stupid to not use SQL 2005 Express

-Aaron






RobinS wrote:
But he should upgrade to the most current version of Access,
not leave it in Access97. (Yikes!)

Robin S.
-------------------------------------
"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:nt98n2p8i3c9gmcqubg5ec1i6ucvtd5bai@xxxxxxxxxx
On 1 Dec 2006 12:53:18 -0800, "kavsak" <stuart.hall8@xxxxxxxxxxxxxxx>
wrote:

¤ Hi. Not sure that this is the right place to ask but here goes.
¤
¤ I have an application based on access97 and VB6 which I need to
¤ upgrade. It has to handle up to 20 concurrent users on a Win2k network
¤ ( to be upgraded to XP next year) which has no connection to the
¤ outside world, but normally there are no more than 2. It has
¤ approximately 150 tables with complicated validation rules and a large
¤ amount of calculation. I want to rewrite it in VB net or C# with a
¤ suitable modern database. So I far I have 3 weeks experience of the
¤ .Net world.
¤
¤ I am not permitted to run any form of central database server, but data
¤ tables must (?) be held on the network server to provide the multi user
¤ capability. It must also be possible to transfer the application and
¤ its database to a standalone laptop for use in other locations.
¤
¤ Can I use SQL Server in any form as this seems to be the best match for
¤ VS2005 or do I have to continue to use Access?

Given the requirements you've stated I would stick with your Microsoft
Access database
implementation. Since you can't operate in a server based environment that
would eliminate both SQL
Server and SQL Server Express from consideration. Since you're already
using Access you may as well
stick with it instead of moving to another file based database.


Paul
~~~~
Microsoft MVP (Visual Basic)

.