Search results

I have a macro which runs some queries and some code. On one computer on the network it produces the correct results. With some example data that's 16,700 lines. But on another computer it doesn't work properly, and only produces 4250 lines. Both computers seem to be set up identically - they...

Well, after converting to Access 97 and back to 2002 (and re-creating all the groups manually) for a second time, it seems to have stopped doing it now. Although now there is a spearate strange problem, where on a particular query (either datasheet view or design view), it exits access...

It doesn't happen daily, but it has happened the last 3 Tuesday nights. This Tuesday I will try taking the 'compact on close' off.

It's only 1 table that is being affected, but there are many more in the db. There is only 1 index on the table (and that's not necessary). It's not replicated, and there's no referential integrity.

Because there's a lot of data! It gets archived to another db.

It has now done this at the same time for 3 consecutive weeks. Last week it went from 236,792 records down to 10,000. This week it went down from 361,320 to 265,000. We add data to the table every Tuesday morning, it's fine all day Tuesday, but first thing on Wednesday, it has deleted data...

I am using Access 2002, and there is no tab on the import dialogue for groups. I don't think there were groups in '97, not sure about 2000. The only way seems to be to recreate all the shortcuts in the new db one by one.

I want to import all the objects from a databse, and there are loads of object shortcuts. Any ideas?

I run a delete query to delete all the data from the table. The last time I did that was a week and a half before the disappearing data incident...

The data is all deleted monthly, before the first week of the month is added, and that is a manual process. Nice try, but it's not that easy :D

The table is used many times a day to run queries, and data is added weekly, so there are always at least 100,000 records in it, and always a different number of records, so it stands out because there are so few records in it, and that there are a round number of records. There are definitely...

Thanks for the reply. I will try importing all the objects into a new database. There aren't any relationships referring to that table, or anything that would make records disappear.

Hello. I am using a large database, which usually works fine, and is set to compact on close. Occasionally it has been losing a lot of data in the main table, probably when it compacts, down to a round number of records. This time it left me with 10,000 records exactly. (It has been different...