ryangus Posted March 27, 2012 Share Posted March 27, 2012 I often undertake IT audits for clients. I'm looking to automate this task and my research led me to Aida64. Is this product able to allow me to install Aida64 Business on a standalone client PC, and have the findings written to an Access database (perhaps stored on a USB drive)? I've installed it as a trial on my PC, and modified the DB preferences to point at the DB - Access.mdb file, but no data is written. Is there something I'm missing in the process or abilities of this software? 1 Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 Yes, it should be possible to do that. You need to choose MS Access 2000/XP/2003 as Provider, select the .MDB file as Database. Then you can create reports using the Report Wizard. Make sure to select ADO as report format. Regards, Fiery Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 I've tried this several times, but each time the DB remains empty. I've definitely chosen Access in the Database preferences, and DBO in the Report Wizard. This is in the trial version, as I'm not willing to buy it unless I'm happy with the DB functionality. Also, is it possible to run Aida64 without installation, particularly from a USB drive? Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 Make sure to use DB - Access.mdb file, not the Access'97 one. The trial version should be able to put the report into the database. No installation is required for AIDA64. You can use it from a flash drive or SD card if you want. You can even run it from a CD-ROM or DVD-ROM disc, although that way you cannot save data on the disc Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 I'm definitely using DB - Access.mdb file. The report runs, but nothing is inserted into any of the tables. Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 Do you get any message after the report creation process finished? Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 "Report has been inserted into a database. Report output is not visible" Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 It means it all went well. Go to AIDA64 / main menu / File / Database Manager to browse the reports that have been inserted to your database Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 I see it in Database Manager - I assumed it would end as as records in the mdb file. Not so? Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 It is there in the MDB file. A new line is inserted into the Report table for every reports, and a number of new lines inserted into the Item table for every reports. Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 Not in mine there isn't. Each table is empty. Very frustrating... but thanks for your help. Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 If all tables are empty, then it means AIDA64 inserted the report(s) not into the MDB file that you're viewing. Make sure to verify which MDB file AIDA64 uses for its database. Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 I've checked the database location in Aida64 many times, and can guarantee the database it's pointing at has no records in it. I've ensured hidden objects are being shown. The Report, NextID and Item tables are all empty. However, the last modified time/date on the database file aligns with the time/date of running a report. Very weird. Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 27, 2012 Share Posted March 27, 2012 Please let me know more about your software configuration: 1) Windows version with Service Pack release? Kernel type? (32-bit or 64-bit) 2) Installed MS Office version? Service Pack? Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 27, 2012 Author Share Posted March 27, 2012 Windows 7 64bit. Office 2003 SP3 Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 28, 2012 Author Share Posted March 28, 2012 Anything else I should try? Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 28, 2012 Share Posted March 28, 2012 Windows 7 64bit. Office 2003 SP3 We've done some test runs today on a similar configuration, but found everything working as expected. The only thing I can think of is reverting back to the original DB - Access.mdb file you can find in AIDA64 installation package. Make sure to verify if there is an Unblock button in the file's Preferences. If there's one, then push the Unblock button. Quote Link to comment Share on other sites More sharing options...
ryangus Posted March 29, 2012 Author Share Posted March 29, 2012 Repeated the installation process, and placed the database in a different location and it now seems to be accepting records. Thanks for your support. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.