How to make ACCESS based database application run without having ACCESS installed?

Question

I've made (ACCESS 2007 based database) app on VB.NET 3.5 into a setup file.
When I install it and RUN it on a PC that has no ACCESS 2007 on it, it says: Microsoft.ACE.OLEDB.12 missing.
Clearly the solution is to install ACCESS 2007.

Q1: How can I make it RUN on a PC that has no ACCESS 2007 installed on?

Q2: Can I include .NET Framework 3.5 in the setup package so the user doesn't have to download it and install it separately?

Thank You!

Answer 1

Not sure about Q2, but for Q1:

"Access 2007 Download: Access Runtime"
http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

//Michael

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

For Q2 you might need to check next links. Keep in mind that installation could become huge.

http://msdn.microsoft.com/en-us/library/cc160716.aspx

http://msdn.microsoft.com/en-us/library/cc656912.aspx

http://download.microsoft.com/download/5/a/a/5aa86d6c-969b-42d8-bc6b-30e02bfeccf0/NETFXClientProfile_DeploymentGuide.htm

---

Val Mazur (MVP) http://www.xporttools.net

Answer 3

Michael: Straight-forward.
Thank You!

Val Mazur: I wish you just answered me and not redirected me to the complicated-to-newbies MSDN manuals.
but thank you anyway.