Very Computer

J.P.

Quote:> Does anyone know of any white papers, or any documentation on How To
Deploy
> ADP's to a productions environment?  Is there any thing similar to
deploying
> an MDB?

it depends on the presence of Access installation on the production machines. If it's there, you can just put the ADP (or better ADE) on every machine. If not, you need Office Developer, it includes the distributable runtime Access that you can deploy on every production machine: you buy one Developer, and deploy on many machines.

More details here.

Vadim

Quote:> Does anyone know of any white papers, or any documentation on How To Deploy
> ADP's to a productions environment?  Is there any thing similar to deploying
> an MDB?

Hi Robert,

There can be a lot of steps involved in properly deploying ADPs.   The
level of complexity varies greatly depending on the specific scenario,
especially if you are deploying MSDE during the same process.   The
following two articles should be useful in highlighting some of the issues
and providing code samples for various tasks:

Creating and Deploying Access Solutions with the Microsoft Data Engine
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnox...
l/odc_modmsde.asp?frame=true

MOD2000: How to Deploy an ADP That Includes the MSDE
http://support.microsoft.com/support/kb/articles/q240/2/93.asp

Keep in mind that there is more than one way to do many things.   For
example, The NorthwindCS.adp sample file uses a method entirely different
from the method in the above articles to create a new database.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Brian M. Sockey
Microsoft Access Developer Support

---------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

--------------------


| Subject: Deploying ADP's
| Date: Mon, 17 Dec 2001 14:42:40 -0500

| Does anyone know of any white papers, or any documentation on How To
Deploy
| ADP's to a productions environment?  Is there any thing similar to
deploying
| an MDB?
|
|
|

Thanks in advance.

Quote:

> Hi Robert,

> There can be a lot of steps involved in properly deploying ADPs.   The
> level of complexity varies greatly depending on the specific scenario,
> especially if you are deploying MSDE during the same process.   The
> following two articles should be useful in highlighting some of the issues
> and providing code samples for various tasks:

> Creating and Deploying Access Solutions with the Microsoft Data Engine

long answer:
This is some of my experience, but, not complete and will give you some
Idea.
Table, View(replace queries), Procedures are supplied from the SQL server
and controlled by the SQL server user login, and the grant and  Revokes.
Queries that have no parms are now views, and if they have parms are made
into Procedures
Forms, Reports, Macros, Models are ADP dependent.
The VBA code for the Switchboard (if you are using it) has to be changed,
but can be used.
Forms that used queries have to be populated, using vba code calling the
procedures if there are parm, otherwise can use views.
SubForms based on queries have to be reinserted after recoding.

--
Host and Webmaster
Developer.
I also sweep floors.