Access 2007 - Visual Basic 6

I would guess that you need to download a newer version of MDAC

http://msdn2.microsoft.com/en-us/data/aa937730.aspx

http://blogs.msdn.com/access/archive/2005/10/13/480870.aspx

can you use any of these links sysop?

Hej. Beklager den sene respons.

Desværre kan MDAC ikke kører på WinXP da det er en del af den i forvejen skriver den.

Andre forslag?

Can I see the code you are using?

Ingen kode endnu. Har kun lavet databasen, men tager du helt fra starten og trækker et data object hen, kan du ikke bruge den til access 2007. Kan man evt via kode linke den?

Its ages since I used VB6 so I cant give an example myself maybe I'll install VB6 and give it a try, but heres a link with some info (with VB8 example)

http://www.awomantoldme.com/women/how-to/31038217/access-2007-file-format-d.aspx

In the I gave there is a link http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
where you can download a componenet. After download install this.
Thenin the VB project remove the reference you have to DAO and make a new reference to the new DLL

You should find it here.
C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL

Now when you add a data object to the form you need to use code somthing like this in the form.


Public gDB As Database

Private Sub Form_Load()

    Set gDB = OpenDatabase(App.Path & "\NameOfDB.accdb")
    Set Data1.Recordset = gDB.OpenRecordset("SELECT * FROM SomeTable")

End Sub


For each of the fields you have on the form you will need to set the DataField property manually because some properties of the data object areent set.

Fantastisk. Tak for en meget fin hjælp!!!

selv tak

Terry how do i then update the fields within VB?! It does not allow uo change/update the fields. It just say "element not found in this collection"

Hi
Not quite sure I understand. Have you set the DataField property to the name of the field from the table?