List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:February 18 2000 2:42pm
Subject:Re: Access 2000
View as plain text  
Forget about the decimal thing I mentioned -- that was right.  The problem
seemed to be with the "IS NULL" clauses -- I filled in all of the fields
that were blank and then Access had NO PROBLEM updating the record.  Is
there any workaround for this?

graeme

> humm, never mind -- this is affecting one of my tables without a "time"
> column.
>
> this is really frustrating :(
>
> I checked the log to see what Acess was trying to do before this error
came
> up:
>
> 000218  9:31:51     542 Query      UPDATE venues SET
> longitude=-1.19733183999999990e+002  WHERE id = 93 AND longname = 'Total
> Sports' AND address1 = '600 Spice Island Drive' AND address2 IS NULL AND
> city = 'Sparks' AND state = 'NV' AND zip = '89431' AND country IS NULL AND
> type = 'Ice' AND latitude IS NULL AND longitude IS NULL AND verified = 0
AND
> submittedby = 'JoAnn'
>
> as you can see below, "longitude" is a decimal -- I put "119.733184" in
> access, and the above shows it tried to put -1.19... I removed all of the
> clauses where it had "IS NULL" and then the query worked... weird eh?
> Hopefully someone can figure this out! :)
>
> mysql> describe venues;
>
+-------------+---------------------+------+-----+---------+----------------
> +----------------------+
> | Field       | Type                | Null | Key | Default | Extra
> | Privileges           |
>
+-------------+---------------------+------+-----+---------+----------------
> +----------------------+
> | longname    | varchar(50)         |      |     |         |
> | select,insert,update |
> | address1    | varchar(40)         | YES  |     | NULL    |
> | select,insert,update |
> | address2    | varchar(40)         | YES  |     | NULL    |
> | select,insert,update |
> | city        | varchar(30)         |      |     |         |
> | select,insert,update |
> | state       | char(2)             |      |     |         |
> | select,insert,update |
> | zip         | varchar(11)         | YES  |     | NULL    |
> | select,insert,update |
> | country     | char(2)             | YES  |     | NULL    |
> | select,insert,update |
> | directions  | text                | YES  |     | NULL    |
> | select,insert,update |
> | about       | text                | YES  |     | NULL    |
> | select,insert,update |
> | type        | varchar(30)         | YES  |     | NULL    |
> | select,insert,update |
> | id          | int(10)             |      | PRI | NULL    |
auto_increment
> | select,insert,update |
> | latitude    | decimal(11,6)       | YES  |     | NULL    |
> | select,insert,update |
> | longitude   | decimal(11,6)       | YES  |     | NULL    |
> | select,insert,update |
> | verified    | tinyint(3) unsigned |      |     | 0       |
> | select,insert,update |
> | submittedby | varchar(60)         | YES  |     | NULL    |
> | select,insert,update |
>
+-------------+---------------------+------+-----+---------+----------------
> +----------------------+
> ----- Original Message -----
> From: "Graeme B. Davis" <GraemeD@stripped>
> To: "Alok Dhir" <adhir@stripped>; <mysql@stripped>
> Sent: Friday, February 18, 2000 9:22 AM
> Subject: Re: Access 2000
>
>
> > Does your table have a column with the "time" type?  Mine does and I
think
> > that's the problem... ?
> > ----- Original Message -----
> > From: "Alok Dhir" <adhir@stripped>
> > To: <mysql@stripped>
> > Sent: Thursday, February 17, 2000 3:39 PM
> > Subject: Access 2000
> >
> >
> > >
> > > Hey all - has anyone come up with a solution for the problems with
> > managing
> > > MySQL data from Access 2000?  From Access 97 everything was fine, but
in
> > > Access 2000, adding new records works fine, but editing any existing
> > record
> > > always causes the following error:
> > >
> > > 'the record has been changed by another user since you started editing
> it.
> > > If you save the records, you will overwrite the changes the other user
> > made
> > > [...]'
> > >
> > > Even that would be fine, if the 'save record' option wasn't greyed out
> on
> > > this dialog box.  Furthermore, deleting an existing record always
> results
> > in
> > > the MS Jet engine stopping the process - very annoying.
> > >
> > > Any ideas?
> > >
> > > Finally, I've been unable to locate the 'Update linked tables' add-in
in
> > > Access 2000 - it is referenced in the help file, but I can't seem to
get
> > it
> > > to work.
> > >
> > > Thanks!
> > >
> > > Al
> > >
> > > --
> > > ---------------------------------------------------------------------
> > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> before
> > > posting. To request this thread, e-mail
> mysql-thread28144@stripped
> > >
> > > To unsubscribe, send a message to:
> > >     <mysql-unsubscribe-GraemeD=uu.net@stripped>
> > >
> > >
> >
> >
> > --
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
> > posting. To request this thread, e-mail
mysql-thread28224@stripped
> >
> > To unsubscribe, send a message to:
> >     <mysql-unsubscribe-GraemeD=uu.net@stripped>
> >
> >
>
>

Thread
Access 2000Alok Dhir17 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Graeme B. Davis18 Feb
  • Re: Access 2000Jan Legenhausen18 Feb
Re: Access 2000Christopher R. Jones18 Feb
Re: Access 2000Christopher R. Jones18 Feb
RE: Access 2000Alok Dhir18 Feb
  • Re: Access 2000Graeme B. Davis19 Feb
  • Re: Access 2000Jan Legenhausen19 Feb