Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Word Doc.s with Access FE and SQL BE

Author  Topic  Bryan Starting Member 1 Post Posted - 2004-05-20 : 10:29:02 Hello, I have searched the forums but can't quite find the answer. I have an Access2K front-end and SQL2K backend that has tables with Word doc.s. All my queries are enormously slow when retrieving the Word doc.s. The backend use to be Access but out grew the 2-gig barrier. What I use to query in 30 seconds with an access backend now takes over 15 minutes in SQL. It doesn't matter if it is an ODBC link or a converted ADP (project), the time is the same. The Access backend was on the exact same server that the SQL is now on, so the hardware hasn't changed. I have read many articles about pointing to image files in SQL and know that when I attach the Word doc. inside the front-end of Access it shows them as "Linked". Isn't that just a pointer? I have kept the images in a folder on the server for years and could easily edit the files in Word so I know that they are linked but don't know if the link is different than what is described as a pointer in SQL. I'm new to SQL but feel like it should be faster even with the Access ODBC link. I know they are slow but this seems extreme. Anyone have any ideas to try? Bryan