×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Edit Operation on Table Failed Accessing Sql Data

Edit Operation on Table Failed Accessing Sql Data

Edit Operation on Table Failed Accessing Sql Data

(OP)
Error: An edit operation on table SOP_Master_Number_Setup Failed accessing SQL Data.  Error was generated while in the Sales Trx Entry window.  Running Dynamics 8.0.  Sql Server 2000 on a Windows 2000 Server.  We have been having power outages quite often.  Just wondered what this error means.  I did run Check Links on this particular table.
Thanks in advance for your help!

RE: Edit Operation on Table Failed Accessing Sql Data

Since you've said you're experiencing power outages, my first suspicion would be a connectivity issue.  I would restart the client computer (or at least exit GP and go back in) and see if the problem persists.

If so, next question would be whether this happens everywhere (including the server) or just a particular computer.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

RE: Edit Operation on Table Failed Accessing Sql Data

(OP)
Thanks so much for the info.  It is happening everywhere.  When we have power outages like this.  What should I do?  Run check links?
Thanks!

RE: Edit Operation on Table Failed Accessing Sql Data

First thing I would do is put good UPS's on every computer and server.  smile

Running check links on all the series is a good practice in general after power outages, disconnects, etc.

However, since the message is complaining specifically about the Master Number Setup in SOP, you can recreate this table by following these steps:

1. Run the following against your company database in SQL:
Delete SOP40500

2. Run check links on the Sales series.
 

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

RE: Edit Operation on Table Failed Accessing Sql Data

(OP)
Thanks for your help!  Our old UPS crashed and the company is aware of the problem and importance of having one, but are not willing at this point to purchase a new one.  :(  That would definitely solve the problem!   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close