Can I update a MS Access 2002 database with Visual Basic .net 2003 Standard Editon?

pisaac

I am considering purchasing Visual Basic .net 2003 Standard Editon to
do some development work with Web Forms and I need to know whether
this edit will allow me to update an Access database (mdb) file. I
already have a database which is updated through an Access front-end,
I want to update the database through web forms, is this possible?
what are the benefits of going for the Professional Verion of Visual
Studio instead?

Cheers,

Nov 13 '05 #1

Subscribe Reply

1820

MGFoster

In VB.Net you'd use the ADO.Net objects to update the database.

Visual Studio.Net is just another Rapid Application Development (RAD)
tool. It has the added ability of being the development platform for
VB.NET, C#.NET, C++.NET, Java.NET. It can also easily create XML
objects/dependencies and set up web pages to use ASP.NET. And, other
stuff I've forgotten about.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

pisaac wrote:

I am considering purchasing Visual Basic .net 2003 Standard Editon to
do some development work with Web Forms and I need to know whether
this edit will allow me to update an Access database (mdb) file. I
already have a database which is updated through an Access front-end,
I want to update the database through web forms, is this possible?
what are the benefits of going for the Professional Verion of Visual
Studio instead?

Nov 13 '05 #2

Larry Linson

You'd want to go to the description of what you get with VB.NET Standard to
see if it comes with the necessary support for dealing with Access/Jet
databases.

I've never used VB.NET Standard. I suspect most developers here who have
used .NET have used Visual Studio.NET, which certainly does have the
capability. Whether the "standard" edition does, I couldn't say.

It is just a matter of what Microsoft has packaged in that edition and what
is licensed when you purchase it.

Larry Linson
Microsoft Access MVP

"pisaac" <ro********@yah oo.co.uk> wrote in message
news:bd******** *************** ***@posting.goo gle.com...

I am considering purchasing Visual Basic .net 2003 Standard Editon to
do some development work with Web Forms and I need to know whether
this edit will allow me to update an Access database (mdb) file. I
already have a database which is updated through an Access front-end,
I want to update the database through web forms, is this possible?
what are the benefits of going for the Professional Verion of Visual
Studio instead?

Cheers,

Nov 13 '05 #3

Similar topics

1829

Access 2002 Database Design Help

by: John C | last post by:

I am trying to develop a access database version 2002 from scratch and I am a novice programmer and need much direction. I have been researching and studying about relational database design and normalization I am including the 9 tables and there fields that I have already developed. I have and I am not sure what to name the tables and I am thinking of making the incident # field the pimary key?? Can I put that in all the tables? I...

Microsoft Access / VBA

3475

Problems Opening Access 2003 mde Files In Access 2002

by: Wayne Aprato | last post by:

I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." Interestingly I can open the mdb files of the same 2003 databases in Access 2002 without problems. To my understanding the file formats of 2002 and 2003 are the same and this problem shouldn't exist. And why is it only the mde files that are giving the...

Microsoft Access / VBA

4778

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance

Microsoft Access / VBA

2862

Limits of Access 2003 using ADP on SQL Server Express BE?

by: Matt Alanzo | last post by:

On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing you >won't be able to do is access any of the design surfaces for SQLS >objects in the ADP. I checked with the Access team on this :-) > I appealed for clarification but without reply. Maybe somone on this newsgroup can provide insight.

Microsoft Access / VBA

3810

Access database as 'exe' file

by: StuartD | last post by:

I am developing an Access database with files linked to external spreadsheets and wish to distribute it as an 'exe' file. Is this possible and if so, can anyone answer my dumb question? Thks

Microsoft Access / VBA

5312

Future of access?

by: John | last post by:

Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. Any comments? Thanks

Microsoft Access / VBA

5847

OleDbDataAdapter won't update database from dataset (Display at Width = 65)

by: M. David Johnson | last post by:

I cannot get my OleDbDataAdapter to update my database table from my local dataset table. The Knowledge Base doesn't seem to help - see item 10 below. I have a Microsoft Access 2000 database which indexes computer magazine articles for personal reference. I am developing a Visual Basic.NET program whose sole purpose is to enter new records into the database. No updates to existing entries, no deletions, and no display

Visual Basic .NET

4442

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...

Microsoft Access / VBA

7788

Access Crashes When Rt Click Build in Query Design View

by: mnjkahn via AccessMonster.com | last post by:

I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window appears. It doesn't happen every time, and using the Zoom window works fine. It appears that it only happens when I want to modify an existing expression. This continues to happen even after the database is repaired and reopened. Anyone have any...

Microsoft Access / VBA

10165

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

11579

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++

11177

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

11353

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

10694

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8256

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

7431

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

6337

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

3545

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