index > .NET Framework Data Access and Storage > can't insert data into database

can't insert data into database

I just got a problem about my web page(.aspx). I set my web page with VB.Net, the page try to get data and insert or delete data from a database. The database is Access file (.mdb),which was located in the directory of ~/www/App_Data/. Now, the page can get the data, but there was an server error when it was inserting a new row data or delete a row in the table in database. However everything is fine when I test the page in my computer with localhost. I just think the error was caused by the directory App_Data without the right for write, but I am not sure it.Could I get suggestion?

fenggang

Fenggang

please post:

code you are using to insert data

the specific errors you are getting when inserting data

Visual Basic 2005 or 2003? (shouldnt really matter for this really)

Need 2 be back @ MS - MS All the way! Follower since 1995 MS Super Evangelist| MSDN Forums Moderator

ahmedilyas

Thanks for your reply.I just solve the problem.It shoulb be caused by permission of the directory on server.

fenggang

Fenggang

reply 3

You can use google to search for other answers

More Articles

• Missing Schema Information of Base Tables in SQL 2005 Views

• Output File From DataSet.WriteXml() is Missing Elements

• How to make NextGen based windows application setup?

• The partner transaction manager has disabled its support for remo...

• Repeating name in namespace + classname, because I named dataset+...

• Concurrency violation while row exists

• data objects and their limitations

• SQLServer Backup

• writing image into word document in asp.net 2.0

• Same Problems

Welcome to Bokebb New Update

New Articles

• What is the maximum number of tables in
• Nobody can answer this question!
• UnExpected reflaction after Updating a t
• Errors creating new data source
• sqlserver 2005 connection with vb expres
• is it good practice to pass datagrid to
• Pulling Data From Two Different Databases
• DataSet thread safety
• How to test for Null values in ADODB rec
• Single DateSource - Multiple Databases
• SQL select with variable or an object
• No value given for one or more required
• Problem | Oracle 9i Release + With Vb.Ne
• Download Zip File from Sql Server
• Updating a DB and getting an id

Hot Articles

• wwhich version of ADO.NET for DB Mirrori
• When to use ExecuteScalar???
• The partner transaction manager has disa
• Concurrency Violation on 2 of 3 linked s
• ExecuteNonQuery asynchronously
• How to create a web services for retriev
• Retrieving @@Identity from Access databa
• how to use where clause in data adapter
• XML Schema Help with FIX 4.4
• Global Caching
• Trying to insert non-latin characters in
• Isolation.ReadUnCommitted Locking Proble
• Transaction
• Computed Columns in TableAdapters
• Merging datasets causes an exception wit

Recommend Articles

• Saving a Blob file into SQL Server with
• Update Statement - Syntax Problem
• Query about DataSet
• Reference to a field after record search
• Access to SQL Database via TCP/IP
• Replace a Select Statement
• Copying tables from a dataset to a SQL T
• DataSet Merging
• insert, delete, update in a datagrid and
• Crystal Report Linked to access database
• data objects and their limitations
• Referencing DLL's in the GAC
• An error has occurred while establishing
• System.Security.AccessControl Namespace
• FAQ