W
Warren Rudman
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
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