Access mdb compatibility with different Win OS

hk1
hk1 used Ask the Experts™
on
Hi

I am packaging an Access mdb with my VB application, along with Access run time files, so the customer neednt have Access installed. The application needs to run on Win 9x, NT, 2000 and XP.

1) Does it matter what version of Access was used to create the mdb?

2) Are there any compatibility issues with using an mdb created in XP?

3) What if the customer has a different version of Access installed on the target machine, from the version used to create the mdb? Will it still work?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
1) Does it matter what version of Access was used to create the mdb?
Yes, the various versions of Access have various incompatabilities.

2) Are there any compatibility issues with using an mdb created in XP?
Kind of depends (see above answer).  If you are using, as I rather suspect, the local Jet Engine to access the data, you could have a problem.

3) What if the customer has a different version of Access installed on the target machine, from the version used to create the mdb? Will it still work?
Ah, there's the rub!  Kind of depends on a lot of things but, in general, I don't remember it being totally simple to ensure that the versions "play nicely" with each other.
hk1

Author

Commented:
Is there any way to ensure that the mdb packaged with my VB application will work on any Win OS, irrespective of whether Access is installed or not in the target machine, and if it is installed, irrespective of the version?

Thanks
the runtime is guaranteed to work on all OS's Windows 98 and above. you're skating on thin ice with Windows 95, but it sometimes may work. Windows 3.1 or older - forget it.
with that settled...

hk1,
No comment has been added lately (151 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question.

RECOMMENDATION: Accept RDWilson2's Comment as Answer

Please leave any comments here within 7 days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

nexusnation
EE Cleanup Volunteer
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial