See what programs use an access database

[petebob796]

I am trying to upscale several databases from mdb to sql server. Unfortunately I am not sure of all the programs that use these database tables. Is there a way for the mdb to store what programs request data from it or alternatively the username. Im thinking not but worth a check.

 

[Moniker]

There's not an automatic way, but the manual way would be to move the DB to a different location (different directory) and then run the programs that you think may be trying to access the DB. If they bomb, then yes, they want the DB.

 

[petebob796]

I thought that might be the only way the thing is I know the major programs that use the databases already just think I will forget something else that uses them, especially as I took over from someone else so am unsure of all the uses of the db.