AttachDSNLessTable - Tony WONG

i use this method "How to create a DSN-less connection to SQL Server for
linked tables in Access" (http://support.microsoft.com/kb/892490)  to
connect to SQL server.

is it supposed to run it by single user mode?

is there problem if more users using the Access file in which forms &
reports are saved here for share?

it is because it connects to SQL "every time" triggered by user by "autoexec
run macro"

any better solution to my case - multi user?  Thanks a lot.

tony

AttachDSNLessTable - Arvin Meyer [MVP]

Make sure that any multi-user database is a separate front-end file for each
user, even if run from a terminal server. On a LAN, each user runs a
front-end (Forms, Reports, code, etc.) linked to tables on a back-end
running on a server. While it is possible to run as a single file, it is a
disaster waiting to happen and almost a virtual guarantee of eventual
corruption.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com