Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > Re: Access comp...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 2311 of 2443
Post > Topic >>

Re: Access complains : Update or CancelUpdate without AddNew

by maps.on@[EMAIL PROTECTED] (Andreas) Mar 21, 2008 at 12:49 PM

Richard Broersma schrieb:
> On Thu, Mar 20, 2008 at 10:20 AM, Andreas <maps.on@[EMAIL PROTECTED]
 
> <mailto:maps.on@[EMAIL PROTECTED]
>> wrote:
>  
>
>     ... event before update caused an error:
>     Update or CancelUpdate without AddNew or Edit
>
>
> This sounds more like a MS-Access Visual Basic Coding problem.  Any 
> ODBC related error messages are really PostgreSQL error messages that 
> are relayed to you.   What you are describing here doesn't sound any 
> thing like and ODBC or PostgreSQL error.
I think it's an Access issue, too, but one that is ODBC related as I 
never had this problem without ODBC.
I don't say it is a pgsqlODBC specific error.
I hoped someone here ran into it before and knows a tweak for psqlODBC, 
Access or anything to improve this thing.

It's not a VBA coding issue, since the whole data update is done by 
Access and the form that is bound to linked in tables.
No ADO-, DAO recordset stuff within my code here.

This form actually has a "before Update" procedure but it just inserts 
the current User-ID when the form was changed.
This happens everytime an update occurs and works perfectly next to 
everytime it is called.


Regards
Andreas

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
 




 2 Posts in Topic:
Re: Access complains : Update or CancelUpdate without AddNew or
richard.broersma@[EMAIL P  2008-03-20 22:08:53 
Re: Access complains : Update or CancelUpdate without AddNew
maps.on@[EMAIL PROTECTED]  2008-03-21 12:49:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 15:07:21 CST 2008.