D
Derek
I have an excel spreadsheet pivottable accessing data
from an Access Database.
For various reasons we need to access the Access Database
from Excel using VB. A sample of the code to achieve
this is here:
Set objAccess = GetObject _
("D:\MyFolder\MyDatabase.mdb")
newdate = objAccess.Run("InsertReportDate", newdate, 1)
Set objAccess = nothing
For several months this ran without a problem. However
unless the Access database is already open before this
code runs then it now corrupts the database.
The corruption is that when the database is opened it
asks for a password. There is no security on the Access
Database at all (at least not before this). Following
this happening the pivot tables can no longer refresh.
The above is just a sample. The VB link to Access is
used to update dates, run macros and other things
required for the reports.
Any assistance appreciated.
Derek
from an Access Database.
For various reasons we need to access the Access Database
from Excel using VB. A sample of the code to achieve
this is here:
Set objAccess = GetObject _
("D:\MyFolder\MyDatabase.mdb")
newdate = objAccess.Run("InsertReportDate", newdate, 1)
Set objAccess = nothing
For several months this ran without a problem. However
unless the Access database is already open before this
code runs then it now corrupts the database.
The corruption is that when the database is opened it
asks for a password. There is no security on the Access
Database at all (at least not before this). Following
this happening the pivot tables can no longer refresh.
The above is just a sample. The VB link to Access is
used to update dates, run macros and other things
required for the reports.
Any assistance appreciated.
Derek