Databases linked to Master Database

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,934
We have a master database that holds a lot of data. We want to migrate this to SQL. The issue becomes we do not know who all accesses this database and what other databases/processes have links to this database.

What are your best way to determine what all connects to a master database? I can determine what this database is connected to, but have no idea what is connecting to this database if that makes sense.

We could rename the master table, but with the large volumes of data people may not even realize this table is not being updated. I could put in VBA to capture who opens the database, but I still don't think that would let me know who already has connections to this database.

Has anyone gone through this to try to determine what all links to a specific database?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,630
Office Version
2013
Platform
Windows
If you remove the database you will find out who uses it (or they will accept their fate and quietly go about things differently). That's the only good way I know.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,305
Messages
5,449,565
Members
405,571
Latest member
Flux1234

This Week's Hot Topics

Top