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

 

[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.