Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
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
 
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.
 
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
 
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
 
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




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





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