Deploying a database

[Ray (UK)]

I am trying to deplay a daatabase, with all associated modules, etc. to a
person without Access.

I have tried deploying it using the runtime version of Access.

While most of the prggram functions OK, the programs that dynamically create
reports based on the type of date being held causes the program to freeze.

I assujme that this is because it is the runtime version of Access blocking
the program trying to do the create.

Am I right or is their a workaround?

Thanks in advance.

Ray

 

[aaron.kempf]

yeah you can't modify a form or report in design view using the
runtime.
I would reccomend telling us more about why you need to do this; most
of the times that people think that they need to do this; it really
isn't that complex

-Aaron

 

[Albert D. Kallal]

While most of the prggram functions OK, the programs that dynamically

create
reports based on the type of date being held causes the program to freeze.

For the most part, have you tried running your application as a mde? You
REALLY WANT to have been running that application for a considerable amount
of time as a mde. Then, and only then would I start to test that mde in a
runtime environment.

As for repost, most of the time, you should be able to supply, and design
the reports without the need for modifying the reports at runtime. For
example, while you can't replace, or add text box controls to a report you
can MOST certainly CHANGE the data source for a text box. So, often, you can
well work around the need to modify reports. If your application is self
modifying then I would not distribute it anyway. Applications that self
modify are usually very un-stable, and will give you a bad reputation for
writing crappy software.

For reports, usually you can supply "where" parameters. Take a look at eh
following pages for some ideas:
http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

When using the runtime, it is much assumed that you will be distributing a
mde. And, to provide updates, it also assumed you be running a split
database. Is your database split? If not, then read the following:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

So, if you not been using a mde, and don't have a split system...you got a
good deal of work to do, and you not near ready to start distribution your
application.

 

[Ray (UK)]

For the most part, have you tried running your application as a mde? You
REALLY WANT to have been running that application for a considerable amount
of time as a mde. Then, and only then would I start to test that mde in a
runtime environment.

As for repost, most of the time, you should be able to supply, and design
the reports without the need for modifying the reports at runtime. For
example, while you can't replace, or add text box controls to a report you
can MOST certainly CHANGE the data source for a text box. So, often, you can
well work around the need to modify reports. If your application is self
modifying then I would not distribute it anyway. Applications that self
modify are usually very un-stable, and will give you a bad reputation for
writing crappy software.

For reports, usually you can supply "where" parameters. Take a look at eh
following pages for some ideas:
http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

When using the runtime, it is much assumed that you will be distributing a
mde. And, to provide updates, it also assumed you be running a split
database. Is your database split? If not, then read the following:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

So, if you not been using a mde, and don't have a split system...you got a
good deal of work to do, and you not near ready to start distribution your
application.

 

[Mpact IT]

I apologize for my ignoance upfont, but does the server or shared BE location
need MS Access loaded? Right now, my PC is the only one in our office w/ MS
Access and I am tying to find the best method for our employees to use and
shaer a DB I created for Maintenance and Suport issues.

 

[Scott McDaniel]

I apologize for my ignoance upfont, but does the server or shared BE location
need MS Access loaded? Right now, my PC is the only one in our office w/ MS
Access and I am tying to find the best method for our employees to use and
shaer a DB I created for Maintenance and Suport issues.

No ... the "backend" for Access/Jet is just a file, and can be stored anywhere, with or without Access being installed.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com