Database will not work on another pc?

[AJ]

I have a database (with some VBA modules) that I gave to someone else to look
at. The databse works fine on my pc and I have installed in on three other
boxes and they all worked fine.
His pc, for some reason, first give a "Compile error" when he starts to run
the application. I think asked him to look at the module (to see if I could
help him debug) and he gets a message that says the module is locked? Plus
under tools the references is grayed out?
Anyone have any ideas whay this would happen on a certain pc? All of the
pc's are running XP. It is a 2003 database running on office 03.
Thanks for your help.

 

[John W. Vinson]

I have a database (with some VBA modules) that I gave to someone else to look
at. The databse works fine on my pc and I have installed in on three other
boxes and they all worked fine.
His pc, for some reason, first give a "Compile error" when he starts to run
the application. I think asked him to look at the module (to see if I could
help him debug) and he gets a message that says the module is locked? Plus
under tools the references is grayed out?
Anyone have any ideas whay this would happen on a certain pc? All of the
pc's are running XP. It is a 2003 database running on office 03.
Thanks for your help.

Did you give him the original .mdb file - or a .mde? In the latter, the module
would be compiled and not editable, and the references would indeed be locked
down.

John W. Vinson [MVP]

 

[AJ]

Hi John - No I gave him the original mdb file? Can it have anything to do
with the digital signature. I added on when I created the database but when
he goes into the visual basic editor, tools, there is NO digital signature
field??
Also when he opens the database, it does not prompt him telling him that the
database is from an unknown source. Any ideas??

 

[John W. Vinson]

Hi John - No I gave him the original mdb file? Can it have anything to do
with the digital signature. I added on when I created the database but when
he goes into the visual basic editor, tools, there is NO digital signature
field??
Also when he opens the database, it does not prompt him telling him that the
database is from an unknown source. Any ideas??

What version? What operating systems (on both machines)?

John W. Vinson [MVP]

 

[AJ]

John I am confused. We both have XP on our machines.
I have office 2003 but when I go to make an MDE file, it states that I need
to convert it to 2003 before I do that? If I have 2003 why would it have
created in 2000? I then convert to 2003 and I think that is why he is having
trouble on his pc because he has 2002?
I am a complete novice with all this stuff and am really confused as to what
to do. Any suggestions? Should I jsut tell him to upgrade to 2003? Would that
fix it? How come you cannot make an MDE in 2002 version?
Thanks a ton John!

 

[John W. Vinson]

John I am confused. We both have XP on our machines.
I have office 2003 but when I go to make an MDE file, it states that I need
to convert it to 2003 before I do that? If I have 2003 why would it have
created in 2000? I then convert to 2003 and I think that is why he is having
trouble on his pc because he has 2002?
I am a complete novice with all this stuff and am really confused as to what
to do. Any suggestions? Should I jsut tell him to upgrade to 2003? Would that
fix it? How come you cannot make an MDE in 2002 version?
Thanks a ton John!

Access 2000, 2002 and 2003 all default to creating databases in 2000 format.
There is also a 2002/2003 format (they are identical).

There is a quirk with MDE's though: although 2002/3 can and will create mdb's
in 2000 format, they will NOT create mde's in that format. You must convert
(using tools... convert on the menu) to 2002/3 format before making the mde.

I really don't think this is why your friend can't use the database though! If
it's a mdb, and if they have full retail Access, they should be able to do so;
there is something else going on.

John W. Vinson [MVP]