Recent content by necta

I am using Access as my database. Tha drop can be executed now but not the MSysObject.

Thanks for the tips but hv the following errors: When drop column: The database engine could not lock table 'Subject' because it is already in use by another person or process. When check if table exist: Record(s) cannot be read; no read permission on 'MSysObjects'. Where should i correct the...

Hi Travis, "ALTER Table Subject ADD COLUMN ( " & request.form("subjID") & " text (20))" The above code contains syntax error: "Syntax error in field definition" What I have done wrong? another question: How do I detect if a table already exist? Thanks again, Travis Necta

Hi, Tlhawkins Thanks for the tips, now I can create table with field. However, is it posssible to add subsequent field and to delete a field from the created table? How do I do that? Thanks. Necta

Thanks Thawkins. Its meant for the system administrator only.. Compare the two code snippets below, the 'NOT NULL' present in the first but the second one. Any difference between them? CREATE TABLE Contact (FirstName TEXT (20), LastName TEXT (20) NOT NULL, Address TEXT (20)) SQL = "CREATE...

I want to create dynamic table and its fileds by getting the field name from request.form. Can anyone show me how? Thanks

Hi, Tony, Where did i write to the client browser? I don't quite undestand.

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /wem/Insert.asp, line 30

Line 27:Response.Redirect("exmAdd.asp")

I have this problem but i couldn't see the cause. What could be wrong? Response object error 'ASP 0156 : 80004005' Header Error /wemes/exmDel.asp, line 27 The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content...

The result is the same: "5/20/2004

What i intend to do is display a date which stored in database....

I found out that it should be ...Request("marks[i]")...

I have problem insert/update sql statement in IIS (the statement…must be an updateable queries..) but not in win98. I wonder if anyone can help me with this. Thank you.

I intend to display date in dd/mm/yy but the system show mm/dd/yyyy. I have set the system date to dd/mm/yyyy. I am using Window XP. What should I do? Necta