I have a 3,600 record database split into front and back ends. Users have the front ends on their PCs. The database itself is in Access 2000 format on a Windows 2003 server box.
I also have a Microsoft Word 2010 document with multiple fields linked to a query in my database. To find the correct data to use in the Word document, I used a filter based on an indexed code that is assigned to each customer for which I want information.
Starting yesterday (March 28), any new customer entered in the database will not show up in the Word document. If I change information in an customer's record that existed prior to March 28, that information shows.
I finally have determined the query itself is at fault. If I run the query itself with the new customer's ID code, the query won't find it.
I've never run into a query that quit working like this. Anyone have any ideas? If you need more info to respond, ask away.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar