Document and analyze your Access databases. Total Access Analyzer let's you understand how your database works and helps you find errors and performance bottlenecks. It includes the ability to detect over 100 types of errors and includes suggestions and performance tips. The comprehensive database analysis and documentation finds problems before you ship and lets you understand what's really going on. Total Access Analyzer performs detailed analysis of your Access database objects individually and as a whole. By examining your entire database, it discovers complex relationships among objects, hidden problems and even unused objects.
Easily compare Access databases. AccessDiff compares objects with the same name from two Access databases. It also detects missing objects in either the source or destination. Records are compared based on the primary key and if there is no primary key for a table, the comparison is performed on the Natural Key. After the database comparison is performed, the differences can be exported into several different formats.
A multi-database data management, query and design tool. Altova DatabaseSpy is a multi-database query, design, and compare tool. Altova DatabaseSpy is ideal for database administrators, database developers, and other database oriented IT professionals. Altova DatabaseSpy connects to all major databases including Oracle, IBM DB2, Sybase, MySQL and more. Altova DatabaseSpy eases SQL editing and table design for a fraction of the cost of single-database solutions. Altova DatabaseSpy includes features like table browsing, data editing, SQL auto-completion, visual table design, database content comparison, and more, which all save time and ensure accuracy.
A multi-database data management, query and design tool. Altova DatabaseSpy is a multi-database query, design, and compare tool. Altova DatabaseSpy is ideal for database administrators, database developers, and other database oriented IT professionals. Altova DatabaseSpy connects to all major databases including Oracle, IBM DB2, Sybase, MySQL and more. Altova DatabaseSpy eases SQL editing and table design for a fraction of the cost of single-database solutions. Altova DatabaseSpy includes features like table browsing, data editing, SQL auto-completion, visual table design, database content comparison, and more, which all save time and ensure accuracy.
Easily deploy and maintain Access applications. Total Access Startup lets you ensure your users always use the correct version of Access, and automatically update the local copy of your database when you release a new version. Centrally manage your Access applications for everyone on your network.
Create and send emails based on your data. Total Access Emailer allows you to generate personalized email for everyone in your table or query. Messages can be in text or HTML format with attachments. Total Access Emailer allows you to use field values in your email subject and message to create unique, personalized emails for each recipient. You can even maintain an audit trail to know who was contacted when with Total Access Emailer.
Control and manage your Access/Jet databases. Total Access Admin lets you quickly see who is currently logged into your database either directly or through linked tables. Databases can be password protected or secured through a workgroup file. You can also use Total Access Admin to prevent users from getting into a database, disconnect idle users, identify dropped connections, send messages to application users and other controls to manage your Access/Jet databases.
Compare databases and highlight changes. Total Access Detective is an object comparison wizard for Microsoft Access databases. Use it to determine exactly what is different between two objects in one database or between two databases. This is particularly useful when you need to compare two different versions of your database, or databases in multi-developer environments. Every field, control, property, line of code, etc. is compared and differences shown. There are even options to compare data in tables and permission settings.
Automate Schedule Repetitive Microsoft Access and Jet Engine Database tasks. Total Visual Agent is a Windows application that automates these chores on an hourly, daily, weekly, or monthly basis. You simply schedule the tasks and launch it. If a problem occurs, the system administrator is notified immediately by email. When using Access MDB databases, you must periodically compact, repair, back up, and monitor them to ensure optimal performance, recover unused disk space, and prevent data corruption.
Integrated useful code, developed over thousands of hours, into one package for your use. Total Access SourceBook gives you plug and play code you can use immediately. The code is fully commented with an on-line help system that includes examples. Use and learn from the code. For instance, do you need code to empty a table? Fix broken attached tables? Run a query? Convert numbers to text? Make Windows API calls? Or hundreds of other routines you simply don't have time to build and test?