|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Converting MS Access 2000 application to a VB / VB.NET applicationI am trying to convert a MS Access 2000 application to a VB application (Just Started Yesterday) I am using Visual Studio .NET 2003 utilizing Visual Basic .NET I think I have a good feel to what I have to do, but does anyone know of a GOOD white paper on what is involved, pitfalls, etc? So far I have run into one problem that I have not been able to figure away around. That is how to access the tables. In access you have Database objects, Recordset objects and all if the associated methods. I cant seem to find out how to convert this to VB. I have been reading through postings in this Discussion Group, but I am still a little bit confused. Is there a SIMPLE way to access the existing .MDB database tables, and the individual fields within the tables. Any help would be greatly appreciated, or a pointer to a good white paper describing the procedure. Thanks in advance -- George H. Slamowitz (602) 765-8111 (602) 765-8222 (FAX) Heh, some of my co-workers who are absolute Wizards with MS Access, but
are now asking similar questions as yours. I'd say that, right now, there isn't really a *simple* way with .NET 1.1, however .NET 2.0 framework will make offer better methods and easier access to datasources. Anyway, you might look here, as this person offers some straight forward examples: http://www.visual-basic-data-mining.net/Forum/ShowPost.aspx?PostID=563 HTH George,
There is no way to convert a MS Access application to a VBNet application. However the use of the database itself is very easy to do. For that you can use ADONET in which are the classes from the so called system.data namespace http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdata.asp Do not mix this up with ADO (ADODB) what is completly different and not really a Net part. For MS Access the best choise to connect and use it is than OLEDB. In this newsgroup you will mostly be helped with problems about that. Another very good newsgroup for that is Adonet news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet Web interface: http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.dotnet.framework.adonet When you see samples you see them than as well often for SQLserver they are almost (with exceptions from the command.parameters) always the same as for msaccess with the difference where an instructions starts for SQL with by instance SQLCommand it is for access (OleDB) OleDbCommand A good place to start is in my opinion. http://samples.gotdotnet.com/quickstart/ I hope this helps a little bit? Cor You need to decide one important point first: is the data going to stay in
..mdb tables? If yes, then you can use VB.NET calling ADO recordsets (not ADO.NET datasets) This is Not progressive thinking in .NET land, but it works. If no, then consider upsizing the Access application backend from .mdb to SQL Server tables. Access has an internal tool to do this. You will need to convert Access queries into SQL Server stored procedures that can be called from VB.NET. The stored procedures can also be the recordsource for the upsized Access front-end (should you decide to retain it for some reason, or for an interim period). I have done all of the above over the past several years, and they all work. Dean Slindee Show quoteHide quote "George H. Slamowitz" <GSlamow***@COX.NET> wrote in message news:19A1511D-5252-46C5-80E2-78BE41D08E39@microsoft.com... > Hello All > > I am trying to convert a MS Access 2000 application to a VB application > (Just Started Yesterday) > > I am using Visual Studio .NET 2003 utilizing Visual Basic .NET > > I think I have a good feel to what I have to do, but does anyone know of a > GOOD white paper on what is involved, pitfalls, etc? > > So far I have run into one problem that I have not been able to figure away > around. > That is how to access the tables. In access you have Database objects, > Recordset objects and all if the associated methods. I cant seem to find out > how to convert this to VB. I have been reading through postings in this > Discussion Group, but I am still a little bit confused. > > Is there a SIMPLE way to access the existing .MDB database tables, and the > individual fields within the tables. Any help would be greatly appreciated, > or a pointer to a good white paper describing the procedure. > > Thanks in advance > > -- > George H. Slamowitz > (602) 765-8111 > (602) 765-8222 (FAX) |
|||||||||||||||||||||||
Other interesting topics