Re: What Database model should I use?
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Fri, 1 Jul 2005 08:11:13 -0700
Okay, you are where lots of people have come from and you want to go where
lots of people want to go and there are lots of people here that can help.
I would make the following suggestions. Let's clarify a few points though.
You say you bought Visual Studio .NET. This is NOT VB6, it's VB.NET. Which
did you buy?
If you want to upgrade to a serious DBMS you did not list SQL Server. There
are free versions of SQL Server you can use like MSDE 2000 or SQL Express
2005(about to be released this fall). Both can be downloaded today for free.
Porting Access/JET databases can be done with the upsizing wizard as
suggested, but the wizard does not do all of the work. There are a couple of
books on upsizing from Access (one by Apress is ok).
I would also read about coding ADO a bit more. There are several good books
on ADO and ADO.NET and mine is one of them.
If you're transitioning to VB.NET, then ADO.NET is what you need to read
about. If you're using VB6, then you need to study ADO. DAO is designed to
interface with Access/JET databases (and just that). I have no idea why
someone suggested ODBC. It does not makes sense at all in this case.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"George H. Slamowitz" <GSlamowitz@xxxxxxx> wrote in message
news:E9C69CC8-F91C-46CE-9099-5CAAEAC5FB6C@xxxxxxxxxxxxxxxx
> 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
>
> --
> George H. Slamowitz
> (602) 765-8111
> (602) 765-8222 (FAX)
.
- References:
- What Database model should I use?
- From: George H. Slamowitz
- What Database model should I use?
- Prev by Date: Re: What Database model should I use?
- Next by Date: Re: What Database model should I use?
- Previous by thread: Re: What Database model should I use?
- Next by thread: RE: What Database model should I use?
- Index(es):
Relevant Pages
|
