Can't insert rows into table...

[frosty7700]

I'm getting the following message when trying to insert into a table from VB:

Record(s) cannot be added; no insert permission on 'tablename'

Where tablename is the table I'm working with. However, the permissions on the database are set correctly, and other parts of my program work just fine writing to the database.

I'm just curious to see if anyone else has ever run into this. The Microsoft Knowledgebase is sketchy on this.

 

[frosty7700]

By the way, this is w/ VB6 and Access 2000.

 

[mcentore]

You might want to try setting the Mode property of your connection object to Read/Write--->
objConn.Mode=adModeReadWrite

I've run into similar problems with other databases. Not sure if this will fix your Access problem, but if it defaults to ReadOnly you can't do inserts.