How to make Access DB to EXE

Hello experts,

I have created and finalised my database in Access 2010 and am now looking to roll this out to 5 users that will open the database and pull the data from the SQL server.

However, I am stuggling to work out how to publish this database... Can I publish it as an EXE. Not every user has Access on their machines.

I do recall a way of doing this in 2003 and 2000 Access.

Any assistance or third party links would be highly apprecieted experts !


-Jon
AucklandAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
peter57rCommented:
You need to install the Access runtime version on the user machines.

Or you can use the Package and Distibute option and include the runtime in that.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=57A350CD-5250-4DF6-BFD1-6CED700A6715&displaylang=en
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Just to add a bit; a Access DB is more like a document that is read rather then a program that is run.  As Peter has said, you need to have the Access Runtime to do that.

 Note however the runtime has some differences in it (you can't do anything that would be considered a desgin change), which is not a problem for most apps.

  You might want to test your app in runtime mode, which you can do by starting the full version with the /runtime switch.

JimD.
0
 
AucklandAuthor Commented:
Thank you both for your comments, each of them is very helpful.

0
 
DhaestCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.