By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,552 Members | 905 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,552 IT Pros & Developers. It's quick & easy.

MS Access from vb.net

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a

"Sehboo" <ma*********@hotmail.com> wrote in message
news:7b*************************@posting.google.co m...
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?


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?
Nov 20 '05 #2

P: n/a
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
Nov 20 '05 #3

P: n/a
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

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

"Sehboo" <ma*********@hotmail.com> wrote in message
news:7b*************************@posting.google.co m...
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
Nov 20 '05 #4

P: n/a
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
"Cor Ligthert" <no**********@planet.nl> wrote in message news:<e3**************@TK2MSFTNGP10.phx.gbl>...
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

Nov 20 '05 #5

P: n/a
Hi Sehboo,

The only thing I have is a link for you.

Access Automate
http://support.microsoft.com/default...b;EN-US;317113

However I hope this helps a little bit?

Cor
Nov 20 '05 #6

P: n/a
Thanks but this requires ACCESS on client's machine and I can't have that.

Any body else?

Thanks

"Cor Ligthert" <no**********@planet.nl> wrote in message news:<#w**************@TK2MSFTNGP10.phx.gbl>...
Hi Sehboo,

The only thing I have is a link for you.

Access Automate
http://support.microsoft.com/default...b;EN-US;317113

However I hope this helps a little bit?

Cor

Nov 20 '05 #7

P: n/a
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
Nov 20 '05 #8

P: n/a
On 22 Jul 2004 09:07:22 -0700, ma*********@hotmail.com (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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.