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
  #11 (permalink)  
Old June 6th, 2003, 11:38 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by chrislepingwell
 What happens if you create a new form to enter data directly into the table, ie avoiding sub forms and all other Access 'features'?
It does not allow me to add, delete, or move to the next or previous record.

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

OK, in EM, find your table, right-click|properties|permissions, this will tell you who can do what. If you can't see that much, then you _definately_ have a permissions problem :)
Also, be sure to check that you a re connecting in EM using exactly the same login details. Check the 'Edit server Registration' details for the server you're using in EM.
Reply With Quote
  #13 (permalink)  
Old June 6th, 2003, 11:49 AM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by chrislepingwell
 OK, in EM, find your table, right-click|properties|permissions, this will tell you who can do what. If you can't see that much, then you _definately_ have a permissions problem :)
Also, be sure to check that you a re connecting in EM using exactly the same login details. Check the 'Edit server Registration' details for the server you're using in EM.
Tried that it did not work. Thank you for your suggestion! :D

slypunk
Reply With Quote
  #14 (permalink)  
Old June 6th, 2003, 02:38 PM
Authorized User
 
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I FOUND OUT WHAT THE PROBLEM IS! I did not realize the tables did not have primary keys after I did that I am now able to add and delete records. Thank you!

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

Freakin' Access

The fact that the table doesn't have a primary key was a bad thing, but it *could* have told you that was the reason it wouldn't allow updates.

I'll note that a *real* database (like SQL Server) happily allows inserts, updates, and deletes to such a table. What's amazing is that the database *was* SQL Server, but Access *still* knew better than you what to do.

I've heard it said that it can take a database programmer a year to recover from Access poisoning. :D

(I'm happy that your problem was solved, though)

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
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 02:19 AM.


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