Post reply

Access databases -- where are they hiding? .....

  • January 28, 2007 at 9:29 pm

    #171192

    I'm sure we have Access databases on computers all over the company where I work. I wouldn't be surprised if some of them were on drive "C" and therefore not backed up. Is there any way I can determine where these databases are (say by HOSTNAME?)

    TIA,

    Bill

     

     

     

     

  • January 29, 2007 at 5:03 am

    #686103

    I can't think of any way to do this other than brute force.  You need a list of computers on your network.  You need a user that is in each of the machines' administrators group.  Then you need a simply vb application to iterate through each and every folder on the drives to list the *.mdb and *.mde files.

    Russel Loski, MCSE Business Intelligence, Data Platform

  • January 30, 2007 at 4:25 am

    #686398

    Hi,

    First of all, you need to have administrative rights in every computer so you can search for files (Access files: *.mdb, *.mdw, *.mda, *.mde, *.adp, *.ade). Then, you could use the xp_cmdshell (undocumented?) stored procedure to search the computers on the network and backup these files.

    Hope this helps!

    Kind Regards,

    Kostas

  • February 1, 2007 at 10:10 am

    #687155

    Keep in mind that Access is a file-based database; it is not considered a "data server."  Therefore as mentioned above you are limited to searching the file system. 

    - Paul

    http://paulpaivasql.blogspot.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply