X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Set Database Error In Excel VBA, Office 2013    
post Oct 11 2018, 09:52 AM

Posts: 197
Joined: 16-August 12

Hi all. I updated an Access database form an older version and it now has the .accdb extension versus the .mdb.

I updated the VB code in Excel where it's pointing to the database but getting an error on the following bolded section. Thinking it's because I converted to .accdb and it should be ADO instead of DAO but not sure what the proper code would be?

idrive = "\\cdtvnas13\ops"
dbname = idrive & "\VERIFY1\DDDSUP3.ACCDB"
Set db = DAO.DBEngine.Workspaces(0).OpenDatabase(dbname)

Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    6th August 2020 - 08:15 PM