|
-
Nov 6th, 2003, 11:54 AM
#1
Thread Starter
Junior Member
trouble opening access database files through excel in macro
Attempting to open files in excel from Access database.
The first ones opens fine, but when it tries to open the second one, it tells me "you are trying to open a read-only database, or trying to open it from a read-only location, or your server is busy"
I click "Retry", and it works fine. Can I prevent this message from happening???
-----------------------------------------------------------
Code:
Workbooks.OpenDatabase Filename:= _
"T:\cash av\New Recon Project - Em\New Recon.mdb", CommandText:=Array _
("Dublin detail"), CommandType:=xlCmdTable
Set shtDetail = ActiveWorkbook.ActiveSheet
Workbooks.OpenDatabase Filename:= _
"T:\cash av\New Recon Project - Em\New Recon.mdb", CommandText:=Array _
("Dublin summary"), CommandType:=xlCmdTable
Set shtSummary = ActiveWorkbook.ActiveSheet
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|