Re: Upgrading Access 97 application to dotNet

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)


.

Relevant Pages

  • Re: Upgrading Access 97 application to dotNet
    ... I htink that you're fucked if you're going to build a database in the ... ¤ Hi. ... I am not permitted to run any form of central database server, ... Server and SQL Server Express from consideration. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Upgrading Access 97 application to dotNet
    ... I htink that you're fucked if you're going to build a database in the ... ¤ Hi. ... I am not permitted to run any form of central database server, ... Server and SQL Server Express from consideration. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: CONNECTION PROBLEM USING VB6 TO SQL SEVER 2000 PERSONAL EDITON
    ... ¤ I am having a problem in my vb6 application when I try to connect to sql ... server 2000 personal editon with the following connection string.(I am ... and VB6 and installed sql ... Is your SQL Server configured for both SQL Server and Windows ...
    (microsoft.public.vb.enterprise)
  • Re: multiple connections
    ... > ¤ Yes, both are Oracle databases, but they are not on the same server. ... > ¤> You cannot use connection against one database to execute any SQL ...
    (microsoft.public.vb.database.ado)
  • Re: connect remote Access database
    ... upload the whole .mdb file once. ... > ¤ Hello ... MS Access databae which is located on a server? ... > where the database file is located. ...
    (microsoft.public.dotnet.framework.adonet)