<div>MySQL Question.</div> <div> </div> <div>I am working on an ERP implementation and I had something similar happen this/last week. I was able to modify one sql database from access but not the other. I turns out that there were "Triggers" in place that kept me from modifying the data directly. This is a data integrity issue so you need to be careful on what you modify. In my case I was pre-filling default fields to remove "null" values (putting zeroes in numeric fields for example).</div> <div> </div> <div>For a single table:</div> <div>Select the database you wish to work on.</div> <div>Using transaction SQL I was instructed to enter the following command:</div> <div>alter table part disable trigger all </div> <div>Then execute the command.</div> <div>Then I was able to modify the parts table.</div> <div>When I was done I was told to reenable the triggers this way:</div> <div>alter table part enable triggers all</div> <div>again
executing the command.</div> <div> </div> <div>Worked for me - perhaps this will point you in the right direction.</div> <div> </div> <div>Joe Lukasiewicz<BR><BR><B><I>nflug-request@nflug.org</I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Send nflug mailing list submissions to<BR>nflug@nflug.org<BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR>http://www.nflug.org/mailman/listinfo/nflug<BR>or, via email, send a message with subject or body 'help' to<BR>nflug-request@nflug.org<BR><BR>You can reach the person managing the list at<BR>nflug-owner@nflug.org<BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of nflug digest..."<BR><BR><BR>Today's Topics:<BR><BR>1. roaming linux (eric)<BR>2. Re: MyODBC (Tyler Poland)<BR>3. Ubuntu Mozilla help (Robert Stockdale IV)<BR>4. Re: Ubuntu Mozilla help (Jesse
Jarzynka)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Mon, 25 Jun 2007 13:38:02 -0400<BR>From: eric <ERIC@BOOTZ.US><BR>Subject: [nflug] roaming linux<BR>To: nflug@nflug.org<BR>Message-ID: <467FFD7A.6070605@bootz.us><BR>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR><BR>Can I use "roaming linux users" to connect to a Samba Domain, I <BR>apologies, but I do not know what else to call it but "roaming users" <BR>like roaming users in Microsoft... would I just change the login to <BR>authenticate with my LDAP server which would then plugin to the Samba <BR>Domain?<BR><BR>Thanks,<BR>Eric<BR><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Mon, 25 Jun 2007 17:55:08 -0400<BR>From: "Tyler Poland" <TYLER.POLAND@GMAIL.COM><BR>Subject: Re: [nflug] MyODBC<BR>To: nflug@nflug.org<BR>Message-ID:<BR><4cec6b150706251455u302fa025na78bf4d57a01339a@mail.gmail.com><BR>Content-Type:
text/plain; charset="iso-8859-1"<BR><BR>Rob,<BR><BR>I've never done that but this might help:<BR>http://www.washington.edu/computing/web/publishing/mysql-access-3.5.html<BR><BR>Could it be the part about selecting the unique IDs?<BR><BR>Tyler<BR><BR><BR>On 6/25/07, Robert Wolfe <RWOLFE@SHATTERIT.COM>wrote:<BR>><BR>> Hi all!<BR>><BR>> I know this is probably not the best place to ask this but thought I would<BR>> try anyway.<BR>><BR>> I installed MyODBC on my MS Access install at home. I can access my MySQL<BR>> databases just fine, however, I am not able to add any additional records<BR>> to<BR>> the database using Access 2003. I have all permissions on the database<BR>> set<BR>> correctly (everything checked).<BR>><BR>> Any assistance in this would be VERY MUCH GREATLY appreciated.<BR>><BR>> Thanks!<BR>> Rob<BR>><BR>> _______________________________________________<BR>> nflug mailing list<BR>>
nflug@nflug.org<BR>> http://www.nflug.org/mailman/listinfo/nflug<BR>><BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: http://www.nflug.org/pipermail/nflug/attachments/20070625/4a5abc8d/attachment-0001.html<BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Tue, 26 Jun 2007 08:29:51 -0400<BR>From: "Robert Stockdale IV" <BOBSTOCKDALE@GMAIL.COM><BR>Subject: [nflug] Ubuntu Mozilla help<BR>To: nflug@nflug.org<BR>Message-ID:<BR><2b8cfde80706260529r7b496b07ha7cc8c0d5ded1d4e@mail.gmail.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hi All: I seem to have a problem with Mozilla web browsers on Ubuntu. I've<BR>tried Mozilla, Firefox and Iceweasel. They all have the same problem. I<BR>change the behavior when the browser encounters a certain file type and<BR>something changes it back. For instance: I change the action to use Evince<BR>to open all pdf files. I must do this every time prior to clicking on
the<BR>file as something changes it back to Adobe acroread. Acroread never worked<BR>correctly and has been removed. All other action changes get replaced as<BR>well ( ie: shockwave, Quicktime, WinBlows Media, etc). It is as if a program<BR>constantly copies a default config file if it detects a change. Any help<BR>will be much appreciated. Thank you.<BR>Bob<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: http://www.nflug.org/pipermail/nflug/attachments/20070626/ba0f62e1/attachment-0001.html<BR><BR>------------------------------<BR><BR>Message: 4<BR>Date: Tue, 26 Jun 2007 10:18:32 -0400<BR>From: Jesse Jarzynka <DENISESBALLS@THECYBERSOURCE.COM><BR>Subject: Re: [nflug] Ubuntu Mozilla help<BR>To: nflug@nflug.org<BR>Message-ID: <46812038.7090900@thecybersource.com><BR>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR><BR>Robert Stockdale IV wrote:<BR>> Hi All: I seem to have a problem with Mozilla web browsers on
Ubuntu. <BR>> I've tried Mozilla, Firefox and Iceweasel. They all have the same <BR>> problem. I change the behavior when the browser encounters a certain <BR>> file type and something changes it back. For instance: I change the <BR>> action to use Evince to open all pdf files. I must do this every time <BR>> prior to clicking on the file as something changes it back to Adobe <BR>> acroread. Acroread never worked correctly and has been removed. All <BR>> other action changes get replaced as well ( ie: shockwave, Quicktime, <BR>> WinBlows Media, etc). It is as if a program constantly copies a <BR>> default config file if it detects a change. Any help will be much <BR>> appreciated. Thank you.<BR>> Bob<BR>><BR>> ------------------------------------------------------------------------<BR>><BR>> _______________________________________________<BR>> nflug mailing list<BR>> nflug@nflug.org<BR>>
http://www.nflug.org/mailman/listinfo/nflug<BR>> <BR>Try the MimeEdit extension - <BR>https://addons.mozilla.org/en-US/firefox/addon/4498<BR><BR><BR>------------------------------<BR><BR>_______________________________________________<BR>nflug mailing list<BR>nflug@nflug.org<BR>http://www.nflug.org/mailman/listinfo/nflug<BR><BR><BR>End of nflug Digest, Vol 21, Issue 31<BR>*************************************<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Take the Internet to Go: Yahoo!Go puts the <a href="http://us.rd.yahoo.com/evt=48253/*http://mobile.yahoo.com/go?refer=1GNXIC">Internet in your pocket:</a> mail, news, photos & more.