references

[Leslie]

reference hell

I have created a database using windows xp and access 2003 with a access
2000 format. I have about 13 users running the application. One user gets a
run-time when excuting an email command and all users get a run-time error
when changing a combo box value. Doug Steele pointed me in the right
direction for checking run-time version and I ran the version checker on
machines having the problems, it appears their on the same versions. I also
checked everything in the startup so I could go to their machine and try to
get to the Tools to see their references. That did not work. Now, I have
created a shortcut pointing to the database I created and used the /runtime
in the target to open a copy of this database using the runtime only. I can
now see the users problems because I'm getting the errors opening db with
runtime only. I have went into the main db again and unchecked a reference
to "Microsoft ActiveX Data Objects 2.1 Library" and then re-opened db using
runtime and continued to get the errors. The following are the references
checked in main db:

Visusl Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library

Can anyone tell me what references I should have checked in order to
continue developing db in 2003 WinXP using 2000 format and 2000 runtime?

 

[Ed Metcalfe]

reference hell

I have created a database using windows xp and access 2003 with a access
2000 format. I have about 13 users running the application. One user
gets a
run-time when excuting an email command and all users get a run-time error
when changing a combo box value. Doug Steele pointed me in the right
direction for checking run-time version and I ran the version checker on
machines having the problems, it appears their on the same versions. I
also
checked everything in the startup so I could go to their machine and try
to
get to the Tools to see their references. That did not work. Now, I have
created a shortcut pointing to the database I created and used the
/runtime
in the target to open a copy of this database using the runtime only. I
can
now see the users problems because I'm getting the errors opening db with
runtime only. I have went into the main db again and unchecked a
reference
to "Microsoft ActiveX Data Objects 2.1 Library" and then re-opened db
using
runtime and continued to get the errors. The following are the references
checked in main db:

Visusl Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library

Can anyone tell me what references I should have checked in order to
continue developing db in 2003 WinXP using 2000 format and 2000 runtime?

Microsoft Access 11.0 Object Library is the one that will be giving you
problems I think. This should be set as Microsoft Access 9.0 Object Library
if your users have Access 2000 runtime on their machines.

The only way I am aware of to rectify this is to open your database in the
full version of MS Access and change the reference to the earlier version
before distributiing it to your users.

Ed Metcalfe.