Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Use Access 2007 as database?


Use Access 2007 as database?

Author
Message
Smartchap
Smartchap
Forum God
Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)Forum God (3.7K reputation)

Group: Forum Members
Posts: 23, Visits: 90
I had written a program which was using Access97 file (extension .mdb) as database file and was working well. Now I have converted that file to Access 2007 format (.accdb extension). What should I change in the program so that I could access this new file. The code used is



Public gwrk As Workspace

Public gdb As Database

Public rs As Recordset



Set gwrk = DBEngine.Workspaces(0)



'Set gdb = gwrk.OpenDatabase(App.path & "\Address_Book.mdb")

Set gdb = gwrk.OpenDatabase(App.path & "\Address_Book.accdb")



Set rs = gdb.OpenRecordset("select * from Addresses", dbOpenDynaset)



While running in line Set gdb=.... I get error "Unrecognised Database Format". Please help.

Always Believe in GOD!
Destroyer
Destroyer
Forum God
Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)Forum God (21K reputation)

Group: Forum Members
Posts: 244, Visits: 188
Try this for converting your Access 97 database.



http://access.ezinemark.com/converting-a-database-to-ms-access-2007-file-format-3201caa0907.html

Destroyer Smooooth
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search