| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Opening Access Table in VBA
Greetings:
I have the following VBA code attempting to open a table in my ACCESS database: Sub GetLast30() Dim wksp As DAO.Workspace Dim dbs As DAO.Database Dim rst1 As DAO.Recordset Dim rng As Range Set wksp = DAO.CreateWorkspace("wksp", "admin", "", dbUseJet) Set dbs = wksp.OpenDatabase("TASS Alarms.mdb") Set rst1 = dbs.OpenRecordset("tblAlarmsCook") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error on opening file - pivot table | Excel Discussion (Misc queries) | |||
| When opening Excel - get Access (Read-Only) file and error | Setting up and Configuration of Excel | |||
| Pivot table error when Opening an Xml Spreadsheet from MS excel Xp | Charts and Charting in Excel | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Error opening recordset where table is empty (but has field names) - How do I avoid? | Excel Programming | |||
Threaded Mode
