Re: Upgrading Access 97 application to dotNet

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

Relevant Pages

  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access (jet) vs SQL Server Express
    ... ¤ Access or SQL Server Express. ... more robust database server package. ... Microsoft MVP ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: What Database model should I use?
    ... I'm not sure which SQL Server I'm going to convert to ... ... I'm currently converting the application to VB6 ... > ¤ I have been programming in microsoft access for years. ... upgrade the JET engine to a real SQL database, ig SQL Serever, Orical, MySQL ...
    (microsoft.public.vb.database)
  • Re: Upload Access Data to Web
    ... to set up a connection between the Access Database and Sql Server? ... Access Database already exist but since the Sql Server Database hasn't been ... ¤ local server to a sql table on a web server. ...
    (microsoft.public.vb.com)
  • Re: Copy database schema from Access to SQL Server
    ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ... template database and the target database and compare their schemata. ...
    (microsoft.public.dotnet.framework.adonet)