Browse by Tags

All Tags » 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  
13 March 2009
How to copy tables from one Access database to another
It’s simple.  Use the import function. Open the destination database. Right click in the table pane.  Select Import.  Choose the origination database.  Choose the tables you want to import. Select to copy structure and/or data. Done. Read More...
2 Comments
Filed under:
 
Page view tracker