How can I convert a .mdf to .mdb file? I have been looking and I cannot find a solution.
you can't just "convert" it.
kinda like trying to "convert" a SQL 2005 db to a SQL 2000 db. It's not possible.
There are ways to do it, but it's not as simple as "converting"
data is held differently between the different types of databases.
you would have to some how export the data from SQL and import it into an Access db.
but something tells me either that tech guy doesn't know what he's talking about, or the company just designed their software ass backwards.