MDE file and references

[Joe Williams]

I have a file that I am distributing as an MDE file. However, I have used a
fair amount of code that requires the Visual Basic for Applications,
Microsoft Access 10.0 Object Library, and the Microsoft DAO 3.6 Object
Library.

Now, I am assuming that the VBA an the Access 10.0 libraries are standard,
even on a client running the runtime version of access.

My quesion relates to the DAO library - How do I ensure that the client can
open and ru the MDE file, given that they may be running a normal or runtime
version of access? becuase if they have an MDE, they cannot set references
themselves thorugh access, especially if they are using the runtime.

How do I make sure the end user does not have any problems with the DAO
reference?

Thanks

Joe

 

[Rick Brandt]

I have a file that I am distributing as an MDE file. However, I have used a
fair amount of code that requires the Visual Basic for Applications, Microsoft
Access 10.0 Object Library, and the Microsoft DAO 3.6 Object Library.

Now, I am assuming that the VBA an the Access 10.0 libraries are standard,
even on a client running the runtime version of access.

My quesion relates to the DAO library - How do I ensure that the client can
open and ru the MDE file, given that they may be running a normal or runtime
version of access? becuase if they have an MDE, they cannot set references
themselves thorugh access, especially if they are using the runtime.

How do I make sure the end user does not have any problems with the DAO
reference?

The runtime will have DAO automatically.

 

[Joe Williams]

Thanks Rick,

how about normal versions of access? Will I have to instruct the users to
set the reference manually? And if so, how woud they do that if you cannot
open an MDE file code window to set the reference?

Thanks

Joe

 

[Alex Dybenko]

Hi Joe,
any installation of access have DAO, so you dont need to care about
reference, it should be there
but, there is one problem (bug), that during install DAO is not registered.
then you have to do this manually, using regsvr32.exe

 

[Rick Brandt]

Thanks Rick,

how about normal versions of access? Will I have to instruct the users to set
the reference manually? And if so, how woud they do that if you cannot open an
MDE file code window to set the reference?

You never have to reset the references. They are part of your file and they
will be "set" on any computer where you copy the file. The issue is whether the
library being referenced exists on each PC and whether it is properly
registered. So in your case the fix would be to make mods to the PC, not your
MDE file.