Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 880
  • Last Modified:

MS SQL & Delphi 3 & Table is not indexed

I've a table on MS SQL Server 6.5 (I'm DBO) and open it
in Delphi. It's successful. But if another user opens it in
my Delphi 3 program, my program gets error "Table is
not indexed". What's wrong?
May be I store TableName in dbo.MyTable?
0
hansmtbank
Asked:
hansmtbank
  • 2
  • 2
1 Solution
 
hansmtbankAuthor Commented:
Edited text of question
0
 
Pegasus100397Commented:
Sounds like your other user does not have the correct permissions for the table. Go into SQL Enterprise manager and grant PUBLIC all necessary permissions on the table. Should fix ya right up! :)

Good luck with your project!
Pegasus
0
 
hansmtbankAuthor Commented:
I added my users to group public for my database (I'm DBO) and
cranted all permissions for all tables to another users, but
anythins did not changed.
0
 
Pegasus100397Commented:
Make sure your users are assigned to the PUBLIC group and furthermore that the group PUBLIC is granted access to the new indexes you created.

Good luck!
Pegasus
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now