Is there a way to make access application stand alone?

[Frederick Wilson]

I was wondering if there is a way to make Access a standalone. I know
about making an MDE but I don't think this is the same.

I would like to have it run from a CD rom so I can send it as a demo.
I have taken special precautions to ensure that nothing is being written
to table in the presentation applications.

 

[Rick Brandt]

I was wondering if there is a way to make Access a standalone. I know
about making an MDE but I don't think this is the same.

I would like to have it run from a CD rom so I can send it as a demo.
I have taken special precautions to ensure that nothing is being
written to table in the presentation applications.

No.

 

[Larry Linson]

"Frederick Wilson" wrote

I was wondering if there is a way to
make Access a standalone. I know
about making an MDE but I don't
think this is the same.

I would like to have it run from a CD
rom so I can send it as a demo.
I have taken special precautions to
ensure that nothing is being written
to table in the presentation applications.

You can create an installation package, to distribute your Access
application with runtime support. That would be done using the Office
Developer Edition for Access 2002 and earlier, or the Visual Studio Tools
for Offce 2003 for Access 2003.

Larry Linson
Microsoft Access MVP

 

[Douglas J. Steele]

"Frederick Wilson" wrote



You can create an installation package, to distribute your Access
application with runtime support. That would be done using the Office
Developer Edition for Access 2002 and earlier, or the Visual Studio Tools
for Offce 2003 for Access 2003.

Recognize, though, that the runtime MUST be installed on the workstation. As
Rick so succinctly pointed out, there's no way to be able to have Access run
from a CD.

 

[Frederick Wilson]

HMM.

If access is on the local machine will my application run? I know there
is normally a need for a locking file, but the application I made does
not allow changing of the data. It only presents it.

 

[Douglas J. Steele]

If Access is already installed, then the user should be able to use your MDB
(or MDE). There will be warnings about read-only, but you should be able to
ignore them.

 

[John Webb via AccessMonster.com]

I believe it still needs to create a locking file.

Your only other option would be to create a front end in some other
fashion, be that via web forms or building your own program in something
like VB, or even a middle ground option like a HTML application. Indeed, I
have used all these methods in the past.

The user will not need Access installed in these instances, just the ODBC
drivers; which are commonly installed on machines already.

Cheers

John Webb

 

[Douglas J. Steele]

Actually, if you open a database as exclusive and read-only (eg. open it
with a shortcut that uses the /ro and /excl flags), Access won't try to
create a locking file.

Also, as I posted elsewhere in this thread, if Access is unable to create
the locking file, I believe it'll still let you open the database. It just
won't let you update it.

 

[Frederick Wilson]

The HTML option would be great if I knew how to do it. I can not even
figure out data access pages in access