S
Sarah White
I have an Excel spreadsheet originally developed in Excel 2000, in which
users enter data in their own workstation and click a button to transfer the
data to a centralized database. It works perfectly in Excel 2003, but have
problems in Excel 2007. I got a run-time error saying that method
'OpenCurrentdatabase' of object '_Application' failed.
It works if I moved the database to my local hard drive, but not in the
network folder. We have a peer-to-peer network with a computer designated as
a database server, running MS Windows 98 SE without MS Office. The folder
MASTER-DB is in full access with no password.
Dim appAccess As Variant
Dim dbCurrent As Variant
Set appAccess = CreateObject("Access.Application")
appAccess.Opencurrentdatabase "\\COMP 45 - NET S\MASTER-DB\Master.mdb"
Set dbCurrent = appAccess.CurrentDb
....
Any help would be greatly appreciated!!
Thanks,
Sarah
users enter data in their own workstation and click a button to transfer the
data to a centralized database. It works perfectly in Excel 2003, but have
problems in Excel 2007. I got a run-time error saying that method
'OpenCurrentdatabase' of object '_Application' failed.
It works if I moved the database to my local hard drive, but not in the
network folder. We have a peer-to-peer network with a computer designated as
a database server, running MS Windows 98 SE without MS Office. The folder
MASTER-DB is in full access with no password.
Dim appAccess As Variant
Dim dbCurrent As Variant
Set appAccess = CreateObject("Access.Application")
appAccess.Opencurrentdatabase "\\COMP 45 - NET S\MASTER-DB\Master.mdb"
Set dbCurrent = appAccess.CurrentDb
....
Any help would be greatly appreciated!!
Thanks,
Sarah