June 9, 2003 at 7:10 am
All,
I only get to dabble with Sql Server time to time. However, I have set up some tables, but I can't seem to update them when connecting. I have checked the account that I am using and it seems to have all the permissions that it needs. I am using SQL Server 2000 and accessing the Data with Access 2000 project. I am sure that I am overlooking something simple. Any Help would be GREATLY appreciated.
fryere
fryere
June 9, 2003 at 7:24 am
Do you get an error or does the update just not change anything? If an error, which one? One reason for an update to fail without error is code in a trigger that does a rollback, another is if the update where clause causes it to not match anything, yet another could be that the transaction is not being committed. Definitely could be a permissions issue, check that the user name you're using to connect has update rights, make sure that same user doesn't have a deny someplace else - in a role for example.
Andy
June 9, 2003 at 9:36 am
Andy,
One Problem was the table didn't have a Primary Key. Let me check a little more before I respond.
fryere
fryere
June 11, 2003 at 2:06 pm
Fryere,
There is an issue with Access and update/delete/insert statements wih tables that don't have primary keys.
Remember that once you have added the keys/index(es) that you have to re-run the link table add-in and select ALL. This will refresh the information and hopefully your statements will start working again.
An alternative thought is to build SQL statements and fire them from the modules.
Good Luck
AJ Ahrens
SQL DBA
Revenue Assurance Management - AT&T
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply