Vista - XP Compatibility for Access 2003 MDB / MDE

[ras]

Create mdb in office 2003 and Windows XP
Move to Office 2003 and Vista
Get errors in querys with VBA functions like Left() and Mid()
This can be fixed by the following procedure in the copy on VISTA
1. Open references and check any new item in the list of references
2. Close and reopen the mdb
3. Open references and uncheck the item checked in 1.
Now the mdb does not get errors.

This is ok but I need to somehow create an mdb that can be
distributed/installed in either XP or Vista with out the errors.

There is a way to automate the checking of references but I don't
believe this will work if I create an MDE file in XP and then move it
to Vista.

How do I create one MDE file that can be used with XP and Vista.

TIA

 

[Maverick]

My suggestion... create it on the Vista system and see if you still have
problems between the platforms. You may have no problem moving it from Vista
to XP, but difficulty in the reverse.

 

[ras]

The problem is the references and MDE file if you create MDE file in
Vista it will NOT run under XP and neither will the reverse.
Apparantly you must create an MDE for XP and another for Vista.
Please let me know if there is away around this problem.

 

[Tony Toews [MVP]]

How do I create one MDE file that can be used with XP and Vista.

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/