Re: migrating from access: mdb or sql server files or what
From: Norman Yuan (nobody_at_nowhere.no)
Date: 08/17/04
- Next message: Cindy Winegarden: "Re: inserting a decimal into a fox pro database from VB"
- Previous message: Veign: "Re: Newbie - Creating ms access table from Visual Basic"
- In reply to: PF: "migrating from access: mdb or sql server files or what"
- Next in thread: Paul Clement: "Re: migrating from access: mdb or sql server files or what"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 08:03:37 -0700
For a single user ans single computer, and Access installed, you already
have everything. If you could refine the code in Access further, it could be
as perfect as you can get. Why convert it to SQL Server (even the license
cost is not an issue, it need significant more knowledge to manage,
definitely not doable task for average database user, even a self-claimed
exerienced computer user), and VB. As for VB.NET, it is almost entirely
different animal, you certainly will rewrite everthing from scratch (except
for the data table), if you are to move it to .NET.
"PF" <pf@arobas.net> wrote in message
news:rjnUc.82544$sk2.1647355@wagner.videotron.net...
> 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?
>
> Best regards
>
> pierre
>
>
- Next message: Cindy Winegarden: "Re: inserting a decimal into a fox pro database from VB"
- Previous message: Veign: "Re: Newbie - Creating ms access table from Visual Basic"
- In reply to: PF: "migrating from access: mdb or sql server files or what"
- Next in thread: Paul Clement: "Re: migrating from access: mdb or sql server files or what"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
