PeggyBuckham Posted February 1, 2013 Share Posted February 1, 2013 I am unfamiliar with Microsoft Access databases. I am redoing a site for a customer. The old site was written in .asp and on a Microsoft Access databases database. I was given ftp access to the old site and it appears that the database is in a folder on a file with a .mdb extension. I am used to MySQL databases that I can look at the contents of the database in a browser. Can you please tell me is that not possible with a Microsoft Access database. If I want the content of the database so that I can use it to repopulate the new database. Should I just ask for a spreadsheet of the database or is there another way. Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/ Share on other sites More sharing options...
trq Posted February 1, 2013 Share Posted February 1, 2013 I am used to MySQL databases that I can look at the contents of the database in a browser. That isn't a feature of MySql, it's just that people have developed these interfaces to it. Access has it's own interface if you have some version of office installed. Have you googled though? There are asp based web interfaces available for these things. Hell you might even find a php one. Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409581 Share on other sites More sharing options...
PeggyBuckham Posted February 1, 2013 Author Share Posted February 1, 2013 Thank you for that answer. It seems like alot of work to go through just to get the data out of a database. I believe I will just ask for a spread sheet of the data. Thanks Again! Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409593 Share on other sites More sharing options...
trq Posted February 1, 2013 Share Posted February 1, 2013 It seems like alot of work to go through just to get the data out of a database If you want the data out of the database you can access it via php. If you* (the developer) can't get to the data, how do you expect your client* to get a spreadsheet? Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409597 Share on other sites More sharing options...
PeggyBuckham Posted February 1, 2013 Author Share Posted February 1, 2013 No I was not going to ask the client for a spread sheet, I was going to ask the old developer. So are you saying that I can use the same code to access a Microsoft Access Database as I do to access a MySQL database? I thought I had to use asp to access it? Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409607 Share on other sites More sharing options...
trq Posted February 1, 2013 Share Posted February 1, 2013 No, you use one of the mysql extensions to access mysql. Fortunately though, php as many database extensions that you can use to access all sorts of different databases. Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409615 Share on other sites More sharing options...
PeggyBuckham Posted February 1, 2013 Author Share Posted February 1, 2013 OK. Thank-you. I will have to do some reasearch...Thank You for your patience!! Quote Link to comment https://forums.phpfreaks.com/topic/273923-microsoft-access-databases/#findComment-1409620 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.