Runtime Question

[Bob V]

If I had MS Access 2007 and developed a Data Base program, How do I have to
alter it for people with Runtime to use it, and can that version be used by
a normal Access version to make changes to the DB?..........Thanks ....Bob

 

[Rick Brandt]

If I had MS Access 2007 and developed a Data Base program, How do I
have to alter it for people with Runtime to use it, and can that
version be used by a normal Access version to make changes to the
DB?..........Thanks ....Bob

The only thing different required of a file that you want to use with the
runtime is that you must provide those things that the full version of Access
gives you that the runtime does not.

1) Full custom menus (forms or ribbons) to access all functionality because the
runtime environment does not provide any of the built in menus.

2) Error handling. In the runtime most unhandled errors will terminate the
application. That means robust error handling must be added by the developer.

In addition there is a handful of features that are not supported in the
runtime. Filter-by-form for example.

Other than those things described that you must add to the file it is still a
plain old Access file that anyone with the proper version will be able to use
(full or runtime).

 

[Bob V]

Rick if I had a Db in this version:
accde This format is also known as a compiled binary file
and my code says: you have to have the word *white* in a field otherwise the
db will not work, so as if [whitehouse] was in the field the db will operate
but if the word [greenhouse] was there it wouldn't operate, And the user
would not be able to see what word a where because the format is compiled!!!
Am I crazy or could this work................Regards Bob

 

[Rick Brandt]

Rick if I had a Db in this version:
accde This format is also known as a compiled binary file
and my code says: you have to have the word *white* in a field
otherwise the db will not work, so as if [whitehouse] was in the
field the db will operate but if the word [greenhouse] was there it
wouldn't operate, And the user would not be able to see what word a
where because the format is compiled!!! Am I crazy or could this
work................Regards Bob

Not real clear, but if I understand you correctly then yes. This would not
prevent them from getting at your data, but it could keep them from running your
accde file.

 

[Tom van Stiphout]

On Mon, 29 Oct 2007 11:46:18 +1300, "Bob V" <[email protected]>
wrote:

Typically you'll want to distribute an MDE, so users cannot modify it
(at least not the source code). If modifications are allowed, you can
distribute an MDB (or the new ACCDB).

Read up on the limitations of the Runtime (e.g. query by form is not
supported). For most business productivity applications the
limitations are not severe.

-Tom.

 

[Bob V]

Rick, if I gave my friend a runtime version of my db, and say his name was
"Frank Whitehouse" and his company was called "Oak Farm"
If I had a condition that the name *White* had to be in the Name Field and
the name *Oak* had to be in the Company field for them to use the DB
So "Bill Greenhouse" from the company "Pine Farm" would not be able to copy
the db and put his personal settings into the Fields!
Does that make sense!................Thanks Bob

Rick if I had a Db in this version:
accde This format is also known as a compiled binary file
and my code says: you have to have the word *white* in a field
otherwise the db will not work, so as if [whitehouse] was in the
field the db will operate but if the word [greenhouse] was there it
wouldn't operate, And the user would not be able to see what word a
where because the format is compiled!!! Am I crazy or could this
work................Regards Bob

Not real clear, but if I understand you correctly then yes. This would
not prevent them from getting at your data, but it could keep them from
running your accde file.