More knowledge about Access RunTime

[Guest]

I am about to install Ms Access 2003 Developer Version on my PC. I have some
query in my mind, which I could like to clarify :

A. Once I will make my mdb as a Run time (so that it can run on PC's Access
is not installed), What File extension it will be saved (I mean .mdb, mde
etc.)?.

B. Later if I want to edit the Form or report, can I bring the file back to
the PC where Access is installed and can make the changes/Edit Design ?. Is
it possible?.

C. Generally when we make mdb to Mde, here we cannot make the changes on
Design of Form, Report, Module. But we can import its table to another mdb,
Can we use the table in another mdb. Is the same possible with the file
(Runtime) which I will make as a runtime. Can I bring that File back on the
Access installed PC and import the table to another mdb.

As may be the time can come where the user need changes, if above no. 2 will
be not be possible then I can use the no. 3 above, to import the data table
another mdb and save and make a run time again and forward the user to use.

Please advise me on above.

Regards.

Irshad.

 

[Arvin Meyer [MVP]]

Answers in line:

I am about to install Ms Access 2003 Developer Version on my PC. I have some
query in my mind, which I could like to clarify :

A. Once I will make my mdb as a Run time (so that it can run on PC's Access
is not installed), What File extension it will be saved (I mean .mdb, mde
etc.)?.

The runtime doesn't change the database, it installs a runtime of the Access
executable. If the database is an MDB, it is fully editable on any PC with
full Access.

B. Later if I want to edit the Form or report, can I bring the file back to
the PC where Access is installed and can make the changes/Edit Design ?. Is
it possible?.

As long as the database is an MDB or ADP

C. Generally when we make mdb to Mde, here we cannot make the changes on
Design of Form, Report, Module. But we can import its table to another mdb,
Can we use the table in another mdb. Is the same possible with the file
(Runtime) which I will make as a runtime. Can I bring that File back on the
Access installed PC and import the table to another mdb.

Yes. The runtime itself does not allow adding/editing any objects, only
data.

As may be the time can come where the user need changes, if above no. 2 will
be not be possible then I can use the no. 3 above, to import the data table
another mdb and save and make a run time again and forward the user to

use.

Again, you can move the database to a PC with full Access and do anything
that you could previously do, subject to security permissions, if the
database has been secured.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access