ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Access Error Messages when running Access through Excel (https://www.excelbanter.com/excel-programming/313328-getting-access-error-messages-when-running-access-through-excel.html)

Dkline[_2_]

Getting Access Error Messages when running Access through Excel
 
Here's the relevant code:

Dim IllustrationWB As Workbook
Dim InputSheet As Worksheet
Dim BDCodesWB As Workbook
Dim BDSheets As Worksheet
Dim BDCodesPathFile As String
Dim lngLastRow As Long
Dim lngLastRowCodes As Long
Dim strBDCode As String
Dim strBDCodes As String
Dim objAccess As Access.Application

Sub ImportBDCodes()
'start access and run code which exports query results
On Error GoTo errAccessFail
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase
"\\Server03\shared\Agreements\AgreementInventory.m db", True

For some reason this is now causing an error in Access when it has been
working before for months. What I'd like to get is the Access error number
and description. How can I do that?




All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com