What is early binding and late binding

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
Hi
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:

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
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:

BizBoy

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

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,687
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Simply put:
Late binding = declaring obejct variables as Object.
Early Binding = declaring object variables as a specific type.
 

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
Hi,
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:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,687
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
The first two pairs are early binding, the last is late binding (declared as Object).
 

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
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.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,687
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Yes it is, though there is no point for native Access objects like QueryDef.
 

Forum statistics

Threads
1,089,333
Messages
5,407,642
Members
403,156
Latest member
Fahad Saleem

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top