Data Save error

GP Ver 6.0. Recently I am facing an error with normal users unable to save 
records, where as the system administrator is able to save the same 
information. Please advice on this error, what has to be done.

I have disabled the windows user ID of the Database owner. Thinking of this 
made Dynasa as the DBO.

Database is having enough free space available.

0
Matthews (19)
10/28/2004 5:29:03 AM
greatplains 29623 articles. 6 followers. Follow

3 Replies
528 Views

Similar Articles

[PageSpeed] 4

Hi

How big is the company database?  Is it over 10GB?

Regards

James
"Matthews" <Matthews@discussions.microsoft.com> wrote in message 
news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com...
> GP Ver 6.0. Recently I am facing an error with normal users unable to save
> records, where as the system administrator is able to save the same
> information. Please advice on this error, what has to be done.
>
> I have disabled the windows user ID of the Database owner. Thinking of 
> this
> made Dynasa as the DBO.
>
> Database is having enough free space available.
> 


0
10/28/2004 8:22:33 AM
Its about 6 GB still database has 4 GB free space.

Matthew

"James" wrote:

> Hi
> 
> How big is the company database?  Is it over 10GB?
> 
> Regards
> 
> James
> "Matthews" <Matthews@discussions.microsoft.com> wrote in message 
> news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com...
> > GP Ver 6.0. Recently I am facing an error with normal users unable to save
> > records, where as the system administrator is able to save the same
> > information. Please advice on this error, what has to be done.
> >
> > I have disabled the windows user ID of the Database owner. Thinking of 
> > this
> > made Dynasa as the DBO.
> >
> > Database is having enough free space available.
> > 
> 
> 
> 
0
Matthews (19)
10/28/2004 8:35:06 AM
Hi

Make sure all Great Plains Databases have DYNSA as the DBO.

Run the Grant70.sql script against all Great Plains databases and see if 
this helps

Regards

James


"Matthews" <Matthews@discussions.microsoft.com> wrote in message 
news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com...
> GP Ver 6.0. Recently I am facing an error with normal users unable to save
> records, where as the system administrator is able to save the same
> information. Please advice on this error, what has to be done.
>
> I have disabled the windows user ID of the Database owner. Thinking of 
> this
> made Dynasa as the DBO.
>
> Database is having enough free space available.
> 


0
10/28/2004 9:57:34 AM
Reply:

Similar Artilces:

Error on Inquiry/Sales/Transaction By Customer
Recently we upgraded to GP10 and we found an error just in one user, whe she run inquiry/sales/transaction By customer option and lookup a customer she got this error "Cannot Insert the value NULL into column 'ORTXAMT', table "temp.dbo.##....", column does not allow nulls. INSERT fails.[Microsoft][ODBC SQL server Driver][SQLServer] cannot insert value NULL into co " I have another user with the same security role and they do not have this error , even with the sa the inquiry run ok. I droped the user and created again and the error still persist. Any help ...

Filtering Error: "You Cancelled the Previous Operation"
I have a form that I've developed that shows data from all over my database, grouping it all together and displaying it for the user's ease of use. There are four status indicator columns on this form, each one either equal to "Green", "Yellow", or "Red". At the bottom of each column is a drop-down combo box I have added that allows the user to filter on a certain color, so they can see what records have a certain status. They can search on "Green", "Yellow", "Red", or "All", which removes all filtering. ...

Can I set a filter on the source data for a pivot table
I want to exclude certain records from a pivot table... i.e., Buy/Sell Quantity B 5,000,000.00 S 5,000,000.00 B 1,000,000.00 B 10,000,000.00 S 7,000,000.00 B 500,000,000.00 S 200,000,000.00 Only inlcude "B" records. Can a pivot table be set up to filter? Thanks ChrisP You could add the Buy/Sell field to the page area of the pivot table, and select B from the dropdown list there. ChrisP wrote: > I want to exclude certain records from a pivot table... i.e., > > Buy/Sell Quantity > B 5,000,000.00 > S 5,000,000.00 > B 1,000,000.00 > B 10,000,000.00 &...

XP Windows Explorer slows down saving of Excel files
My customer has a problem which I can duplicate on our own network (Windows XP Pro workstation and Windows 2000 Server). XP's Windows Explorer, if opened/displaying the same network directory where the excel files resides, will slow down the saving of the files significantly: from 30 seconds when explorer is closed to 90 seconds when explorer is opened in that directory. That time is for the saving of a huge Excel file (20 Megs). We would probably not have noticed it with regular (small) files. It is not a question of how the file is opened, either through Windows Explorer or through Ex...

Data import for custom entities
Hello I created a new entity (CRM 3.0) and i'd like to import a big amount of data for this entity. Unfortunately the import wizard is useable for accounts, contact, leads and campaign responses only. Have anyone an idea to import data for custom entities? Thanks a lot If you can't find any other ways to import data to custom entities, you probably will need to use Scribe or C360's import tool. Scribe have a data migration license for 30 days for as little as $500 I believed. Hope this will help. Darren Liu Crowe Chizek http://www.crowecrm.com On Jul 30, 10:28 am, Gerd Gott...

Purchase Order Error #3
The users are trying to get into the PO search to print off approved PO’s. Every time they get to the area of bringing up the PO thier machines locks up. We have checked and no one is in Dynamic’s entering PO’s at these time. If they try to end the task Dynamics closes. ...

Macros in Excel
I am trying to automate two function for multiple users of a series of microsoft files. While running a macro to create a new file for archiving specific data, I would like the user to be able to assign a filename while running the macro that creates the file. Is this possible? If so, how? Second, for the above mentioned file I would like to create a macro the automatically launches the send to mail recipient function, but allows the user to select the recipients from a corporate mail list while running the macro. Any help would be greatly appreciated! Thanks! Take a look at Appl...

Publisher 97 Startup Error
When I start up Publisher 97 recently, I have been getting a undialog.cpp error. How do I stop this happening? The only reference we can find to this error is in conjunction with ZoomText and how it handles clipart. Undialog.cpp Error Message When inserting clipart into a Microsoft Office application with ZoomText running, the Office app would display an "Undialog.cpp" error. This problem has been fixed in version 7.01. http://www.aisquared.com/Support/Index.htm My recommendation would be to re-install Publisher in safe mode. It is a programming error. Compact your Gallery, righ...

Referenced cell displays formula, not data
I downloaded a form template and linked it to my data; when I use the = sign to insert my data into the template, some – though not all – cells display the formula of the cell reference rather than the data that is actually contained in the cell Example: Cell D10 in datasheet contains text; instead of displaying the text in the template, it shows the following formula that is the reference address: ='[data sheet.xlsx]'!$D$10 -- MZ Press CNTRL + TILDE Key whch is available above the Left Tab Key. Tilde key (`) or (~) Remember to Click Yes, if this post helps! ...

ESM gives error c1030af0
Recently I changed the IP address of my server, and ever since I cannot view the properties of the public folders. When I attempt to I get an error: -------------- The operation failed due to an invalid format in the HTTP request. Verify that the host header is correct for the virtual server. ID no: c1030af0 Exchange System Manager -------------- I have already verified that IIS default web page IP has also been changed to match the NIC's first (of two) IP address. Make sure the web site in IIS that answers requests for Exchange can answer requests via it's own host name. I ha...

embedded object error (pdf file)
I have two new computers. Dell latitude laptop and dimension desktop. I am converting an excel file to pdf format and trying to insert it as an object in an excel file so people can double click on it and view it. I used to do this with my old laptop (purchased new in 2004 Dell Latitude) It worked fine with that laptop. I am taking an excel file and converting it to pdf format using a program I purchased called personal converter. Then opening the other file and clicking insert, object, create from file (and display as icon). I get the following error on the laptop "cannot insert objec...

Data Access Pages Data Source
I have several data access pages I created with tables as the source. The tables are in Microsoft SQL Server 2005 Express. I have since created queries and copied them into the database as a View. How do you change the data source from the linked tables to the Views? Thank you. it's not good idea to uase data access pages - they are not supported in latest Access versions. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Arturo" wrote: > I have several data access pages I created with...

How do I make a formula refer to given data even if I do a sort f.
I want to create a formula in a spreadsheet that refers to specific cells of data. However, I also want to be able to sort my data but keep the formula refering to the same information. IE, say I have a collumn of ten numbers. I would like to be able to have a formula take the average of the first 5 listed. If I then did a sort function of these ten numbers that changes the order of the numbers, I want my formula to have the same result because it is still referencing the correct information. ...

Referencing Data in a Pivot Table
I have created a pivot table which shows me total money spent in various accounting categories. I want to reference the sums this creates to subtract them from a total budget to give me a remaining total. Unfortunately, as the pivot table is updated, cell references change. This means that the total I used as say total spent on fuel may become total spent on salary. Can anyone help? You can use the GETPIVOTDATA function to extract data. Look in Excel's help for information and examples for your version of Excel. Brian wrote: > I have created a pivot table which shows me total mon...

Outlook Synchronization Error
Hi I have a problem trying to synchronize offline folders with the Exchange Server. I have a Exchange 5.5 - SP 4 (running on window 2000) and having problem with Outlook 2000(SR-1a) and 2002(SP2). When synchronization is completed, a synchronization log is created in the deleted folders as below. 12:12:00 Synchronizing Hierarchy 12:12:00 Synchronizing Favorites 12:12:00 Synchronizing Folder 'Inbox' 12:12:16 5 item(s) added to offline folder 12:12:16 Error synchronizing folder 12:12:16 [80004005-501-50A-550] 12:12:16 The client operation failed. 12:12:16 Microsoft ...

importing *.csv data into two columns
I have a data file that is delimited as comma separated values: escentially one long row of comma separated values. I need to import this long string into two columns: read two comma separated fields and start entering data into a new row and repeat. There are no empty cells as column 1 always has a matching value in column 2 for that particular row. I would appreciate any help. Thank you. Brian brian wrote: > I have a data file that is delimited as comma separated > values: ... I need to import this long string into two > columns: ... This looks like a job for Excel's ...

Status on one sheet w/ data?
How do I setup a stats (sum, count or whatever) on the same page as the data and yet able to sort the data at will? If I add a count, for example, at the bottom of the data, and sort, the "count data" becomes part of the sorting!! Is there a stats that can be setup like a page footer thing? Sorry, I am not good at excel in this regard. Thanks, Perry When you sort, select only the data and not the cells with the statistics ? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email <perryche@yahoo.com> wrote in message news:1186399300.3...

Error When Merging Two Records
Greetings! When trying to merge the contents of two records, our users get an error: "An error has occured. For more information, contact your system administrator" Which is followed by an IE Script Error: "'crmMergeForm' is undefined" At first I thought it was a permissions issue, however every one of our security roles has full rights on Merge in the Miscellaneous Privileges section. This error even affects those with administrative rights. Any suggestions? Thanks in advance. Herb I am also having this problem! Please help! ...

error 1706 running Office 2000 in Windows XP Home
Program is loaded. No problem starting in administrator log in. On a different user, starting Excel results in error 1706, but after clicking OK, Excel starts. What's the glitch? The information in the following MSKB article may help: OFF2000: Error Message: The Feature You Are Trying to Use Is on a Network Resource That Is Unavailable http://support.microsoft.com/default.aspx?id=224097 david wrote: > Program is loaded. No problem starting in administrator > log in. On a different user, starting Excel results in > error 1706, but after clicking OK, Excel starts. ...

Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key message. Here is what the message looks like. HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/WINDOWS/CURRENT VERSION/RUN/OPTIONAL COMPONENTS/MSFS Help! Have you tried completely Uninstalling it and re installing it? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] Microsoft Gold Certified Partner Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Second Opinion $15 - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com &q...

Saving spreadsheet with a Macro (VB)
Hi all. I am trying to write some VBasic code within Excel to save to the path as follows: C:\Documents and Settings\USERNAME\My Documents I know in windows world you would use %HOMEDRIVE%%HOMEPATH%My Documents, but I can't figure out the proper use within VBasic MsgBox CreateObject("WScript.Shell").SpecialFolders(16) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jon Arbuckle" <NOSPAM@Nospam.com> wrote in message news:46b9ea68$0$4696$4c368faf@roadrunner.com... > Hi all. I am trying to write some VBas...

error code "publisher cannot load files from a different version"
yes a popular error i know. but no i do not have norton basically the computer crashed, i had to reinstall everything, now previously made pub's on office 2k will no longer load on publisher 2k. or on another version of publisher 2k. i looked into the files and they do say publisher 3 embedded in the codes. i am at a loss as to what to do, i have hundreds of files , i havent checked them all of course Do an installer cleanup, Description of the Windows Installer CleanUp Utility http://support.microsoft.com/default.aspx?kbid=290301 -- Mary Sauer MS MVP http://office.microsoft.com/...

msinm.exe application error
I have Outlook Express running under XP Home edition. I keep getting a send receive error and when I close Outlook I get the message msinm.exe application error instruction 1x77f58d2c couldn't reference memory at 0x009a4760. Any thoughts/ cliff <anonymous@discussions.microsoft.com> wrote: > I have Outlook Express running under XP Home edition. I > keep getting a send receive error and when I close > Outlook I get the message msinm.exe application error > instruction 1x77f58d2c couldn't reference memory at > 0x009a4760. > Any thoughts/ Ask in an Outlook Ex...

Data Synchronization Error
When I go online with a few of my CRM For Outlook Clients I get a 'Data Sychronization Error'. I am then provided with three options: 1. Proceed with going online, but save the data changes offline for the next time you synchronize. 2. Stay offline and try to fix the errors so all the data will synchronize 3. Finish going online and do not save the data changes made offline Here are some error examples which appear next to each piece of offline data: 1. Invalid activity regarding object. It probably does not exist 2. the record you are requesting is currently unavailable Any help ...

query data
Hi. I am building an aviation database. I am want to create a flight summary query that shows only Carrier Date of Flight Origin Destination Miles Flight Hours However, my result is a line for each passenger - for example If there were three passengers on one flight i am getting 3 lines with 3 x the miles and 3 x the hours. How do I return only one line per flight. Also, I want to be able to show flight details with all passenger names for each flight. Is a subreport the answer there? Thanks, JF -- Message posted via http://www.accessmonster.com jefferysf via AccessMonster.com wr...