Compacting a live Access Database via ASP and ODBC
Can this be done?
chris_f
9:48 am on Sep 29, 2002 (gmt 0)
After reading this thread [webmasterworld.com] I got thinking. My site is not being hosted by me and as such I can not install any software on the server. I am using ASP with an ODBC connection. Is there any way I can compact my Access database via the ASP Script and ODBC?
Many Thanks Chris.
chris_f
2:03 pm on Sep 29, 2002 (gmt 0)
Any Help?
b4rney
3:01 pm on Sep 29, 2002 (gmt 0)
Yes it is possible. I do it all the time.
You should find loads of info and actual code examples if you search Google with your keywords (access, compact, asp, database).
chris_f
4:54 pm on Oct 1, 2002 (gmt 0)
The only pages I can find are non ODBC examples or they are not compatible because they require software installation. Some that do fit my criteria just plain don't work. I think I'll just the database offline for a minute or two until I can build a .net client app to do it.
