Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening access 07 databse in excel 07

Status
Not open for further replies.

ck1999

Technical User
Dec 2, 2004
784
US
I am trying the following code:

Dim newdb As Database, newws As Workspace, suppliers As Recordset, tradenames As Recordset

Set newws = DBEngine.Workspaces(0)
Set newdb = newws.OpenDatabase(Db2Name, False, True)
Dim newtable As TableDef

I get an error "unrecognized database format".

I have Microsoft DAO 3.6 referenced
File in not password protected

which will work until I upgrade to office 07. Any comments or Ideas of what is different?

ck1999
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top