Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 6th, 2003, 10:32 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot modify data in table residing on SQL Serv

I opened Access went to Access Database wizards....then went to Project (Existing DB)....then the Data Link Properties choose the correct server and DB on server. The ADP opens up fine but when I try to update or add a new record it does not allow me. Any ideas?

THank you :D

slypunk
__________________
slypunk
Reply With Quote
  #2 (permalink)  
Old June 6th, 2003, 10:53 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

What error do you get when you say "...it does not allow me"?

Are you sure that you have appropriate account access to the Server and the database you are trying to connect to?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #3 (permalink)  
Old June 6th, 2003, 10:55 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The new record button and delete button are disabled. I cannot add or delete a record in the table.

slypunk
Reply With Quote
  #4 (permalink)  
Old June 6th, 2003, 11:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Are you sure that the account you are using to connect to SQL Server has INSERT and DELETE permission for the database and/or table you are attemtping to modify?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #5 (permalink)  
Old June 6th, 2003, 11:06 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

My main purpose is for Access to be the front end and SQL Server the back end. When I create a form, it creates it perfectly fine, but I cannot add or delete records. Since I do know the source for these forms are the tables that is also not allowing me to modify. The account is working fine I checked I am hoping it is maybe a bug? Any help or suggestions is greatly appreciated. I hope I make sense what I am explaining. Thank you :)

slypunk
Reply With Quote
  #6 (permalink)  
Old June 6th, 2003, 11:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

I doubt seriously that it's a bug.

Almost assuredly the account you used to establish the connection to SQL Server does not have the appropriate (SQL Server) permissions for the operations you require.

The account can't be "...working fine..." if you can't gain access to the tables...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #7 (permalink)  
Old June 6th, 2003, 11:25 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Where can I check what type of permissions I have in SQL Server?

slypunk
Reply With Quote
  #8 (permalink)  
Old June 6th, 2003, 11:27 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sly, can you see/modify your tables if you attack directly from EM using the same login data that you are using in Access?
Reply With Quote
  #9 (permalink)  
Old June 6th, 2003, 11:31 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes I could. As a matter of fact one of the tables do not have any records in it and when I try to add a new record from Access it does not but when I go to EM it does.

slypunk
Reply With Quote
  #10 (permalink)  
Old June 6th, 2003, 11:36 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What happens if you create a new form to enter data directly into the table, ie avoiding sub forms and all other Access 'features'?
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recovering accidentally deleted logins in sql serv v-manraj SQL Server 2000 0 September 25th, 2007 02:55 PM
How to dynamically modify a table... roopesh ASP.NET 1.0 and 1.1 Basics 9 January 16th, 2007 12:05 PM
Failed to copy objects from SQL server to SQL Serv monfu SQL Server 2000 4 December 4th, 2005 05:54 PM
Can't Modify or Delete table PatYoda SQL Server 2000 3 December 3rd, 2004 09:41 AM
How to automatically modify picture size in table Edward King HTML Code Clinic 2 November 19th, 2003 05:28 PM



All times are GMT -4. The time now is 07:59 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.