LucidSW - 2:51 am on Feb 18, 2011 (gmt 0)
> On Access one has to select which type of relationship
I think you mean Unique, Candidate or Regular. At least those are the terms used in Foxpro. I never specify this and it defaults to Regular. But all the IDs I mentioned are Unique. I think all it does is make sure they are unique but my program to suck the data in handles it although it may be good practice to actually set it to unique.
The service you mention will be impractical. The total number of pages I'm talking about is around 250k. Plus I wouldn't need to know the changes, just that something has changed in order to run queries on the different pages. Best to do it myself although I know checking them all would take about 7 hours based on recent tests. Obviously an overnight job. But there's no need to do it every night, just rotate once a month or every two months. That would be 10 minutes of computer time to check 4000 pages, something it can do while I take a break.