Converting MS Access 2000 application to a VB / VB.NET application

George H. Slamowitz

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)

Nov 21 '05 #1

Subscribe Reply

2124

Jerry H.

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....spx?PostID=563

HTH

Nov 21 '05 #2

Cor Ligthert

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/de...systemdata.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/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

When you see samples you see them than as well often for SQLserver they are
almost (with exceptions from the command.paramet ers) 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

Nov 21 '05 #3

Dean Slindee

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

"George H. Slamowitz" <GS********@COX .NET> wrote in message
news:19******** *************** ***********@mic rosoft.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)

Nov 21 '05 #4

Similar topics

2908

converting access db to mysql

by: chicha | last post by:

Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...

Microsoft SQL Server

3088

Converting Access 2.0 Report into rtf

by: Lars | last post by:

We are using an Access 2.0 application which will be replaced by another solution. The new one is an Web-Application which is based on SQL Server 2000. This application uses rtf-documents to create reports. Now we´ve got the problem that there are over 500 Access report which has to be converted into rtf-documents. We tried to export the reports out of the page review into Word, but that didn´t work, because we are using Word XP or Word...

Microsoft Access / VBA

4718

Converting Access Desktop Application to Client Server

by: Uttam | last post by:

Hello, I am currently in the process of developing an application in a pure desktop world using Access 2000. I am intending to convert this pure desktop application into a Client Server application with Access 2000 as the front end and the each of the following as the backend: 1) Oracle

Microsoft Access / VBA

1660

Converting from Access2K to Access2K3

by: Andy | last post by:

Hi ! I have many simple, low-tech database applications spread throughout my organization that I developed in Access 2K.. Most have ODBC for Oracle connections ( read only ) to our principal application ( a mid size hospital's ADT software ). My current version of Access is 2000. I must now decide wether or not to install Access2003 on the PC that I use to develop these applications. The users will be converted to 3000 over the next 6...

Microsoft Access / VBA

1671

Bulk Converting Access 97 to Access 2000

by: Rohit | last post by:

Hi, My organisation is using Access 97 and going to replace it with access 2000. Users have n number mdb files created in 97. After installation of Access 2000 I need to conver ALL the mdbs to 97. Is there any so that this process will take minimum amount of time? Thanks in Advance

Microsoft Access / VBA

2527

Reference Issue converting site from 1.1 to 2.0

by: Robert | last post by:

I have a series of web applications (configured as separate applications) on a server. There is a main application at the root and then several virtual directories that are independant applications. I am testing an upgrade of all of the sites and have converted the main root site...although not necessarily fixed any issues. I move on instead and converted one of the virtual roots that is a seperate

ASP.NET

8379

Converting Access 2000 to 2003

by: NEWSGROUPS | last post by:

I work for an organization that is migrating from Access 2000 to Access 2003. About 5 or 6 years ago we migrated from Access 97 to Access 2000 with no problem. Will I have trouble converting these already converted databases to Access 2003? We also have 2 mda's, will these convert with no problem in the mda format. We no longer have the mdb that made the mda. Are there any other nuances that I need to look out for? Thanks in advance,...

Microsoft Access / VBA

1146

converting databases via code

by: ARC | last post by:

Hello all, I'm attempting to update a client/server application from access 97 to access 2000. I have a number of .mdb files that I use for various uses. If I distribute new access 2000 .mde's and runtimes, is there a way through code to convert the existing access 97 .mdb's to access 2000? Or do I need to use a new folder with blank 2000 .mdb's, and import the data from each access 97 ..mdb? Many thanks,

Microsoft Access / VBA

7755

converting Access 2000 to 2007

by: ncsthbell | last post by:

We currently have Access 2000 and are converting to 2007. I have a very complicated Access application and am so lost with where to start. When I bring the application up, there are different tabs at the top (I see these on the tutorial under office.microsoft.com. They are showing "home" "create" "external data" "database tools" and "datasheet". When I open my application, the only one I see is "help". Why can't I see the other ones? I am...

Microsoft Access / VBA

9491

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10357

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10163

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10104

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8988

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5532

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4063

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3668

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2894

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General