General discussion

Locked

HELP! SQL/Access View Problem

By gregorys ·
HELP!!! I have assigned permissions in my SQL Server by
windows integrated groups. When I try to save a new view
in the Access Data Project it gives me this error...ADO
Error Line 1: Invalid syntax near "/" . If I assign
individual permissions to the user this error goes away.
Any ideas or fixes that you know of would be great!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

HELP! SQL/Access View Problem

by gregorys In reply to HELP! SQL/Access View Pro ...

Point value changed by question poster.

Collapse -

HELP! SQL/Access View Problem

by Joseph Moore In reply to HELP! SQL/Access View Pro ...

Try a SQL Server service pack update:
http://www.microsoft.com/sql/downloads/2000/sp3.asp

hope this helps

Collapse -

by peterkc In reply to HELP! SQL/Access View Pro ...

If assigning individual permissions to the user fixes the error,
then the windows integrated groups that you've assigned does
not have the right permission assigned; make sure that each
individual user(s) is a member of that group.

In SQL Enterprise Manager give the Windows group permission(s)
to access the database(s).

From Microsoft:

When granting a Windows NT 4.0 or Windows 2000 local or
global group access to connect to an instance of SQL Server,
specify the domain or computer name the group is defined on,
followed by a backslash, and then the group name. For example,
to grant access to a global group called SQL_Users, in the
LONDON domain, specify LONDON\SQL_Users as the group
name.

To grant access to a Windows NT 4.0 or Windows 2000 built-in,
local group, specify BUILTIN instead of the domain or computer
name. To grant access to the built-in Windows NT 4.0 and
Windows 2000 local group Administrators, specify
BUILTIN\Administrators as the group name.

Here is a helpful link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/adminsql/ad_security_47u6.asp

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums