I thought it was supposed to be faster. I am testing by creating a duplicate table in MSSQL, then linking this table in a copy of my db. I then run identicl queries against the Access table and the MSSQL table. My Access table returns results in 41 secs. MSSQL takes 2:10 for the same query. Right now I set up a dsn to connect to the sql server. Is there a better way to do this that will return results faster? Will it be fairly simple to have my queries work? Should I just give this idea up? Any suggestions appreciated. Ken.
- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg
- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg