D
DH
When synchronizing data between the server and a laptop connected to the
network, some temporary tables are created, data is moved around and then the
tables are deleted. Visual Basic is used in Access 2003. It works fine when
I test it on my computers. When my client tries to run it, she gets the
error message: Could not create; no modify design permission for table or
query 'Table1'.
Table 1 is the name of the first table.
I found a note in the Connect and ReturnsRecords Properties Example
(Client/Server) that says "Note: The DSN referenced below must be set to use
Microsoft Window NT Auuthentication Mode to authorize user access to the
Microsoft SQL Server." I have Windows XP on my computers and the client is
using Windows 2000 so I tried to blindly apply the example but it didn't
solve the problem. Am I on the right track? Is the problem caused by the
differences in Windows XP and 2000? What exactly is a DSN? In the example
;DSN=Publishers was added to the end of the expression. Is publishers the
name of something that already existed or is that part of the expression
assigning the name publishers to the DSN?
Maybe the problem is caused by something totally different. Any suggestions?
network, some temporary tables are created, data is moved around and then the
tables are deleted. Visual Basic is used in Access 2003. It works fine when
I test it on my computers. When my client tries to run it, she gets the
error message: Could not create; no modify design permission for table or
query 'Table1'.
Table 1 is the name of the first table.
I found a note in the Connect and ReturnsRecords Properties Example
(Client/Server) that says "Note: The DSN referenced below must be set to use
Microsoft Window NT Auuthentication Mode to authorize user access to the
Microsoft SQL Server." I have Windows XP on my computers and the client is
using Windows 2000 so I tried to blindly apply the example but it didn't
solve the problem. Am I on the right track? Is the problem caused by the
differences in Windows XP and 2000? What exactly is a DSN? In the example
;DSN=Publishers was added to the end of the expression. Is publishers the
name of something that already existed or is that part of the expression
assigning the name publishers to the DSN?
Maybe the problem is caused by something totally different. Any suggestions?