jana
asked on
Can't find rows in MS Access 2007
We have MS Access 2007. A couple days back we noticed that a series of rows or product can't be found.
We would like to know if there is a way to certified that the products has been deleted?
Or is there any other way to search for the products?
We would like to know if there is a way to certified that the products has been deleted?
Or is there any other way to search for the products?
ASKER
FYI: we ran the repair option by running compact and repair
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We do have a backup; we'll check it out
Besides compact & repair, what other MS tools is there in Access?
We thought about the possibility that the items be in another table.
In MS SQL we have cnstructed a script (with EE assistance) that would sear the entire database for a specific value.
Besides the additional MS tools asked previously, can we have a similar script un Access? or how can we search for specific data within the entire DB?
Besides compact & repair, what other MS tools is there in Access?
We thought about the possibility that the items be in another table.
In MS SQL we have cnstructed a script (with EE assistance) that would sear the entire database for a specific value.
Besides the additional MS tools asked previously, can we have a similar script un Access? or how can we search for specific data within the entire DB?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So basically there is no script or internal opion for MS Access to search for a specific data; we have to do the search ourselves table by table?
You mention that there are some other things that can be done like Decompile; how does decompile help to recover or search the tables for lost items?
You mention that there are some other things that can be done like Decompile; how does decompile help to recover or search the tables for lost items?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
What about Decompile? Can it be used to help to recover or search the tables for lost items?
What about Decompile? Can it be used to help to recover or search the tables for lost items?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for your info.
ASKER
Thanx
ASKER
We are not expert in MS Access so we would like to troubleshoot this problem to determine if the items really doesn't exist in the Access DB.
We have a VB apps that works with the Access DB. When rhe apps indicated it couldn't find the items, we search directly on Access table to see if exist by clicking in the table item, right-clicking a row and selecting the filtering option as to "equals to", "between", etc. and the item just don't exist.
Since we are not expert in Access and since we have been told that MS Access is not as reliable as MS SQL, we need expert advice and guidance on this matter.
Thanx