My scenario is this:
I have inherited a large access database, critical to a website. I need to do some work on the site which requires that I modify a number of tables and create a few ne querydef so support the work.
The obvious soluition is to ftp the db locally, modify the file and upload it. But If possible I do not want to do this. I don't want to lose data and I don't want to take the db offline.
So what I would like to do is create an aspx page which I can use to do operations like creae new querydefs. How can I connect to an access db to do these kind of operations As far as I can tell, the regular OleDbConn does not allow me to do these operations - rather I need to use the access object model.
I suspect there must be some utility out there on the internet to do this kind of thing (a bit like phpmyadmin). Does anyone know about this