 | |
access2007 - error 3251 - Operation is not supported for this type of object
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
access2007 - error 3251 - Operation is not supported for this type of object -
09-03-2010
, 06:36 AM
#2
| |||
| |||
|
|
I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? |
they're all there and nothing's marked "Missing". Also make sure DAO
is above ADO if you haven't specifically stated that an object is one
or the other.
#3
| |||
| |||
|
|
On Sep 3, 6:36*am, Roger <lesperan... (AT) natpro (DOT) com> wrote: I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? Sounds kind of like a reference problem to me. *Check and make sure they're all there and nothing's marked "Missing". *Also make sure DAO is above ADO if you haven't specifically stated that an object is one or the other.- Hide quoted text - - Show quoted text - |
using only DAO
#4
| |||
| |||
|
|
I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? |
apply any available Service Packs? That guess is based on an old KB
article and its advice:
http://support.microsoft.com/kb/247488
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
#5
| |||
| |||
|
|
On Sep 3, 7:36*am, Roger <lesperan... (AT) natpro (DOT) com> wrote: I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? This is a shot in the dark. *Did you turn off Name AutoCorrect and apply any available Service Packs? *That guess is based on an old KB article and its advice: http://support.microsoft.com/kb/247488 James A. Fortune CDMAPos... (AT) FortuneJames (DOT) com- Hide quoted text - - Show quoted text - |
name autocorrect is off
service pack is current
#6
| |||
| |||
|
|
On Sep 7, 8:14*am, "James A. Fortune" <CDMAPos... (AT) FortuneJames (DOT) com wrote: On Sep 3, 7:36*am, Roger <lesperan... (AT) natpro (DOT) com> wrote: I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? This is a shot in the dark. *Did you turn off Name AutoCorrect and apply any available Service Packs? *That guess is based on an old KB article and its advice: http://support.microsoft.com/kb/247488 James A. Fortune CDMAPos... (AT) FortuneJames (DOT) com- Hide quoted text - - Show quoted text - I checked both, and yes, * *name autocorrect is off * *service pack is current |
problems recently.
#7
| |||
| |||
|
|
On Sep 7, 3:06*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Sep 7, 8:14*am, "James A. Fortune" <CDMAPos... (AT) FortuneJames (DOT) com wrote: On Sep 3, 7:36*am, Roger <lesperan... (AT) natpro (DOT) com> wrote: I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? This is a shot in the dark. *Did you turn off Name AutoCorrect and apply any available Service Packs? *That guess is based on an old KB article and its advice: http://support.microsoft.com/kb/247488 James A. Fortune CDMAPos... (AT) FortuneJames (DOT) com- Hide quoted text - - Show quoted text - I checked both, and yes, * *name autocorrect is off * *service pack is current I think that one of the fields is returning a null. *I've had similar problems recently.- Hide quoted text - - Show quoted text - |
valid ?
since this happens with 'me.dirty = false', have you found a condition
where writing a null field causes a problem
#8
| |||
| |||
|
|
On Sep 7, 8:14*am, "James A. Fortune" <CDMAPos... (AT) FortuneJames (DOT) com wrote: On Sep 3, 7:36*am, Roger <lesperan... (AT) natpro (DOT) com> wrote: I've got a form based on a sql server table, the recordsource is * *select * from table where id = foo the form has textboxes, combo boxes - nothing special I periodically get error * *Operation is not supported for this type of object. ,DAO.Fields , 3251 when clicking a command button that does * * if me.dirty then * * * * *me.dirty = false * * endif the beforeUpdate event just checks that certain fields are filled in, popping up a message and setting cancel=true this was not occurring with access97, does anyone have an idea as to why this is happening ? This is a shot in the dark. *Did you turn off Name AutoCorrect and apply any available Service Packs? *That guess is based on an old KB article and its advice: http://support.microsoft.com/kb/247488 James A. Fortune CDMAPos... (AT) FortuneJames (DOT) com- Hide quoted text - - Show quoted text - I checked both, and yes, * *name autocorrect is off * *service pack is current |
http://groups.google.com/group/micro...d2e1ce344c9365
might give you some ideas.
What happens if you use a copy of your table and take the SQL Server
timestamp field out?
James. A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.