MS Access from vb.net

  • Thread starter Thread starter Sehboo
  • Start date Start date
S

Sehboo

Hi,

I want to open .mdb file from vb.net and check fields in few forms,
but I don't want to use the MSAccess COM object because customer might
not have access installed on the machine.

Where can I find more information about access file structure or is
there any third party tool that I can use which doesn't require
access?

Thanks
 
I want to open .mdb file from vb.net and check fields in few forms,
but I don't want to use the MSAccess COM object because customer might
not have access installed on the machine.

Where can I find more information about access file structure or is
there any third party tool that I can use which doesn't require
access?
Click to expand...

When it comes to forms you're pretty much out of luck. I've heard of
third-party components being able to use Access REPORTS, but not forms.

Why would you need to check forms anyway?
 
Hi Sehboo,

This is the kip and egg.

When the user has access you do not have to use Com objects, all is in
AdoNet. (All with OleDB very nice to do)

When not, than you do not have to check fields.

Can you describe more of the problem.

Cor
 
Hi,

If you are just looking to check the data stored in the database use
the oledb dataprovider to open the database.

Dim strConn As String

Dim strSQL As String

Dim da As OleDb.OleDbDataAdapter

Dim conn As OleDb.OleDbConnection

strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"

strConn &= "Data Source = Northwind.mdb;"

conn = New OleDbConnection(strConn)

da = New OleDbDataAdapter("Select * From Categories", conn)

da.Fill(ds, "Categories")



Ken

----------------------------

Hi,

I want to open .mdb file from vb.net and check fields in few forms,
but I don't want to use the MSAccess COM object because customer might
not have access installed on the machine.

Where can I find more information about access file structure or is
there any third party tool that I can use which doesn't require
access?

Thanks
 
I don't care much about the data in the form. What I need to know is
how many text boxes they have on the form and what is the size (and
position) of those text boxes. I then need to create a log file.
Which will be somewhat similar as following:

Form Name: Customer
Field1: txtName, 10, 15, 24, 50 'where 10 is the left position, 15 is
the top position, 24 is the height and 50 is the width of field named
txtName
Field2: txtAddress, 10, 40, 24, 100
Field3: txtPhone, 10, 70, 24, 50

Form Name: Orders
Field1: txtOrderNumber, 10, 15, 25, 50
Field2:

You got the point?

Thanks
 
Thanks but this requires ACCESS on client's machine and I can't have that.

Any body else?

Thanks
 
Hi Sehboo,

I wrote kip and egg, and used dutch for chicken.

Why you want to see what MS access form there is on a client computer when
he has no MS Access?

Cor

Cor
 
On 22 Jul 2004 09:07:22 -0700, (e-mail address removed) (Sehboo) wrote:

¤ Hi,
¤
¤ I want to open .mdb file from vb.net and check fields in few forms,
¤ but I don't want to use the MSAccess COM object because customer might
¤ not have access installed on the machine.
¤
¤ Where can I find more information about access file structure or is
¤ there any third party tool that I can use which doesn't require
¤ access?

No. If you need to look at Access Forms and other Access specific objects the only method available
is automation.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top