Recent content by wingnut69

Hi Galaxiom Your explanation is more sound than my hypothesis. Just one question. When I Set qdf = nothing I thought that was the equivalent of blowing it away, never to be seen again. Please correct me if I'm wrong but I still don't understand why something which I thought was no more at...

Yes. I was a little amazed myself, especially as the variable strINSERT gets destroyed as soon as the sub is exited. That's why my guess that there must have been some background checking prior to inserting the data sounds correct. It could be a case of over engineering by Microsoft as it...

Re: Error 2196 "Object already exists" Solved My suggestion worked. I now have a totally useless field for Postgres called 'dummy' and Access happily increments it by code and then inserts it. How can I close this thread?

Hi I am building a small database using PostgreSQL as the back end. I am trying to programmatically insert data into a table. I have done this more times than I care to think about but this time I keep getting this error 2196 Object already exists" The table is a 3 column table with PK, data...

Hi. Being new here I'd like to introduce myself. I'm 69 years old and have been using Access since 1993. However, I haven't used it for the last decade so I am in the process of remembering a lot of what I have forgotten. Thank God for Google! The reason why I have returned to Access is that...