So You Want To Upsize Your Access Databases?
1: Questions and other points to consider
2: Ways to upsize your back end databases
3: Ways to upsize your front end database applications
4: Reasons to upsize
1: Questions to ask about your current systems
o Does your company have ufabet 7777 many Microsoft access databases or just one or two critical ones
o Do you have a big budget or little one?
o Do you want a successful implementation?
o Do your business users want little changes or huge ones?
And finally …..
o How good is the data and the structure of the data?
There are many ways to upsize your access databases or migrating the data and or access application to another system. This article discusses all the different options plus shows how a combination of methods is often more successful and less expensive than the “let’s replace everything” approach.
Important considerationsIs the data in a separate database from the Application database? Firstly, if your access databases aren’t split so that you have one database for your data ( the back end) and one database for your application ( the front end system) then this should be done immediately.
Does your database structure need changing? Are there are separate tables for your customer details and your customer records? Often a system starts out with a simple table and details like addresses are repeated with each record. Normalising your data is a good practice if you are giving your system a good overhaul.
Is your data accurate? Often one starts investigating the database and finds that there is missing, duplicated and incorrect data. Fixing this is often a time consuming process and often the whole upgrade is avoided because of this. One can follow the 90 / 10 rule which states that only 10% of your data is used and needs fixing immediately. The other 90% can be done later…… That way you can implement a “better” system in a shorter space of time.
Are parts of your current access applications not used? Often many parts aren’t used because they weren’t “finished” or just weren’t what the business wanted. Firstly find out what isn’t used as these parts should be eliminated from the upgrade/upsize so they aren’t raised as issues later!
Are you running Microsoft SQL Server? You can upsize to Microsoft SQL Server 2005 Express the free but limited version of Microsoft SQL Server 2005, but if you have the workgroup, standard or enterprise version of Microsoft SQL Server 2000/2005 or 2008 then find out if you can migrate the backend databases to this.