adp on Terminal Server?

  • Thread starter Thread starter Jeb
  • Start date Start date
J

Jeb

Problem: error message upon opening forms in an adp after
launching full Access 2003 installed on a Terminal Server
(not done with a transformation); my forms are bound to
SQL Server tables or stored procedures; error message
says "couldn't create backup of the file." Using user
names created on the terminal Server but not in the Active
Directory on the Domain Controller (other server). Mapped
one such user to a login name in SQL Server--still no go.
Do I need a transformation install? Can't the Terminal
Server account/connection be mapped to a login name in SQL
Server? Some of my users are on Windows 98 and can't join
the Windows 2003 Server domain directly; they must use
a "workgroup" approach. It is one of these non-domain
user login names that I mapped my Terminal Server user
name to in order to access the adp. Launches main form OK
which is tied to nothing. But try to open a form that
acesses a table, and boom. Can access tables directly,
however. Thanks for any advice. --Jeb
 
Never mind. All I needed to do was give permissions for
the Remote Desktop Users group to the All Users folder
under Documents and Settings! This is where I had a copy
of the .ade for the remote users to launch. The error
about the backup file was in response to the next window
that said "would you like to repair the database" or some
such item if I answered yes (the default answer)...
 
Back
Top