Open Access DB in Excel 2007

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top