Here is my problem:

I doing a small project to help a company get there access data on the web.

They have a lot of forms, and reports already developed.  They are running

Access 2000 and the it is a data base (mdb) not a project (adp).  The forms

and reports use about 50 queries.  They want a inexpensive solution.  I have

tried importing the data base into sql 7 and then linking the table and

renaming the tables to the original name.  Everything works swell except for

two show stoppers.  A form they rely on heavily has a problem with the 'find

and replace' function when they try find a match in "any part of the field";

this takes an eternity to search.  The other two options "Whole field" and

"start of field" work fine.  The other problem is after an update is made to

the linked table.  Any subsequent updates get a error message: "write

conflict"; I think the previous update is not releasing the data.  I know

this all can be solve with moving to project or doing some vb code; but I'm

hoping for something less time consuming.  Anyone faced this before?



Brent Campbell - Computech Business Solutions

http://www.ctbsonline.com

campbellb@c...

voice:  xxx-xxx-xxxx  x206

fax:  xxx-xxx-xxxx