Having Trouble Developing Application For Friend

[Guest]

I have developed an Access 2007 database for a friend. All Functions /
Macros / forms, etc work fine on my PC. When I send him the finished version
(via e-mail), no code runs on his PC. I went to his home (about an hour
away) to help him get the application up and running last night. After about
an hour playing with the (new to me) security features of Access 2007, I
created a new database on his PC and imported everything from the version I
sent him to the blank version on his desktop. Now everything works fine.

My question: How do I develop code on my PC that I can give to another user
that will work on their PC? Can somebody provide a link that describes how a
developer can write an application to be used on other user's PC's? I'd also
like to provide support in the future by creating forms, etc. and don't think
that simply re-importing all objects is a good way to do this long term.

Thanks for your help!

 

[Allen Browne]

First thing would be to make sure the end user has specified their database
folder as a trusted location:
Office Button | Access Options | Trust Center | Trusted Locations

Beyond that, you will want to use minimal library references:
http://allenbrowne.com/ser-38.html

Before releasing the final product, it's a good idea to compact, decompile,
compact, and compile.

 

[Guest]

We did put the database in a directory defined as a trusted location.
Furthermore, to my knowledge, I did not include any reference to a library
that isn't standard with Office 2007. (I assume both of our Office
Professional versions reference the same libraries - but I guess you should
never make any assumptions! Some of the code that would not execute is
very basic and one would think not be included in a special library (like
close a form and/or go to a record based on a drop-down-menu option). Again
- everything worked fine when we imported all of the forms from one database
to the next, so I'd really like to know what we were doing wrong. Does
anybody have any insight? Thanks for the reply!

 

[Allen Browne]

How did you go with the decompile?

 

[Guest]

Thanks for taking the time to write and help me out. Your first reply
actually contained the solution to my issue. For some reason, there was a
library that was referenced on my PC that wasn't available on his. I took
your suggestion and use only the minimal libraries for Access 2007 - and now
everything works great. Thank you for taking the time to help us out here!

Doug