Now that your database is split into a back-end and a front-end, (if you haven’t then read this article) you should be getting frustrated having to delete all linked tables and re-link them. This will need to be done each time you need to connect to test data, or live data, or the back-end is…
Splitting a databse is the third step in improving the speed of a Microsoft Access database. If you haven’t yet read or heard about splitting a Microsoft Access Database then either you are very new to databases or work in an I.T. department. Splitting a database is the process of separating the working bits from…
A helpful guide for time poor I.T. support staff and I.T. Departments who find themselves tasked with maintaining a Microsoft Access database.
Microsoft Access is able to be configured for multi-user functionality. Some people will simply put the whole database file into a shared folder, or on a network drive. Others will split the database into a front end and a backend, and put the front end on each user’s computer and link it to the backend,…
Our new installer only requires a single file to be downloaded, which can then be run straight away to install any of our applications. Like the old installer, it can still install the programs with standard user permissions. An administrator account is not required to run or install our programs. Due to most computer…
Launceston based, Microsoft Excel Support, Help for Launceston, Hobart, Devonport & Burnie Tasmania and National remote support. Fast and friendly MS Excel and Office 365 assistance and worksheet help and design. We specialise in Vlookup and spreadsheet lockdown because that’s what most of our clients request. Whatever your issues are, we can help. How can you get…
As a professional trainer who teaches clients how to build MS Access databases, I have seen quite a few different database applications. Good ones, have a few forms which can be easily accessed by a menu (switchboard) or better still a toolbar, with a variety of reports. One function in a database that is usually…
Astute consumers would already know of the lazy tax for insurance. That’s where failing to shop around and instead just renewing your annual policies can cost hundreds extra. Insurance companies are aware that policy holders are reluctant to switch insurers and are therefore keen to provide incentives, in the form of cheaper prices,to attract new…
When it comes to Microsoft Access databases, even with intense lengthy training only a few people, become capable of creating a usable database. But even these databases are not error free. Most office workers computers have Microsoft Office installed on them. That’s Word, Excel, Outlook, PowerPoint and in many cases Access database program. Most people…
Having had clients who have used Microsoft Access for over 20 years, I have seen more than my share of slow databases. They don’t start out that way. When they are new, with very little data, they run like the clappers. Then as the years go by, and more data and more users are added to…