ehamouda (5/7/2010)

---

Hi.

i was able "after a long time of trial and error" to migrate access database to sql 2005 and use linked tables to access the sql backend from the MS Access front end .MDB file. using upsizing wizard.

all seemed to be fine. working remotely, local adding records.

one thing is driving me crazy is that when we search against a table in access it takes long time.

i ran the profiler on sql server and i see alot of "exec sp_execute'

i am not very god in access . but on SQL i tried to create indexes"non clustered" on the fields we search by, and nothing..

please point me in the right direction!

please if any one can help please let me know...

Thank you