Re: What Database model should I use?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Thu, 30 Jun 2005 23:39:03 -0700, "George H. Slamowitz" <GSlamowitz@xxxxxxx> wrote:

¤ Hello all:
¤
¤ I have been programming in microsoft access for years. I have to convert
¤ onew of my MS Access 2000 applications to Visual Basic. I purchased visual
¤ Studio .NET and it was recommended that it will be easier to conver to Bisual
¤ Basic 6 so I purchased Visual Studio 6.
¤
¤ I have had a few setbacks in converting the application, there are some
¤ differences between MS Access 2000 and Visual Basic 6, I am able to get
¤ around most of the problems.
¤
¤ I have been anble to convert the screens and most of the code, with little
¤ or no problems.
¤
¤ But I am having a problem converting the MS Access JET databases.
¤
¤ I have several .MDB. These files reside in three different locations (1) On
¤ the Local machine, (2) on the LAN and (3) on servers on the WAN. To start
¤ with I want to leave the files in tact, and convert the application to use
¤ the same tables / files. Once the application is converted, I want to
¤ upgrade the JET engine to a real SQL database, ig SQL Serever, Orical, MySQL
¤ , etc.
¤
¤ Can anyone recommend that best database model to use to get me to my
¤ ultyimate platform? is there any documentation on have to convert to this
¤ platform
¤
¤ Thanks in advance for any help you can offer

Microsoft Access includes an Upsizing Wizard to help you convert to a SQL Server database
(Tools...Database Utilities...Upsizing Wizard).

After you have converted you will need to change the database provider (connection) from Access to
SQL Server. Below is a link to connection string examples:

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Load Picture from MS Access to VB6
    ... in code to compact the database via a menu option. ... there is a chance the filename of the photo itself can ... > ¤ Well, I figured it out I think. ... loaded images into the database directly through Access (so that I could ...
    (microsoft.public.vb.general.discussion)
  • 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: Please Help Me in Visual Basic 6.0 SP6
    ... Dim dbPath As String ... Above is my programming where in this programming, ... how can i indicate myself which one i'm gonna insert to the database. ... > ¤ solution where as somebody can help me where to start. ...
    (microsoft.public.vb.database)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • 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)