Yes, the file that is not working properly has been converted to the accdb format.

Also note that if I open the file in 2007 (not converted) it is also not working. Of course, 2003 works fine. (I am running multiple computers with 2003 and 2007 loaded separately)

I am puzzled. I think I will try starting with a blank database and import all tables, forms, etc., into it to see if this fixes the problem.

– On a side note, I have noticed that several other databases that are being converted and in the accdb format are a bit “buggy” such that combo boxes and other controls are doing some odd things such as not populating or suddenly showing no data as if the rowsource was set to nothing. I wonder if the references have anything to do with this.

Any insight you may have would be welcome. I cant find anything on the knowledgebase and tried some other searches.

John,

I went ahead and created a blank database in 2007 and then imported all forms, queries, etc., from the 2003 database and everything is now working. I am not sure why the conversion process or saving to 2007 does not work properly.

One item to note however, when the 2003 database is saved to the accdb format, the references included both the microsoft office 12.0 access database engine object library and the library for DAO – I wonder if they are conflicting. When starting a blank db in 2007 and importing all objects, only the microsoft office 12.0 access database engine object library is used.

On an aside, the following webpage provides a good review of bugs in 2007 (some of which I have already encountered and sheds some light on some of my issues) http://allenbrowne.com/Access2007.html#Bugs%5B/url%5D

Thanks for the reply.

OK – I now give up.

On the accdb database that I imported all objects, the feature that was broken worked once properly. Basically, what happens, is the user presses a button that runs an insert into sql string to append data to a table. After working properly the first time (i.e., the append sql statement runs without issue) it then just does nothing. No errors, no debug issues, nothing, it just doesnt work. I know the code fires as I put in msgboxes so I can see what is happening. It’s only 9:38 and I am ready for a

OK, Here is another odd thing.

Whenever I open the accdb, the append query or insert into sql statement does not work. However, If I compact and repair the database, it then works fine time and time again. Now if I then close the db and then reopen it, it wont work until the db is compacted and repaired.

Beats me!

John,

Here is a work around that works (not sure why but it does) On the accdb that is having problems and the insert into sql statement does not work upon opening, I set the database to compact on close. After closing the db with it set to compact on close and then re-opening it, the code works as it should.

If I turn off the compact on close and then close and reopen the database, the code does not work. As long as the db is set to compact on close the code appears to be fine. I cant say I understand why this is happening but hopefully it will continue to work without issue.