Link to home
Start Free TrialLog in
Avatar of broesi
broesi

asked on

How to log SQL-code run against MDB?

Hi Experts,

is it possible to log all SQL-statements executed against a certain MDB-file? Maybe something like the SQL Profiler for MS SQL Server?

broesi
ASKER CERTIFIED SOLUTION
Avatar of nico5038
nico5038
Flag of Netherlands image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of broesi
broesi

ASKER

It is the same old story: a programmer did a little tool that moves data around between several MDB-files. Now he left and all we have is this little executable (presumably created with Visual Basic). Of course the database structure changed and we have to re-create the little tool from scratch since we do not have the source code.

To make this task a little easier, I would like to see the SQL that is sent to the MDB's.

broesi
Avatar of nico5038
nico5038
Flag of Netherlands image
Them I'm afraid when he's dynamically creating the queries in code and that it will be impossible to get them.

Sorry for the bad news...

On the oher hand it's often faster to start from scratch to create an application as the time to find out how an old application works is considerable.

Nic;o)
SOLUTION
Avatar of dannywareham
dannywareham
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of broesi
broesi

ASKER

Found out myself:

1. Opened the MDB with Access 2000
2. Used the Upsizing wizard to move the tables to a Microsoft SQL-Server
3. Linked the tables back using their original names

Now I can use SQL Profiler to have a look under the hood...

Might not work with all applications, but for this one it does!

Thanks for your responses, I'll split the points...

broesi