reference installation

[MaureenKLM]

I need to get an ACCESS 2002 reference onto a machine with Access 2000 - the
reference is "microsoft Access Object 10.0 library" - Is it safe to copy this
reference file from my machine (developed in Access 2002) to the user's PC
(Access 2000)? Anything I should be wary of?

THANK YOU!

 

[Chris Mills]

Whilst copying that reference will do no harm, it won't do much good either.

Access2000 should automatically change the reference to use "Microsoft Access
9.0 Object library".

Of course, you will either need to have the mdb in native A2000 format or
convert it. And you cannot use features not inherent to A2000.

Chris

 

[Douglas J. Steele]

You cannot copy it. Access 2000 will only work with Access 9.0, Access 2000
will only with with Access 10.0

However, there should be no need to worry: AFAIK, if your application was
created using Access 2000, so that it includes a reference to Access 10.0,
Access 2000 should automatically adjust.

 

[MaureenKLM]

Thank you Chris & Doug for your responses.

I've got a DB FrontEnd made in Access 2002 - I converted it down to Access
2000 but it still uses the "msAccess 10.0" reference (it did not
automatically adjust down to the 9.0 version used in Access 2000). I
compiled without error but there are of course elements that do not work
without the correct reference.

What are my options then? Get my client to upgrade to Access 2002 - or
reinstall Access 2000 on my machine and redevelop the FrontEnd in that?

 

[Chris Mills]

If it didn't automatically convert the reference, you can always change it
manually.

("automatic" doesn't always happen, goodness knows why)

If you compiled without error then all equired references are present. I
suspect that A2000 may automatically use the 9.0 Library even though the list
shows 10.0, but since it's hard to be certain I'd change the reference
manually if necessary.

The only difference between 9.0 and 10.0 can be later features of MS-Access.
Of course, you can't use features not supported in A2000, in A2000.

I must say, I prefer to develop in the earlier version if I want multiple
Access. Otherwise, you're continually worrying whether you have used some new
feature.

You can of course just get everyone on A2002. But I don't believe there are
any major problems sharing between A2000 and A2002, if it's in A2000 format. I
think even an A2000 mde is compatible (and with that, you can't change the
references but Access auto-changes the 9.0/10.0 reference, obviously)

Chris

 

[Chris Mills]

Um, I think conversions are always sensitive to subtle corruptions or "unclean
mdb's" if you like. The way around this is to do a full
decompile/compile/repair/compact before conversion, and possibly after.

Naturally, you should have backup copies to spare when doing these things.

Chris