Hi I am quite a n00b when it comes to databases but I know how to use MS Access. I am starting a small business and would need some help with creating a database online. I do not know any script language, so I would need to like export Access database and import it to something online. Then have a "website" which would serve like a "Database manager" and would have similar functions to Access. How would be the best way to start with this? Thanks alot for your help
MySQL database would probably be your best option... And then editing it through phpMyAdmin. It's not that hard and once you've learnt it you can make edits in seconds. Google it to find out more.
Which functions of Access are you looking at? Reports & forms or just tables and views? Ms SQL Express and MySQL are both free and both have free administration tools but neither are really as "complete" as Access if you wanting to output reports from it (rather than just CSVs) or generate input forms etc. Depending on the complexity of what you need it may be best to either learn something to create a front end (PHP or .Net - the latter has free drag and drop type of development application) or pay someone to build it in the first place and then learn as you go along to maintain it.
It may not be exactly what you are looking for, but Microsoft is releasing Office 365 soon, and I believe that allows Access to be used and updated through an online interface. That way you wouldn't need to learn a new system.
thank you all. I have tries many of these already. Is release date of Office 365 already known? This seems as a perfect solution!
try to export your database from access in cvs format and import it in mysql with help of phpmyadmin that you ll find in your cpanel admin section of your site.
I am now testing out navicat in combination with mysql database Do you know of anything similar to navicat that is opensource maybe?
I don't have a ton of MySQL experience (I prefer MSSQL), however I would recommend using MySQL Workbench in combination with MySQL for your database admin needs. Workbench is free and can do a lot of stuff through a sleek, fast, easy-to-use GUI (unlike phpmyadmin). You can get server logs and and performance reports, edit users and relationships using graphic references, populate data similar to how you would in MS Access, etc. On a side note, if you're interested in Microsoft's platform you can always consider using ASP.NET/MSSQL. They have a brilliant feature called gridview that lets you sort and edit records in your database from a web interface that you can custom design using C# or VB. There are tons of tutorials on the internet, I suggest checking it out.
If you can do something with mysql then it will be much better. otherwise you can check sql server both are good for online database.