Browse by Tags

All Tags » solution » access   (RSS)
02 May 2009
Solution to the “You tried to assign the Null value to a variable that is not a Variant data type.” Exception
By default the DataSource wizard passes parameters for AutoNumber primary keys. If you are getting this error: You tried to assign the Null value to a variable that is not a Variant data type. Then you need to remove that default parameter. This is what Read More...
1 Comments
Filed under: , , , ,
 
02 May 2009
Solution to the “Format of the initialization string does not conform to specification starting at index 0.” Exception
You are probably using the wrong DbConnection class. If you are using Access then make sure you use OleDbConnection, not SqlConnection…and vice versa. Alternatively you could be referencing your MDB file wrong. Here’s the proper way: <connectionStrings> Read More...
2 Comments
Filed under: , , , ,
 
06 April 2009
Solution to “Operation must use an updateable query” Exception when writing to an Access Database from ASP.NET
Could be a couple of things: The file is marked as read-only. Right click on file, uncheck “read only”. The application pool identity doesn’t have write permissions to the folder that contains the MDB. Find the identity of the application pool (using Read More...
1 Comments  
Page view tracker