opening an instance of an Access database

[Robert Smith]

Hello,
I wish to open an instance of an access database from within my
vb.net code

I have the following code

Dim ObjAccess as object
Dim strdbname as string = "c:\\reports.mdb"

In vb6 I would say

objAccess = Createobject(strdbname,"access.application")

How would I do this in visual basic.net, surely it can't be that different.
any help would be appreciated.

Regards
Robert Smith

[Greg Burns]

>Dim strdbname as string = "c:\\reports.mdb"
VB does not use escape characters like C languages do

surely it can't be that different. :^)

Do you want to read/write to the database's tables? Or are you trying to do
something with the Access object model? Like display a report or something?

Greg
"Robert Smith" <Ro*********@discussions.microsoft.com> wrote in message
news:BF**********************************@microsof t.com... Hello,
I wish to open an instance of an access database from within my
vb.net code

I have the following code

Dim ObjAccess as object
Dim strdbname as string = "c:\\reports.mdb"

In vb6 I would say

objAccess = Createobject(strdbname,"access.application")

How would I do this in visual basic.net, surely it can't be that different. any help would be appreciated.

Regards
Robert Smith

[Paul Clement]

On Fri, 6 Aug 2004 10:43:01 -0700, Robert Smith <Ro*********@discussions.microsoft.com> wrote:

¤ Hello,
¤ I wish to open an instance of an access database from within my
¤ vb.net code
¤
¤ I have the following code
¤
¤ Dim ObjAccess as object
¤ Dim strdbname as string = "c:\\reports.mdb"
¤
¤ In vb6 I would say
¤
¤ objAccess = Createobject(strdbname,"access.application")
¤
¤ How would I do this in visual basic.net, surely it can't be that different.
¤ any help would be appreciated.
It's actually not very different than when using Classic VB:

ACC: Using Microsoft Access as an Automation Server
http://support.microsoft.com/default...b;EN-US;147816
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)