How do I start an access database (mdb) from VB4 using OLE automation

How do I start an access database (mdb) from VB4 using OLE automation

Post by Larry da Pont » Mon, 19 Aug 1996 04:00:00



I could not find a good example in the Technet CD, this is an Access 2.0
database I am trying to open from VB4 - could not get Shell to do the job
for some reason.  Thanks for any ideas for example code.


-Larry

 
 
 

How do I start an access database (mdb) from VB4 using OLE automation

Post by Saul G. Be » Wed, 21 Aug 1996 04:00:00




>I could not find a good example in the Technet CD, this is an Access
2.0
>database I am trying to open from VB4 - could not get Shell to do the
job
>for some reason.  Thanks for any ideas for example code.


>-Larry

Hi Larry

Why not use OLE?  It works well enough with Word and Excel, although
I've never really tried it with Access.  I've got a booklet from
Microsoft which gives a whole bunch of examples of OLE code - email me
if you want some answers to specific questions.

Regards,
Saul

 
 
 

How do I start an access database (mdb) from VB4 using OLE automation

Post by harmhind » Fri, 23 Aug 1996 04:00:00


I have written the following code in Visual Basic 3.0 and it
successfully ran in Visual Basic 4.0.

' this defines the type of variable
Dim db as database

Set db=Opendatabase("the path and name of file")
             .
             .
             .
db.Close