access distribution and library reference problom

[balu]

dear friends,
i am developing application in access2003 and before distribution converting
it to access97 format just to over come the problem of library reference /
functions , which may avoid run time errors. is there any sophisticate way of
distributing my application please ( with out extra expenses of purchasing
run time of 2003).

 

[DrEvil]

I'm not sure I get the developing in 2003 and then downgrading to 97 but you
need the Access runtime 2003... well, in any case I would recommend that you
develop your database in 2007 (or just upgrade it when developed in 2003), in
2007 you can download runtime extensions free of charge.
http://msdn.microsoft.com/en-us/office/bb229700.aspx
It works well, I did this with one of mine clients and works perfectly.

good luck

Amir

 

[Tony Toews [MVP]]

i am developing application in access2003 and before distribution converting
it to access97 format just to over come the problem of library reference /
functions , which may avoid run time errors.

What problems are you having with library reference functions?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[balu]

well sir,
i am referencing office11 object library , ms excel11, and outlook11 object
library. because i use all of them, when ever i am putting it to work on a
computer which doe's not have thees library's ( even though the computer may
have office 2000 / 2003 but with object library10) automatically my code
halts with error .
hence i am converting it to 97 format whether it will avoid these errors or
not still i am not 100% shure, kindly advise

 

[Douglas J. Steele]

Converting to Access 97 format certainly won't help if you've got references
to Office 11: Access 97 will only work with Office 8

And in my opinion, you shouldn't have references to Excel 11 and Outlook 11:
you should use Late Binding instead. Tony's got an introduction to the topic
at http://www.granite.ab.ca/access/latebinding.htm (Depending on why you
have the Office reference there, you could probably use Late Binding for it
as well).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Tony Toews [MVP]]

i am referencing office11 object library , ms excel11, and outlook11 object
library. because i use all of them, when ever i am putting it to work on a
computer which doe's not have thees library's ( even though the computer may
have office 2000 / 2003 but with object library10) automatically my code
halts with error .
hence i am converting it to 97 format whether it will avoid these errors or
not still i am not 100% shure, kindly advise

Doug already gave you the answer. The same one I would've given you.
But I do wonder why you need the Office 11 object library.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/