Is opencurrentdatabase and opendatabase same?

[Malathi]

Hi,

Is opendatabase and openmcurrentdat abse same? This is used when there is a need to open a database through automation (like vb.net).

Ex:

Dim msMSAccess As Object
msMSAccess = CreateObject("Access.Application")
msMSAccess.OpenCurrentDatabase(ExePath)

Regards,
Malathi

[twinnyfo]

Malathi,

There are some differences. You should review these sites first:

MSDN OpenCurrentData base Method

And

MSDN OpenDatabase Method

This might give you the basic information you need.

[Malathi]

Thanks for the reply! Are the both methods used only to open the mdb files? If is it so then whats the method to open an mde file?

[NeoPa]

OpenDatabase gives you the ability to open a database and keep it in storage. Ordinary users of Access will not see this database as it is visible only to your project.

OpenCurrentData base specifically opens the database that the user has access to from within the Access interface. They're actually quite different beasts.

I believe both can handle MDE files just as well as MDBs, but you should probably check for yourself. The links have already been provided for you. There's very little point in our doing the work that you're fully capable of. We're here to help with things you may not know and that aren't as basic and easy as clicking on a provided link.