ADOX 2.1 library file - where is it??

[Guest]

Hello
i have builded a very symple application on Access2000 to be used to collect data for a university research
I would like to deliver it with references settled, so that if we plan to make some more improvement (and we will do), I will build an external database that using ADO and ADOX wll make changes in the one i'm going to deliver
On my system i have also OfficeXP and I have downloaded the MDAC2.8. So my newst library is 2.8, and i have them all 2.7, 2.6... but surely my clients dosen't have it.
This is the reason why I would stay on the 2.1 so i'm pretty sure that the application will work properly
Looking at "reference" in VBE tools menu, i found only Microsoft Activex Data Object 2.1.... where is ADOX...2.1 version
I can find only
Microsoft ADO ext. 2.7 for DDL and Security...where is the Microsoft ADO ext. 2.1 for DDL and Securit
They probably have it, but mine?

Thank
Nic

 

[M.L. Sco Scofield]

Take a look at
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Hello,
i have builded a very symple application on Access2000 to be used to

collect data for a university research.

I would like to deliver it with references settled, so that if we plan to

make some more improvement (and we will do), I will build an external
database that using ADO and ADOX wll make changes in the one i'm going to
deliver.

On my system i have also OfficeXP and I have downloaded the MDAC2.8. So my

newst library is 2.8, and i have them all 2.7, 2.6... but surely my clients
dosen't have it.

This is the reason why I would stay on the 2.1 so i'm pretty sure that the

application will work properly.

Looking at "reference" in VBE tools menu, i found only Microsoft Activex

Data Object 2.1.... where is ADOX...2.1 version.

 

[Guest]

thanks...but i need some more quickly useful info

 

[M.L. Sco Scofield]

I don't understand your comment.

A link to download the old MDAC files was on the page I sent you.

What else are you looking for?

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Guest]

Sorry... i'm italian so i don't have lots of words i can use. What i meant was that i need something easy to understand (and to do!) whan i went to the page you linked i...scared!!! But i'm still trying to read anything and well understand the contents
I just was wondering why downloading MDAC2.8 had deleted all previous version of ADOX library from my system. I can see the olds ADO library but not the ADOX one. Is this something usual or what
Any way REALLY THANKS and please accept all my apologizes if i seemed so rude
Nico

 

[Guest]

Hello
still here... i have read the article and it seems that i cannot install MDAC2.1 because i'm running WindowsXP, which can rollback only into 2.7
I'm wondering...if i'm developing an application on my system (windowsXP) and i need to use ADOX in code, i can only reffer to adox 2.8? And why i can reffre to ADO 2.1, ADO 2.5...? (which i can see in the reference windows)
How can i make my application working on a computer that the only thing i now is that has Office2000 (so i suppouse it has at least 2.1 as ADO and ADOX)
I have Developer, so I know that usin the PDW i can choos which MDAC to be delivered, But i can't us it right now!!! I'm just creating i simple .mdb (1form with code behind) that should fix few problems a client is having on his database. So i would send this .mdb by email and when he open it makes few changes on his database (and i need to reference ADOX to make changes to his table)
This thing is going to be overwhelming my capacity!!!!!!!!
Thanks for any help/suggestion

 

[Douglas J. Steele]

Consider using Late Binding.

With Late Binding, you don't set a reference. Rather, you declare the object
as an Object, and then use CreateObject to instantiate it.

In other words, rather than

Dim catCurr As ADOX.Catalog

Set catCurr = New ADOX.Catalog

you'd use

Dim catCurr As Object

Set catCurr = CreateObject("ADOX.Catalog")

That way, you're not tied to a specific version: your code will use whatever
version is present on the workstation (it will fail on the CreateObject
statement if no version is present)

Tony Toews has some information on Late Binding (including other links) at
http://www.granite.ab.ca/access/latebinding.htm

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,
still here... i have read the article and it seems that i cannot install

MDAC2.1 because i'm running WindowsXP, which can rollback only into 2.7.

I'm wondering...if i'm developing an application on my system (windowsXP)

and i need to use ADOX in code, i can only reffer to adox 2.8? And why i can
reffre to ADO 2.1, ADO 2.5...? (which i can see in the reference windows).

How can i make my application working on a computer that the only thing i

now is that has Office2000 (so i suppouse it has at least 2.1 as ADO and
ADOX).

I have Developer, so I know that usin the PDW i can choos which MDAC to be

delivered, But i can't us it right now!!! I'm just creating i simple .mdb
(1form with code behind) that should fix few problems a client is having on
his database. So i would send this .mdb by email and when he open it makes
few changes on his database (and i need to reference ADOX to make changes to
his table).

 

[M.L. Sco Scofield]

Nico,

You weren't rude, I just didn't understand your comment.

The direct link is
http://www.microsoft.com/downloads/...75-dba1-4165-a7ee-56583e564afc&DisplayLang=en.
(You might have to copy and paste this link if line wrapping breakes it.)

Doug had a good idea with the late binding. The only problem with that is
that you will give up Intellisense while you are writting code. Like Doug
suggested, take a look at Tony's page that he gave you the link for.

Also, I'm not sure, but I beleive the Italian Access group is
microsoft.public.it.office.access.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Sorry... i'm italian so i don't have lots of words i can use. What i meant

was that i need something easy to understand (and to do!) whan i went to the
page you linked i...scared!!! But i'm still trying to read anything and well
understand the contents.

I just was wondering why downloading MDAC2.8 had deleted all previous

version of ADOX library from my system. I can see the olds ADO library but
not the ADOX one. Is this something usual or what?

 

[Guest]

Many thanks

Is it true that if I make a reference to a library, user should have the same library in the same location as i have on my system, where a developed the application

Thanks again!
Nico

 

[Douglas J. Steele]

Yes, if you refer to a library, your users must have the same version of the
library in the same location. If not, you will likely develop a problem with
the References which will mean that any function contained in any referenced
file (not just the one that's missing) may not be available. The most common
symptom is that VBA functions such as Format or Date stop working.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Many thanks!

Is it true that if I make a reference to a library, user should have the

same library in the same location as i have on my system, where a developed
the application?