Well, first, LAMP is just a term for Linux with Apache with MySQL… Nothing more…
So, what you are saying is that you are using an Apache server with MySQL.
Most PHP sites use this or something similar. All normal…
But, MySQL is similar to a MS-SQL system. Only more generic. You are still talking about a SQL system.
.MDB files are MS-DB format. This is used for one thing. LOCAL databases in VB, VS, VC and Access formats… NOT SQL!!! It can NOT be done easily from SQL…
Not that I have ranted that out… There is a way or two that might work, but, a lot of crazy work to do so! You can have the server automatically run a VB app or Access app or VC app or other local application that would open both the SQL database AND the .MDB database. Then, that local-app could combine the data for you and copy the file to a second file that could be emailed or posted as a link for the user to download. This would require one of the above languages to write the local-app that the server could call to move the needed data form SQL to MDB. So, do you have someone on your team that can write a VB or VC or Access app? If so, what they would have to do is create a program that could be called directly (meaning a .exe file) and read the SQL database for instructions on how to get the data needed and create the new MDB file. This can be done. But, lots of work. The other way would be have the users just use the online system with access to the SQL database or create a program for them to access the SQL database directly. Well, I will be here on this site a lot the next two days , so ask away any more questions you need answers to. I hope I can come up with an easy solution for this tricky project… Good luck…
PS: Oh, there is NO “typical” LAMP or any other installation… They are ALL tricky… LOL