Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

synchronisation problem

guys, i have a FE and a BE. when i sync the BE by opening it up and choosing sync from the access application, it's ok. but when i try to sync via code from the FE, i get the problem "The search key was not found"

what can i do?

my FE has no tables and it's just calling the sync ability of the BE to the network database. help help

to me i think that the BE is ok cause there are no problems when i sync by opening the BE and sync. but the FE has problems syncing through code so i'm not sure how to isolate the problem. how do i find the corrupt record?
0
developingprogrammer
Asked:
developingprogrammer
  • 3
  • 3
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
That error almost always means that ... one or more fields in one or more records is corrupted. Usually ... a Compact & Repair on the db will fix this ... usually.

mx
0
 
pdebaetsCommented:
"Search Key was not found in any record"
Probably there are some bad records corrupting the table. Look for "chinese" characters in text fields. You can't delete these records unless you temporarily remove the table indexes, delete the records, replace the indexes.
0
 
developingprogrammerAuthor Commented:
k thanks guys. i think i will rewrite the whole app cause it seems like a random error for one team but not for the other
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
pdebaetsCommented:
Daily compact and repair may resolve the issue. Also, encourage users to close the application before disconnecting a network cable or pressing the reset button on the computer.
0
 
developingprogrammerAuthor Commented:
hrmm yup i think that could be a good way to do things. i gotta research more on C&R through code cause the last time i looked at it if i remember correctly it's quite hard to do it through code in the current database that you wanna C&R right? they were asking for another location that you wanna C&R to ha. and i don't wanna set it such that every single time they close the database it C&Rs. very time consuming
0
 
pdebaetsCommented:
Please see our free Application Starter utility at http://www.peterssoftware.com/aps.htm . With it, you can compact and repair a database when it opens for the first time each day.
0
 
developingprogrammerAuthor Commented:
Super cool!! I'll use it!! Thanks Peter!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now