What is early binding and late binding


Board Regular
I am new to these concepts.
Not requesting for exact answers.
You may also help me with useful links for these two.

I know Google will help, but trying to seek help from experts here.
Also, I have another question here.
Not sure if I can merge it here only.

How does early binding or late binding affects compatibility when moving from older access version to Office 365.
Please pardon my ignorance, I am novice to access and need to work on these issues.
Last edited:


Board Regular
I have few access files with me.
These are of older versions
Now these are supposed to work in Office 365.

For this compatibility scenario, what are the points that I should check.
I do not know what will get affected in this migration.
Can experts here guide me in this please.

I am new to access and do not know what are the things that I should check in such scenario.
Last edited:


Board Regular
Hi welshgasman sir, thanks for the help. Sorry for late reply.
Am checking this and will revert with details. Have a nice day ahead. :)


MrExcel MVP, Moderator
Simply put:
Late binding = declaring obejct variables as Object.
Early Binding = declaring object variables as a specific type.


Board Regular
I might be asking silly or wrong question.Apologies.

I have few such examples in my code.
Am not able to understand if these relates to early binding, late binding or none.

Can anyone of please help me understanding these.
Looking at below examples how to identify if any of these relates to early binding or late bindings.

Or is it even possible to identify by looking at these isolated lines from the code.

Dim Q_EXECUTE As QueryDef
Set Q_EXECUTE =CurrentDb.QueryDefs("QRY_GetServices")

Dim dbSource As DAO.Database
Set dbSource = OpenDatabase(SourceDatabase)

Dim oDB As Object
Set oDB = CurrentProject

To give you an overview, my basic task isconvert all the early binding items from the code to late binding.
Last edited:


MrExcel MVP, Moderator
The first two pairs are early binding, the last is late binding (declared as Object).


Board Regular
Hi RoryA sir, thanks a lot for the help.
Have a nice day ahead. :)

One question , if you get time.
Is it possible to convert all the early binding items to late binding.
Or we have limitations there too.


MrExcel MVP, Moderator
Yes it is, though there is no point for native Access objects like QueryDef.

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...