Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: What is early binding and late binding

  1. #1
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default What is early binding and late binding

    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 by BizBoy; Oct 14th, 2019 at 09:00 AM.

  2. #2
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

    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 by BizBoy; Oct 14th, 2019 at 09:15 AM.

  3. #3
    Board Regular
    Join Date
    May 2013
    Posts
    665
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

    This explains it better than I could.
    From what you have mentioned so far, late binding woul dbe your choice and lose the vba intellisense.
    Alternatively develop in the same version.

    http://learnexcelmacro.com/wp/2018/0...-late-binding/
    Office 2007
    Access novice. Sometimes trying to give something back

  4. #4
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

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

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,970
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    6 Thread(s)

    Default Re: What is early binding and late binding

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

  6. #6
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

    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 by BizBoy; Oct 17th, 2019 at 07:39 AM.

  7. #7
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,970
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    6 Thread(s)

    Default Re: What is early binding and late binding

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

  8. #8
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

    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.

  9. #9
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,970
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    6 Thread(s)

    Default Re: What is early binding and late binding

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

  10. #10
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    104
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is early binding and late binding

    Thanks for the help RoryA sir !

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •