Creating Apps for Users Without Access

[Keith]

I want to distribute an access 2007 application to users that don't have
access? How is this done? Is this what an .accde does?


Thanks

 

[Ken Snell \(MVP\)]

See this site for the free ACCESS 2007 Runtime software. You can use it to
distribute your ACCESS 2007 database application to people who don't have
ACCESS 2007.

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

 

[DS]

This sounds good. What about Access 2002, file format 2000? If not, how
bad is it moving my 2002 db to 2007?
Thanks
DS

 

[Ken Snell \(MVP\)]

ACCESS 2002 runtime is part of the Office XP Developer's Edition. It's not
free, and may be difficult to find now (it's a bit "old"). But you may be
able to run an ACCESS 2002 .mde with Office 2007 runtime? I've not tried it,
but traditionally one can run an older ACCESS version with a newer software.

 

[DS]

Thanks Ken,
I did start looking for it but as you said. It is quite old and paying at
least $200.00 for software that is already 6 years old, soon to be 7 doesn't
sound like the smartest thing to do. So I guess I will create an MDE of my
2002 App and the use the free software to make it a stand alone ap free of
Access.
Thanks
DS

 

[DS]

Thank you. But just a question once you have created an MDE and did this
runtime thing so that it can run without Access, Can I still get ubder the
hood the make changes and updates and such?
Thanks
DS

 

[Ken Snell \(MVP\)]

An .mde file cannot be edited, even if you have ACCESS installed on your
computer. You MUST keep a copy of the .mdb file from which you created the
..mde file, and then you can make changes to the .mdb file -- and then create
a new .mde file, which you copy over top of the existing .mde file.

 

[blum_amy]

I have access 2003 and I would like to distribute a database to users who
don't have access. Can I buy Visual studio tools for 2005 and then download
runtime and I will be able to do this?

 

[Mike Painter]

I believe the new release of Access has that ability built in.

 

[Rick Brandt]

I believe the new release of Access has that ability built in.

It's not built in, but it is free.

 

[blum_amy]

would I be able to use this with access 2003?

It's not built in, but it is free.

 

[Douglas J. Steele]

Yes, but it's not free for Access 2003.

For Access 2003, you'd need to buy either Visual Studio 2003 Tools for
Office or Visual Studio 2005 Tools for Office.

 

[blum_amy]

I am sorry I just need to make sure (I am just anal this way).
I was able to download Access 2007 runtime. What you are saying to fully
implement runtime I would need Visual Studio 2005 tools for office? Thank
again..

 

[Douglas J. Steele]

You can use the Access 2007 runtime with an application built in Access 2003
without VSTO, but the result will have the Access 2007 ribbon, not the
familiar tool bar.

To create an Access 2003 runtime application you need VSTO.

 

[Rick Brandt]

You can use the Access 2007 runtime with an application built in
Access 2003 without VSTO, but the result will have the Access 2007
ribbon, not the familiar tool bar.

If you disable all built-in menus and specify an application menu bar then
the ribbon will not be displayed. You will see the same menu as in 2003.