How to monitor another access database file

I have no choice to switch to another database main because the database is being updated by a program which take reports through phone line via modem from other hardware pannels. But the company made the software is no longer exist.

The pannel could getting dail in any time of the day it could be few hours apart and also could be few seconds apart. Right now with my existing setup I am getting the information within 5 mins but I would like to have it in real time (1 min or less) since I ma using the application to email to blackberry email.

I will try the linked table methold and hope it worked.

Thanks

If db number 2 is not MS Access, another way to approach this is to add linked tables to the access db so that you don't have to copy data.

If you really need email sent out every time something gets updated, maybe a trigger in db number 2 is a better option.

Hi Mike

The main issue you're going to have is using Access - it's great for basic standalone data storage but not ideal for what you're trying to do here. Having never used it for a project, I can only Google around and give my input.

If you do have to stick with Access, have you tried Shared mode? It seems to be a built-in mode for allowing multi-user connectivity to an Access database. As your CF page would only need to read data and not write, you shouldn't run into any concurrency or locking issues.

http://office.microsoft.com/en-us/access/HP052408601033.aspx

You can't automatically check for new data per se, what you need is a database trigger. Access does not support database triggers

If it's important, then look to moving the data away from Access. If you can make do, use Shared mode and write yourself a function to check for new data in the tables and run it every minute or so.

Hope that helps

O.