Re: migrating from access: mdb or sql server files or what

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 13:28:03 -0500

On Tue, 17 Aug 2004 09:00:00 -0400, "PF" <pf@arobas.net> wrote:

¤ Hi all,
¤
¤ I have an access application
¤ code and data in the same file.
¤
¤ It runs on a single computer
¤ with a single user
¤
¤ Speed of response is critical.
¤
¤ The program seek continuously for a
¤ variable string, if found, a record is created
¤ with the key and additional data.
¤ In peak time 3 rerod/second of 40 bytes.
¤
¤ We want to migrate to vb (vb.net)
¤
¤ The question is: for speed should
¤ we stay with mdb table, or should we link to
¤ a sql server? or any other kind?
¤
¤ Should we install a sql server 2000
¤ on that computer and run the
¤ program in the server directly?
¤
¤ If use we have to connect to the server
¤ make a request to search for a string and
¤ then make a request for an insert.
¤ I suppose this would be longer than an
¤ insert in a mdb table. ?
¤
¤ We have an old oracle 8.0 database
¤ that came with novell and is not in use.
¤ Is it thinkable to use it?
¤
¤ What is the best choice?
¤ a vb program with an mdb table?
¤ a sql server running a program?
¤ what kind of connection is the fastest
¤
¤ actually we are using DAO.
¤ there are ADO,oledb,odbc
¤
¤ Cans someone give me a hint?

If it's a single user database and you haven't had any database corruption issues then there
probably isn't much reason to update. I would agree with Norman.

If you choose to upgrade to SQL Server then I would recommend SQL Server 2000 Desktop Engine (MSDE)
instead of the full blown server version.

I wouldn't bother using Oracle for this type of application.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • RE: database options with SBS 2003 R2
    ... It was doable for the customer to design their own access database in a peer ... If you don't want to deal with a version of SQL Server for the data, ... end MDB files. ...
    (microsoft.public.windows.server.sbs)
  • RE: Access project vs. Access db
    ... Code and techniques that work fine in an MDB don't always work ... route with an MDB database file instead. ... > the SQL docs, but in the meantime, what is the correct syntax for Boolean ... Jet won't warn you of this logic error, but SQL Server does. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2002 Upsizing Wizard does not copy forms
    ... Upsizing *.mdb to SQL Server, using Upsizing Wizard, ONLY transfer data from ... Jet database to a SQL Server database (either new or existing, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: database options with SBS 2003 R2
    ... MSDE is the lightweight, free version of SQL Server 2000 which you can use ... as a backend database for a client-server application. ... end MDB files. ...
    (microsoft.public.windows.server.sbs)
  • Re: Guide for switching to .ADP from .MDB
    ... >Create an Access database front-end to an SQL Server database back-end ... and the SQL Server provides centralized data ... >an MDB application from Access to SQL server. ...
    (microsoft.public.access.adp.sqlserver)