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

[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 "databasename" 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 "recordsource"

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******@hotmail.com> wrote in message
news:5f**************************@posting.google.c om...

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