problem with creating a database in win xp

[zeev]

hallo
i have to do a code in ASP that including this code:

set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"

and i am geting that error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4

what can i do?
thanks
zeev j

[Tammy B.]

if it access database then right click on database on uncheck read only

"zeev" <ze***@hotmai.com> wrote in message
news:05****************************@phx.gbl...

hallo
i have to do a code in ASP that including this code:

set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"

and i am geting that error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4

what can i do?
thanks
zeev j

[Tom B]

Try using a dsn-less connection.
http://www.connectionstrings.com
http://www.able-consulting.com/ADO_Conn.htm

I've not used MS Access in a while, but you may have to use ADOX to create
tables.
"zeev" <ze***@hotmai.com> wrote in message
news:05****************************@phx.gbl...

hallo
i have to do a code in ASP that including this code:

set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"

and i am geting that error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4

what can i do?
thanks
zeev j