Open MS Access from a computer that does not have MS Access

Is there a way to create a MS Access DB and create forms within the DB and have another computer access and edit the form without have MS Access?
LVL 1
philtukeyAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:

 The run time for Access 2007 and A2010 is free to download.  If you have a version earlier then that, you will need to purchase a license.

 The "runtime" is really the full version of Access, but with all the design capabilities disabled.  

 You develop your your DB and then give that to the user and let them download the runtime, or you can create an install package, which has both and they can then install.

JimD.
0
 
squirrelnuttzCommented:
if you had the MS access runtime, or publish it to the web
0
 
philtukeyAuthor Commented:
I do have the MS access runtime but it will not pull up the form.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
squirrelnuttzCommented:
is the runtime you have for the same version of the mdb or mde?
0
 
philtukeyAuthor Commented:
I believe so. I downloaded the only version of Runtime I could find.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Also, you must take special care to include proper error handling when you are working with the runtime, and there are several other caveats as well. See this article for more information:

http://msdn.microsoft.com/en-us/library/aa165862(v=office.10).aspx

This is for XP, but it's the same newer versions as well.
0
 
philtukeyAuthor Commented:
Thank you for the link to the article. I read it and it still doesn't seem to work. I am atttaching some screen shots of what I get when I try to open the database using the runtime.
Screenshot-1.bmp
Screenshot-2.bmp
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  The issue here is that the database is not located in a trusted location nor is it digitially signed (you didn't supply a security certificate with it).   Until that's corrected, your going to have that warning come up.

Have a look at the following link:

http://office.microsoft.com/en-us/access-help/help-secure-an-access-2007-database-HA001230187.aspx#_Toc272147903

 (watch the wrap), which tells you how to self-sign a Access 2007 app.

JimD.

 
0
 
philtukeyAuthor Commented:
When I try to publish the database I get No Certificate available.

Thanks,

Phil
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Are we working with 2007 or 2010?

Jim.
0
 
philtukeyAuthor Commented:
2010
0
 
philtukeyAuthor Commented:
I got it to work on a access 2007 database but not the 2010 database. Any ideas?
0
 
philtukeyAuthor Commented:
My mistake for some reason I got a MS Access DB to work on the PC without Access using a template from online, however when I create a new Access DB it fails to load on the PC without Access. Please help!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You cannot open an Access database and work with the Forms, Reports, etc unless you have either the Retail or Runtime version of Access installed on the machine.

You can use other programs to open the Access DATABASE and work with the DATA. For example, if you have Excel installed, you can "import" from an Access database, or if you have VB.NET installed, you can use a VB.NET program that you build to open and work with the DATA in that Access database.

You MUST install either the Retail or Runtime version of Access.
0
 
philtukeyAuthor Commented:
I have MS Access Runtime 2010 installed on the PC without the full version of MS Access.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you receive any errors? Or does the application just fail?

Given that the 'other' app you downloaded did run, I'd suspect that you have troubles with the database. Did you review the information at the link I provided earlier, regarding the differences between the Runtime and Retail environments?

You can simulate the Runtime environment on your development machine by renaming your .adddb file to the ".accdr" extension. This tells Access to run the file in the Runtime environment, where you can test to see if things work as planned.

Otherwise, you may have reference issues. Are you certain the references in your Access database are in place on the target machine?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Sorry I didn't get back to you yesterday.  The day got a bit out of control.

 Please see LSM's last comment, which does a great job of covering the issues you may be encountering.

JimD.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'd suggest this:

http:#a34957302 (300 pts) - this post suggests the Runtime or Retail must be used
http:#a34957453 (200 pts) - this post provides details of the differences encountered, which would have provided the user with sufficient information to resolve the error
0
 
LeeTutorretiredCommented:
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.