Late bindings

[Bresart]

Hi, i need to make compatible my Access database with any version of Access, and any version of the .dll files used in the database (i think that if that is accomplished the database will be compatible with any Windows Operative System).

How to make the late bindings for that purpose?

Thanks for any help given.

 

[dhookom]

I google "Access VBA Late Binding" and got lots of hits including Tony Toew's Late Binding in Microsoft Access

Duane
Hook'D on Access
MS Access MVP

 

[Bresart]

Thanks, dhookom.

I remember a very detailed article in Microsoft KB, it's which i was interested in. I have searched in Microsoft KB "Late binding" and haven't found the article. I found the link in one of these forums, so i have searched "late binding" and there's hundreds of records.

I would need some help for finding this article.

Thanks.

 

[dhookom]

Tony has 5 links at the bottom of his page. Did you check any of these?

Duane
Hook'D on Access
MS Access MVP

 

[Bresart]

No, none of them are the article i refer to.

I have read something on these articles and i am more confused about late binding. For using Access and without interaction with other Office application, do i need to perform late binding? And in what case early binding? Is there any detailed article about early and late binding? All results i have seen in google are confusing or incomplete.

Thanks.

 

[dhookom]

If all of those articles aren't the ones you want and they don't explain late binding well enough, I doubt I can add anything.

Maybe if you tell us what dll's your code might use we could provide some advice.

Duane
Hook'D on Access
MS Access MVP

 

[JoeAtWork]

i need to make compatible my Access database with any version of Access

Late binding won't accomplish that. If you have an MDB file in Access2000 format, it can't be opened by Access97, period.

I pretty much use late binding only when referencing MS Office apps. Generally it is better to use early binding.



Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[Bresart]

Thanks dhookom, JoeAtWork.

dhookom, the article i'm referring is possibly an article in this forum, not in Microsoft KB. It was very detailed, it could be followed step by step.

JoeAtWork, i'm working with Access 2000. I understand that if i use early binding i make the application compatible with earlier versions (just 98 are hardly still used). But if i use late binding i will make the application compatible with later versions: 2003, XP, 2007 (probably i forget one), all them commonly actually used. So, to use late binding wouldn't be more recommended?

 

[Bresart]

dhookom, i have sarted reading the article you pasted: Tony Toew's Late Binding in Microsoft Access.

The third paragraph says:

"You will only encounter an error when your app executes lines of code belonging to the automation app which isn't installed".

Can you say me what is the automation app? A reference?

Which is the relationship between references and late binding?

Thanks.

 

[dhookom]

The "automation app" might be Outlook or Excel or Project or other application that you are attempting to use from within Access.

Within your Access code, you can set a reference to the Excel object library. This is early binding and is generally tied to a specific version of Excel. You can use the installed Excel object library (whatever version) if you don't set a reference to Excel and instead use late binding.

Duane
Hook'D on Access
MS Access MVP

 

[Bresart]

Thanks dhookom.

I don't totally understand these contents, is there any recommended book about that or that contains detailed explanations about it?

 

[dhookom]

I'm not aware of any books that you couldn't find on your own using Google or Amazon or other web search.

Duane
Hook'D on Access
MS Access MVP

 

[Bresart]

Thanks dhookom.

 

[jeffshex]

I'm curious about this as well.
I read up on the links and I understand the concept, but for example, I do not know how to change the coding using the object. I need to watch for outlook 2003 and 2007 versions.
This code works with early binding

Dim outMail As Outlook.AppointmentItem
Me.Refresh
Set outMail = Outlook.CreateItem(olAppointmentItem)
outMail.Subject = [Forms]![frmCM]![txtFullName]
outMail.MeetingStatus = olMeeting
outMail.Start = Me.ApptStartDate & " " & Me.ApptStartTime
outMail.End = Me.ApptStartDate & " " & Me.ApptEndTime
outMail.Body = "Meeting Type: " & Me.ApptType
outMail.Send

I looked at

http://www.dicks-clicks.com/excel/olBinding.htm

for more info.