ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dao.OpenDatabase gives me error when ... (https://www.excelbanter.com/excel-programming/272811-dao-opendatabase-gives-me-error-when.html)

Marek S.

Dao.OpenDatabase gives me error when ...
 


I've problem with DAO.OpenDatabase:

1.
strBaza ="c:\katalog a\e1.xls"
[dir name contains space]

Set db = dbe.OpenDatabase(strBaza, False, False, "Excel 8.0;")

is OK

But when

strBaza ="c:\katalog 01\e1.xls"
[dir name contains space and a number!]

gives me an error :
"Cannot update. Database or object is read-only."


Who knows "why?"
And how to fix up?



MS





All times are GMT +1. The time now is 12:36 AM.

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