I have an Access 2000/2002 ADP solution for a SQL 7 database. Now the
client to whom this information applies would like to have copies of it
so they can run some searches against the database.

I have run the package & deploy wizard on the ADP file, but none of the
data comes along with it. My hopes were that I could install MSDE on
the clients' computers with a copy of the database and just attach the
ADP file to it. Is this possible?

One of the reasons for the ADP file in the first place was that I
created code which would generate a WHERE clause based on user input in
a form so that they could modify a stock query/view (and a standard
report based on that query) without having to understand SQL the way I
do (and without having to call me every time). [It is even more
complex than this... we use Crystal Reports to call up the modified
query and display the results using subreports.]

Cosiderations:

1) Can I package this in some way so that the client can install with
little or no intervention on my part?

2) There are nvarchar fields in the SQL database that run to 8000
characters. We run full-text searches against these fields using the
CONTAINS function. Access has had trouble with large text fields in the
past. How do I maintain this functionality without SQL server? Will
MSDE suffice? Or should I be looking at taking the data tables into an
*.mdb and rewriting the code to accomodate (last resort)?

Thanks for any and all input.

Warren Rudman
Database Developer
Sterne, Kessler, Goldstein & Fox
202.772.8686

this is a test
"Warren Rudman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have an Access 2000/2002 ADP solution for a SQL 7 database. Now the
> client to whom this information applies would like to have copies of it
> so they can run some searches against the database.
>
> I have run the package & deploy wizard on the ADP file, but none of the
> data comes along with it. My hopes were that I could install MSDE on
> the clients' computers with a copy of the database and just attach the
> ADP file to it. Is this possible?
>
> One of the reasons for the ADP file in the first place was that I
> created code which would generate a WHERE clause based on user input in
> a form so that they could modify a stock query/view (and a standard
> report based on that query) without having to understand SQL the way I
> do (and without having to call me every time). [It is even more
> complex than this... we use Crystal Reports to call up the modified
> query and display the results using subreports.]
>
> Cosiderations:
>
> 1) Can I package this in some way so that the client can install with
> little or no intervention on my part?
>
> 2) There are nvarchar fields in the SQL database that run to 8000
> characters. We run full-text searches against these fields using the
> CONTAINS function. Access has had trouble with large text fields in the
> past. How do I maintain this functionality without SQL server? Will
> MSDE suffice? Or should I be looking at taking the data tables into an
> *.mdb and rewriting the code to accomodate (last resort)?
>
> Thanks for any and all input.
>
> Warren Rudman
> Database Developer
> Sterne, Kessler, Goldstein & Fox
> 202.772.8686
>
>
>