accdb

  1. J

    Difference between ACCDB vs ADODB database

    What is the difference between an ACCDB database and a ADODB database. I use Access 2016. My current database is ACCDB. How can I convert it t ADODB.
  2. S

    access 2013 vba relink back end tables if not found

    good afternoon, I am looking for a way of relinking back end tables if the links get broken. back end file name changes sometimes. my links are not just a back end single accdb, there are 3 accdb's and 2 excel xlsx or xlsm files. I used access to link them, however when updated back ends...
  3. S

    Silently Run Macro in Background

    Hi guys, So this is what I'm trying to do. I've created a workbook that pulls data from an Access query, updates the data from an external source, and then creates a text file (with some dalay for the data to update) that will be imported and rewrite current values in the Access database. In an...
  4. V

    Send Access Table Using VBA code by outlook

    Dear All Gurus, I have a access having with table name "Daily_RTO" i want to send it on email "vishan.uk@gmail.com" by access VBA code using outlook email system. Im new to VBA codes, pls suggest me full code of sending Access Tables and Select Queries to given email addess. Thanks & Regards...
  5. U

    Using rcount after connecting to a database.

    I have a routine that calls a function that opens an Access accdb file but I cannot get a row count from the database. Sub DBMgr() Const XMLSht As String = "Imported XML" 'XML Import Worksheet Const MDB As String = "DB.accdb" 'Primary Database...
  6. C

    Version Compatibility 2007 <-> 2010 - REALLY?!?!?!

    Ok, so I have an access 2010 database (accdb) I'm using as a front end to pull data from a mysql server and an oracle server (linked tables). I build queries and reports for a user who will run reports from this database who has access 2007. I have 2010. I have a reasonably straightforward...
  7. B

    Run-time error 3706 - Provider not found

    Hi Guys, I am building an application for Excel 2003 which pulls data from an Access 2007 database using an ADO connection. I have successfully tested this using Excel 2007 in 2003 compatibility mode using : strPathName = ThisWorkbook.Path MyConn = strPathName & "\Test.accdb" Set cnn = New...

Some videos you may like

This Week's Hot Topics

Top