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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,645
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,099,134
Messages
5,466,867
Members
406,506
Latest member
Patb3

This Week's Hot Topics

Top