Jumat, 27 Juni 2014

[MS_AccessPros] append query inconsistent

 

Pros, I have a process that runs an append query within VBA.  The append runs in the front end and appends data from a linked table in one back end on a different server to a different back end (linked) but also on the same server.  98 percent of the time all the data moves across.  About 2 percent of the time, some records don’t move across.  There isn’t anything wrong with the records that don’t append as I can insert them by hand (caveat coming).

 

So I wrote code that does something like this:

1.       Check to see what items and how many should populate from one database to another (closing ecr’s populates to an eco tracker)

2.       Populate these items.

3.       Count the items that I expected to populate to see if they did on the eco tracker.

4.       If the numbers are the same, do nothing, but if not, then alert and insert info to an audit table.

 

Since I’ve discovered that data that didn’t go over from over 500 records, my assistant and I are rerunning the process to repopulate the table.  It works to repopulate, it seems, about 98 percent of the time.  Yesterday we both had problems populating within seconds

of each other.

 

So, I’ve been working with corporate IT to see if that server had any errors logged and they didn’t see any logged at the times in question.  Sheila and I tried several times, got pulled on to other stuff, and an hour and a half later came back

 

and then they populated just fine.

 

No change to the code.  No change to compact/repair any back end data.  I don’t see any processes that I have that would cause this to happen.

 

Any ideas?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar