Distributing/Moving Ap to another PC

[LeoDee]

As a volunteer, I developed an application on my home PC using XP and Access 2000. I copied the application to CD and then loaded it on my clients PC (Office 2000). The application copied as read-only which I changed.

I can not seem to get the applicaton to work. The first error message I get is: Compile Error - Can't find project or library.

After this I can not seem to get the swithboard to load. When I go into FORMS and click on "switchboard", nothing happens. Also, when I bring up some of the forms and try to use them, I get errors in VB (i.e., DIM dbs as Database) will be highlighted in yellow.

Finally, I used the Active X Calendar10 in my application. It appears that the client has only Calendar9 and the calendar is unusable.

My questions are: (I do not have or can afford copy of Access Developer)

1. What step by step method would allow me to move my application to another PC as described above without these problems?

2. How can I overcome the calendar problem.

I am a relative newbie so answers should be at a newbie level.

Thanks for your help.....

 

[Autoeng]

I'm going to be shooting from the hip here so if I'm wrong I hope others with more experience will correct my guesses.

On your machine if you go into any module and select Tools-References you could select the Active X 10 control and get the directory location. Copy that file to you users machine and set the reference to it.

As far as the project or library error you could hopefully identify the missing component by again going into Tool-References and see if any are marked with "Missing". If not compare your selected references to their selected references. Make sure that they agree.

Hopefully this will take care of your problems. In the future I recommend copying and non-standard references to the same directory that the db is located in and setting the references on your machine to the new location. If you are able to load the db into the same location on the clients machine as long as you copy the same references to their machine as well the app should pick up their location.

There is also many utilities around to check for missing references. Look at www.rogersaccesslibrary.com under downloads for a sample db.

Good luck

Autoeng

 

[LeoDee]

Thanks for the quick response. I won't be able to get to the clients PC until after the holidays. In the meantime, lets see if I understand this.

I looked at my references and it shows the following as checked:

-Visual Basic For Applications
-MS Access 10.0 object library
-MS DAO 2.5/3.5 Compatibility Library
-OLE Automation
-MS VB For applications Extensibility 5.3
-MS Calendar Control 10.0

What I need to do is put my database on the clients PC and check to see if the references match those above. If any are missing, copy them to the clients PC with the correct path?

And, regarding the Calendar Control 10.0, I could place a copy of that in my database and change the reference path. When copied to the client PC, it would automatically pick it up.

Again, thanks...I would appreciate a confirmation that I am on the right track.

 

[Autoeng]

You got it for the most part. As for the calendar reference you would treat it the same as the others. You won't really be able to foolproof the reference until you install it on the clients LAN. Put the calendar reference in the same directory as the db. Update your reference location.

Autoeng

 

[LeoDee]

Thanks. I also am working with our local Senior Center and amdeveloping a small tracking system for their computer class students. I am having the same problem here. They are running Win98 and Access 2000.

I tried what you suggested regarding the calendar and that is working now. In a couple of days I will load in the other objects that are needed. It seems my XP version of Access 2002 is not very compatible with Access 2000 even though it says it puts out the database in 2000. I keep getting bombed off on the Win 98 PC.

Again, thanks for your help and if any more suggestions please send them on.

LeoDee