how to import access 5 to 6 access tables into vb using vb code.......

[sumukha1]

help me in accessing MS access tables by vb ....let me kno the steps in detail ........ I ve around 5 to 6 tables created in access and using vb 6.0 as front end now i need to access these tables and display it once the user strikes the command button so please let me know how to do it with code .



Thanks in advance...

 

[johnwm]

Hi

Welcome to Tek-Tips. Read faq222-2244 carefully to see how these forums work.

Then look up ADO in your VB help files. When you have a more specific question post back and we will try and help.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[BobRodes]

<let me kno the steps in detail

Nope, sorry, not willing to go to all that trouble. I'm a very busy man, after all. However, I'll narrow things down a bit. To access a table, you'll need to make a connection to it. You'll need to get the result back in a recordset. So, you need to get a connection object and a recordset object. You can do this by using a component called ADO. Read up on ADO as johnwm suggests. However, concentrate on the Connection and the Recordset objects, don't worry about the others just now.

And quit reposting to see if someone else will write your code for you.

Bob

 

[JoeAtWork]

Every VB programmer should have at least one good ADO reference book in his library.