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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top