1. Windows Central Question's Avatar
    I have searched using google to find a specific answer with no luck. I keep getting error code 429 when trying to use DAO language "OpenDatabase" so I can use SQL Language to search various worksheets in one Excel 2013 Workbook. I am running Windows 7-64 and Office 2013 64-bit. From what I have read, it would appear DAO is not supported anymore by Microsoft, and even ADO doesn't look like it is looked favorably by the folks at Microsoft anymore. I really don't care if I can't use DAO anymore as long as if there is a method where I can use similar functionality to find specific records based on specific criteria, amend certain records, create other records, and move amongst records (i.e. .movefirst, .movelast, etc.). If there is a different VBA language that is usable for 64 bit versions of my software, I will learn it.

    I rather not use the workbook, worksheet functions and using IF-THEN statements going through the entire table trying to find certain "records" that match the criteria I am looking for. It works, but its tedious and I much rather use SQL type language.

    I realize using MS Access would be more appropriate, but I prefer using the Spreadsheet format. What I am trying to do is write a VBA program that converts certain cell values into a certain format to be converted to a csv file to upload to a website for my web-store. The file is my inventory sheet, with tons of calculations/formulas in it. I rather not use MS Access if I don't have to.

    Thank you for any help that can be provided!


    Ken L.
    06-05-2017 09:56 PM
  2. Daniel Velazquez1's Avatar
    Usually the 429 error is because of a missing VB dll in the Windows folder. You might be able to get the dll by installing the vb6 components.
    06-05-2017 10:30 PM

Similar Threads

  1. When will Cortana come to Sweden?
    By Robert Lindblad in forum Ask Dan!
    Replies: 1
    Last Post: 06-18-2017, 03:11 AM
  2. Has Microsoft plans to enhance Photos App ?
    By Samuel 444 in forum Ask Dan!
    Replies: 6
    Last Post: 06-10-2017, 10:14 AM
  3. Replies: 1
    Last Post: 06-06-2017, 10:50 AM
  4. decent tablet for business use
    By Windows Central Question in forum Ask a Question
    Replies: 2
    Last Post: 06-06-2017, 01:35 AM
  5. Getting an 'Ejection Error' when trying to eject my Window's Phone?
    By mtf1380 in forum General Desktop, Laptop & Tablet Discussion
    Replies: 0
    Last Post: 06-05-2017, 04:19 PM