+ Reply to Thread
Results 1 to 4 of 4

Add Microsoft Access Object Library reference without installed Microsoft Access

  1. #1
    Registered User
    Join Date
    07-18-2014
    Location
    glasgow
    MS-Off Ver
    2013
    Posts
    2

    Add Microsoft Access Object Library reference without installed Microsoft Access

    Hello

    I'm now developing excel program using VBA and connect to MS Access database. I can add Microsoft Access Object Library reference properly in my own computer.
    My Problem is this excel program will be used in several computers in the office which has no MS Access installed. I tried to run this program on company's computer. It did not work and show this message. ATTACH]333164[/ATTACH]

    Please advise what should I do. Do I need to install MS access on every computer (both of client and server)?

    P.S. I'm developing the program using MS Office 2010 but the company is using 2013 version

    Thanks
    Nichcha P.[
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Add Microsoft Access Object Library reference without installed Microsoft Access

    What is it you're trying to do? For data retrieval Use ADO, Microsoft ActiveX DataObjects or the Excel Wizards.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    07-18-2014
    Location
    glasgow
    MS-Off Ver
    2013
    Posts
    2

    Re: Add Microsoft Access Object Library reference without installed Microsoft Access

    data retrieval and also modification using DAO

    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Add Microsoft Access Object Library reference without installed Microsoft Access


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I reference Microsoft Outlook 15.0 Object Library?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-11-2019, 06:25 AM
  2. Microsoft Outlook 14.0 vs 15.0 Object Library
    By Puff_N_Stuff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2014, 12:48 PM
  3. Microsoft HTML Object Library
    By akotronis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 01:07 AM
  4. Excel won't allow me to add reference to Microsoft outlook object library
    By Skyla157 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2013, 07:38 PM
  5. [SOLVED] Unable to access GridLines in Microsoft Graph Object [URGENT]
    By usamaalam in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-07-2005, 02:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1