Link to home
Start Free TrialLog in
Avatar of smotbd
smotbd

asked on

500: How to query (Access database) for updated data only

Any clues on how to query for the updated data on an Access database? I just need to know what data has changed....

Is there a standard query for this?
(I am using Visual Basic or C# for connecting ad querying....)
Avatar of abel
abel
Flag of Netherlands image

There are several ways, but a standard query: i don't think so. The easiest way, I believe, is using a trigger and an update database. The second easiest way is using the system tables, but they don't keep track of all changes all the time.

The utmost easiest way: using a professional DAL like NHibernate which keeps track of changes for you.
Avatar of FrivolousSam
FrivolousSam

If you are changing the data yourself, getting the IDs of updated records is often pretty easy.  It's not clear what your question is asking...
Avatar of smotbd

ASKER

I am new to all this databse querying and some of the terms are unfamiliar to so I will look in to your suggestions Albel.
In the meantime let me clarify my question further:

An access database exists on an Internet enabled PC.
It is updated every 3 minutes from externel PCs.
The database records need to be sent to an online database (say MySql) for effective distribution to others.
Because the full database is large, the requirement is that only newly added records are updated

ASKER CERTIFIED SOLUTION
Avatar of abel
abel
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Lower grades usually means that you are not entirely satisfied. What is the information you missed? It's often better to come back and ask for more info. Without your info we never know what you need or want.
Avatar of smotbd

ASKER

Lower grades????
I answered 'yes' to the following:
Was the solution complete?
Was the solution accurate?
Was the solution easy to understand?

I also gave the grade 'Good' wich suggests that I thought the solution was good!! i.e. better than average but not quite 'excellent'. Everyone expects excellent but excellent may be defined as: 'Of the highest or finest quality; exceptionally good of its kind' .......and I'm afraid it was not quite that in my eyes......but I thought it was good none the less!!!
Aha, I see what you mean. Point taken. I usually consider "Good" to be "average" or "low" and "excellent" to be "quite ok". "excellent" with a remark and a compliment is what I take as "excellent", so I guess I'm just a little spoiled...  and I should reconsider that "good" means >> good ;-)
Thanks for the grade.  Good luck with your project.  -Jim