Access 2003 vi's compatible with Access 2007?

[BernieSAIC]

I will be doing some access DB work and am wondering if the vi's that worked with Access 2003 (XP) will work if the targeted computer has access 2007 installed?  The computer may have XP, Vista or 7 depending on where I run it.

I have to get an answer so we may buy the software before I start the project.

What caveat's if any would I possibly run into?

Thanks

FYI I am running LV2009

[Dennis_Knutson]

What VI's are you talking about? If you are using the Database Connectivity Toolkit or the shareware LabSQL, there should be little or no difference. You would not require Access installed at all - only the jet database.

[BernieSAIC]

The VI's are ones handed down to me from another project, not drivers or anything.  They use automation open comands etc. They reference :  Provider=Microsoft.Jet.OLEDB.4.0; Data Source=  and we name a created Access DB table to insert the results in.

I am new to having to create all of this from scratch, so any help would be appreciated.

[Dennis_Knutson]

That does not help much. The VIs will have names. What are they. Even better, attach some code or even an image.

[BernieSAIC]

Attached is the code

[Dennis_Knutson]

Do NOT rename your huge bmp files to jpg to just get around the ban on posting bmp's. You really don't think changing the extension changes the file format, do you?

[smercurio_fc]

DO NOT POST BITMAPS TO THE FORUM BY RENAMING THE EXTENSION TO JPG.

The prevention of uploading a bitmap is there for a reason, you know.

Now, as to your question:  The code is accessing the database using the Jet provider, so Access doesn't even come into play. So, you should be fine. As long as you STOP POSTING BITMAPS.

[BernieSAIC]

Didn't even know about the ban.  Won't happen again.  Back on topic...

If I don't have an access DB table created and installed how does it update the table?  Sorry if this is a novice question.

[Dennis_Knutson]

You don't need Access. You do need a table someplace. Two different things. Access is a program to manage Jet databases.

[RavensFan]

---

BernieSAIC wrote:

Didn't even know about the ban.  Won't happen again.  Back on topic...

---

If you didn't know about the ban, then why would you have taken the time to rename your .bmp file to a .jpg?