How can i write query to a database.
I want to write query from the program and to save that query in the database stored in the hosting server.
I know we can design queries from MSAccess itself. But i have already uploaded my database to the server and write permission was given. If i upload again the permission will be deleted. So i want to save queries from the program and save it in the database. Becoz quries are pre compiled and retrieves data faster.
Like create view ... in oracle
Thanx in advance