Trying to use Visual Basic 6 to open a Microsoft Access .mdb

Perry

I have no idea where to start, I just need a general idea if this is
possible:

Originally I created a vb app that uses the WebBrowser component to
view excel files, which seemed to work fine, but does not give me the
control over the user scrolling around the spreadsheet once it was
loaded.

I then tried using the OLE object to open an embedded excel form and
that looks terribly ugly when you try to edit any of the fields.

So now I'm on to trying to open an access application within my vb
application. Is this even possible? and if so what component do I
need to import inorder to open the *.mdb file? I've searched and
searched but to no avail it looks like no one has tried doing this
(perhaps there are better ways).

Please help, I'm running out of time... Thanks in advance,

Perry

Jul 17 '05 #1

Subscribe Reply

6744

Dillon Mantle

Really Easy

The simple, non SQL way of doing it is...

1> Save the database in Access 97 format

2>Paste a 'Data' control into the application, the one that is visible in
the standard tool box.

3> In the property palette, specify "databasena me" and the "recordset"
(which is the table)

4> Link a textbox or whatever to the data control via "datasource " and then
the actual column within the table with which you want to get data from with
the "recordsour ce"

My names may be a bit wrong, but thats how it works. if you want some source
I can send it to you

--
Regards
Dillon Mantle
Different Angle Solutions
072 300 0206
"Perry" <pn******@hotma il.com> wrote in message
news:5f******** *************** ***@posting.goo gle.com...

I have no idea where to start, I just need a general idea if this is
possible:

Originally I created a vb app that uses the WebBrowser component to
view excel files, which seemed to work fine, but does not give me the
control over the user scrolling around the spreadsheet once it was
loaded.

I then tried using the OLE object to open an embedded excel form and
that looks terribly ugly when you try to edit any of the fields.

So now I'm on to trying to open an access application within my vb
application. Is this even possible? and if so what component do I
need to import inorder to open the *.mdb file? I've searched and
searched but to no avail it looks like no one has tried doing this
(perhaps there are better ways).

Please help, I'm running out of time... Thanks in advance,

Perry

Jul 17 '05 #2

Similar topics

7269

visual studio.net version compatibility

by: angelag | last post by:

I am currently taking a college course in Visual Basic.Net and I am a beginner. I bought Visual Studio.Net 2003 to do my homework at home. I built my first project and e-mailed it to myself at school. When I tried to open it in the lab, I got a message saying I couldn't open it because it was created with a newer version. Evidently the lab is using Visual Studio.Net 2002. My professor doesn't just want the executable file, he wants...

Visual Basic 4 / 5 / 6

1909

Error in Visual Basic closes the database

by: nicole bissell | last post by:

Hello, I am working in a new form and still making changes to the visual basic code of the form. Not always, but very often when I try to save my changes in the visual basic window and press the icon, this window closes(without saving) and the whole database, too. I already tried to switch everything in a new form and error occurs again after starting to work in the visual basic code of this specific form not in others and I did...

Microsoft Access / VBA

2303

Trying to create my first ASP.Net application

by: Frank Wilson | last post by:

Tom, It sounds to me like ASP, not ASP.NET is handling the request for WebForm1.aspx. This is most likely an IIS config issue that may have been caused by order of installation or reinstallation, or possibly even something that happened in IIS before .NET was installed. Here is a way to prove or disprove my theory:

ASP.NET

2173

MSDE, ASP.NET, Visual Studio .NET, and connectionstrings

by: Nathan Sokalski | last post by:

I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should...

ASP.NET

3310

Microsoft JET database error while trying to open excel file from ASP.NET

by: rh.krish | last post by:

Hi I'm trying to open an excel file uploaded by the user and read the content. I'm able to save the file in the web server, but when I try to open it - I get the following error: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data. "

ASP.NET

3100

Experience of converting VB6 applications to Visual Basic.net

by: Chris Asaipillai | last post by:

Hi there My compay has a number of Visual Basic 6 applications which are front endeed onto either SQL Server or Microsoft Access databases. Now we are in process of planning to re-write these applications into Visual Basic.Net. My managers main thought is that Visual Basic 6 is (or has!) stopped being supported by Microsoft.

.NET Framework

1608

connecting visual basic with ms access database

by: jayantim | last post by:

Hi ! I want to know the connection code for connecting visual basic and microsoft access. plese give the detail code for this connection. Actually I tried one code which is as follows: Dim cn as connection Dim rs as recordset Private Sub form() set cn = new connection set rs = new recordset

Visual Basic 4 / 5 / 6

2065

error message trying the microsoft console application example

by: Stephen Thomas | last post by:

Hi there I wonder if any one has encountered this problem or can suggest what is wrong. I am trying the a procedure from the msn site but get the following message: Error 1 The type or namespace name 'LiveSearch' does not exist in the namespace 'ConsoleSampleWebSearch' (are you missing an assembly reference?) C:\Documents and Settings\Compaq\Local Settings\Application Data\Temporary Projects\ConsoleSampleWebSearch\Program.cs 13 30...

C# / C Sharp

2970

In Visual Basic 2008 create aspx web pages programmatically

by: =?Utf-8?B?UGV0ZXIgSw==?= | last post by:

I am working with Visual Studio or alternately with Expression Web. I need to create about 50 aspx pages with about 1200 thumbnali images, typically arranged in three to four groups per page, having hyperlinks to the corresponding full size images. Can anybody point me to locations in MSDN or elsewhere giving the references to attach, the commands & objects for creating or opening the pages and possibly available classes? I have done...

Visual Basic .NET

9645

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

10329

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

10152

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

10092

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

9950

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

7500

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

5511

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

4053

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

2880

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