how to make an access file .mdb self executing .exe

P

patentinv

Is there a way to allow users that don't have access installed on there
computers to be able to use my access 97 database file .mdb. I was reading
about a runtime version that may work, is this true? Please help.

Thanks
 
A

Arvin Meyer [MVP]

patentinv said:
Is there a way to allow users that don't have access installed on there
computers to be able to use my access 97 database file .mdb. I was reading
about a runtime version that may work, is this true? Please help.
Click to expand...

There is no executable. Yes there is a runtime version. You would need the
Developer's edition, which for Access 97 may be difficult to find. If you
cannot find it, you can "upgrade" to Office XP or 2003 and buy a kit for
that.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
M

Mr B

Yes, there is a Developer's edition for Access 97. However, because it is
quite old, I do not know where you can purchase a copy. Someone else may be
able to help with that part.

The developers edition allows you to create a runtime version of your
application which can then be installed on other computers and users can run
your application, but because it is a runtime version they cannot do anything
else with it.
 
P

patentinv

patentinv said:
Is there a way to allow users that don't have access installed on there
computers to be able to use my access 97 database file .mdb. I was reading
about a runtime version that may work, is this true? Please help.

Thanks
Click to expand...
 
P

patentinv

Mr B said:
Yes, there is a Developer's edition for Access 97. However, because it is
quite old, I do not know where you can purchase a copy. Someone else may be
able to help with that part.

The developers edition allows you to create a runtime version of your
application which can then be installed on other computers and users can run
your application, but because it is a runtime version they cannot do anything
else with it.
Click to expand...

Mr. B

When you say because it is a runtime version they cannot do anything
else with it. Does this mean that they will not be able to use my progranm
at all,
they won't be able enter any data into it like customer name address etc.
make any choices in the combo boxes. If this true why do they even make a
developers edition what good is it.

Thanks
 
J

John Vinson

When you say because it is a runtime version they cannot do anything
else with it. Does this mean that they will not be able to use my progranm
at all,
they won't be able enter any data into it like customer name address etc.
make any choices in the combo boxes. If this true why do they even make a
developers edition what good is it.
Click to expand...

You misunderstand.

The users will be able to USE the database - search for data, add new
data, edit existing data, print reports, etc.

What they will not be able to do, using the Runtime, is to make any
*design changes* to the structure of the database. That is, they
cannot create new Forms or Reports, or change the layout or structure
of a Form, Report, or Table. You must use the full retail version of
Access to make structural changes, but they'll be able to use the
changed database once they have a copy.

John W. Vinson[MVP]
 
P

patentinv

Arvin Meyer said:
There is no executable. Yes there is a runtime version. You would need the
Developer's edition, which for Access 97 may be difficult to find. If you
cannot find it,
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


If I was to purchase the new or "upgrade" to Office XP or 2003 and buy a kit for
that. And rewrote my program in this new edition would the new program have a .exe extension a self executing file. And saying it does, once it is installed would the users be able to use my program just like if they were to have access installed on there computer enter data into text boxes like customer name, address, city etc. chose from combo boxes. Just interact with the program like normal. And have it get data from tables, just as if access was installed?
Click to expand...

Thanks
 
Top