Problems when using Vista and MDE files

[Rob Bunocore]

I have a database that I distribute to multiple users. All off the
users have the same version of Access 2003 (I purchased it and
installed it) but they have different versions of Windows, XP or
Vista.

I work with Windows XP and when I create and distribute the file as an
MDE file, the Vista users can not use it. It open but the code
doesn't work and they keep getting error messages about the function
not available or the Event Procedure is not valid, etc.

What I find strange is that if I distribute the MDB file to the Vista
users, it works fine. If I then create the MDB file on a machine
running Vista, it works fine. BUT if I take that Vista created MDE
file and move it to a machine running Windows XP, it doesn't work at
all.

Can anyone tell me what's going on with these files. I feel like it
has something to do with the References, but since I can't get in to
see the references in an MDE file, its hard to tell.

Right now I'm stuck creating two different MDE files, one on a vista
machine and one on an XP machine, and then distributing appropriately.

Thanks.

Robby

 

[Roger Carlson]

You're problem is almost certainly with references. Maybe you could try
setting (or re-setting) your references programmatically. I can't reproduce
the problem here, so I can't test this, but on my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"SetReferenceToDAO.mdb"
http://www.rogersaccesslibrary.com/download3.asp?SampleName=SetReferenceToDAO.mdb
which will programmatically set a reference to DAO if none exists. You
might be able to modify it to help here.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[aaron.kempf]

Good Stuff

of course.. DAO wasn't included in any version of Office or Windows
for _HOW_ many years?

-Aaron

 

[Roger Carlson]

I prefer to answer the question actually asked. Thanks.

--
--Roger Carlson
MS Access MVP


Good Stuff

of course.. DAO wasn't included in any version of Office or Windows
for _HOW_ many years?

-Aaron

 

[Arvin Meyer [MVP]]

In addition to Roger's comments, you might also check Vista permissions.
Vista highly restricts running of code without proper permissions.

 

[Rob Bunocore]

How do I check Vista Permissions?

 

[Arvin Meyer [MVP]]

How do I check Vista Permissions?

This might help:

http://paulstamatiou.com/2007/02/09/how-to-quickie-vista-permissions

 

[Arto Nyberg]

Good question is this a domain environment or standalone? Anyways every
changes you want to do is as a administrator( nice features in vista)..
Here is a link that wil help in the future..
http://lifehacker.com/software/vista/windows-vista-tip--disable-annoying-nee
d-your-permission-to-continue-prompts-230866.php