Results 1 to 4 of 4
  1. #1
    Dana is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    4

    Using Microsoft Access 2013 in Microsoft Access 2010


    I created a database using Microsoft Access 2013. When I distributed it to the users, I found out they only have Access 2010. When they try to open the database, they get an error stating that they are missing a reference called MSOPRIV.DLL Version
    2.7. If they ignore the error, the database will open, but the automation between other Office products (Word and Outlook) do not work. Is there a way to embed the required references in the database and/or (maybe preferably) convert a 2013 Access database to a 2010 version? I didn't think it was necessary since they both use the .accdb extension, but obviously I was wrong.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    what's your code look like

    you are probably using early bindings rather than late bindings. What are the references you're using (open your vb window and click tools/references).

  3. #3
    Dana is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    4
    I don't have any specific code that names the references, but I think they are used by Access. Here are the references used:
    Visual Basic for Applications
    Microsoft Access 15.0 Object Library
    OLE Automation
    Microsoft Office 15.0 Access database engine Object Library
    Microsoft Outlook 15.0 Object Library
    Microsoft Outlook View Control
    Microsoft Word 15.0 Object Library
    Microsoft Office.NET Private Object Library

  4. #4
    Dana is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    4
    I just realized you meant the code I use to open the other Microsoft Office Products. Here is the beginning of what I use to open Outlook:
    Private Sub Command24_Click()
    Dim objOutlook As Outlook.Application
    Dim objOutlookMsg As Outlook.MailItem
    Dim objOutlookRecip As Outlook.Recipient
    Dim objOutlookAttach As Outlook.Attachment
    Dim objOutlookFile As String


    Set objOutlook = CreateObject("Outlook.Application")
    Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
    With objOutlookMsg
    Set objOutlookRecip = .Recipients.Add(Me!POCEmail)
    objOutlookRecip.Type = olTo

    And the beginning of the one used to open Word:
    Dim objWord As Word.Document
    Dim path As String
    path = CurrentProject.path
    Set objWord = GetObject(path & "\ROM Merge Template.docx")
    objWord.Application.Visible = True
    objWord.MailMerge.OpenDataSource _
    Name:=path & "\RM_PM_Management.accdb", _
    LinkToSource:=True, _
    Connection:="TABLE tblTempROM", _
    SQLStatement:="SELECT * FROM [tblTempROM]"
    objWord.MailMerge.destination = wdSendToNewDocument
    objWord.MailMerge.Execute
    objWord.Application.Documents(2).Close wdDoNotSaveChanges
    Set objWord = Nothing

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 10-06-2015, 09:12 AM
  2. Replies: 3
    Last Post: 05-12-2015, 07:41 AM
  3. Microsoft Access 2013 Web Control question
    By edanMimran in forum Access
    Replies: 13
    Last Post: 11-15-2013, 06:25 AM
  4. SQL Query challenge in Microsoft Access 2013
    By Bingfoot in forum Queries
    Replies: 5
    Last Post: 10-07-2013, 07:58 AM
  5. Replies: 1
    Last Post: 09-13-2011, 01:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums