Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul M - 07 Jan 2006 10:49 GMT

Hello,
when I execute the code below I get the usual access message:

SECURITY WARNING----------------------------------

Opening "<filepath & name.mdb>"

The file may not be safe if it contains code that was intended
to harm your computer.
Do you want to cancel the operation?

CANCEL OPEN MORE INFO

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

Private Sub OpenDB(ByVal strMDBFullPath as string)

Dim appDatabase As Access.Application

appDatabase = New Access.Application()
appDatabase.OpenCurrentDatabase(p_strMDBFullPath, True)

...

End Sub

How can I detect if the user presses the CANCEl button? With the code
above if the user presses the CANCEl button the code throws an exception
on the line "appDatabase.OpenCurrentDatabase(p_strMDBFullPath, True)".

The code is VB .net and the database is 2003 but could be 97, 2000 etc.

Thanks in advance

Paul M.

Reply to this Message

TC - 07 Jan 2006 11:00 GMT

No to answer your question, but: do you really want to open that
database /in the Access user interface/? Or do you just want to open
it "behind the scenes", so you can get at the data within it?

If the latter, then, you need OpenDatabase - not OpenCurrentDatabase.

HTH,
TC [MVP Access]

Reply to this Message

m.posseth - 07 Jan 2006 14:05 GMT

I wonder what you are trying to do

do you want to retrieve data from the access database ?

if so this is not the way ( you propbaly have set a reference to the office
lib )

normally you access a access database by the oledb namespace

regards

Michel Posseth [MCP]

> Hello,
> when I execute the code below I get the usual access message:
[quoted text clipped - 31 lines]
>
> Paul M.

Reply to this Message

Cyril Gupta - 07 Jan 2006 15:03 GMT

Hello Paul,

You have cross-posted to a lot of groups.

Your answer is in your question. When the user presses Cancel you get an
error, so trap the error and use it.

Here's what you can do.

Try
Your Code
Catch ex as exception
do something with the exception
End Try

That should solve it for you Paul

Cyril Gupta

Reply to this Message

Paul M - 13 Jan 2006 13:58 GMT

> Hello Paul,
>
[quoted text clipped - 14 lines]
>
> Cyril Gupta

Hello Cyril,
thanks for that, I had already considered that but just wanted a more
elegegant way of doing ie testing a return value, that sort of thing.

Thanks
Paul

Reply to this Message