1. Create a file on your desktop named FixRPSCXRef.vbs
2. Paste the contents from the FixRPSCXRef.vbs section below
3. Edit the contents of the file, and change the path to The Clients Path

dim conn
set conn = createobject("ADODB.Connection")
 
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\RPSCData\Store1\inventory.mdb"
'conn.open "DSN=Inventory"
 
conn.execute "Delete * from [s5_SubCatXRef]"
 
conn.close
 
msgbox "Done"