Resolving RDLC error: “The report definition is not valid” in Visual Studio 2012
I recently inherited a large number of RDLC reports from a colleague with the task to fix any issues before we go live. One of the first things I did was to write a quick “RDLC runner” console application to allow me to test the reports locally. The console program is a very simple .net 4.5 [...]
Removing the dbo_ prefix from imported tables in MS Access
When importing data from SQL Server using the ODBC connector in MS Access, your tables will end up prefixed with their corresponding schema. In most cases this will be the “dbo” schema. If you need to remove the prefix, these are the steps you need to follow: 1. Open your MS Access file (mdb or [...]
Deleting all data from an MS Access database
If you need to empty/truncate all user data from an MS Access database, the following VB script should do the job:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
Public Sub TruncateTables() On Error GoTo Error_TruncateTables Dim DB As DAO.Database Dim TDF As DAO.TableDef Dim strSQL_DELETE As String Set DB = CurrentDb() For Each TDF In DB.TableDefs If Left(TDF.Name, 4) <> "MSys" Then If Left(TDF.Name, 1) <> "~" Then strSQL_DELETE = "DELETE FROM " & TDF.Name & ";" DB.Execute strSQL_DELETE End If End If Next MsgBox "Tables have been truncated", vbInformation, "TABLES TRUNCATED" DB.Close Exit_Error_TruncateTables: Set TDF = Nothing Set DB = Nothing Exit Sub Error_TruncateTables: Select Case Err.Number Case 3376 Resume Next 'Ignore error if table not found Case 3270 'Property Not Found Resume Next Case Else MsgBox Err.Number & ": " & Err.Description Resume Exit_Error_TruncateTables End Select End Sub |
Happy coding…
Windows Azure Review
Windows Azure has been a godsend for developers. I have been using Windows Azure over the past few weeks and I have to say that the overall experience is amazing. I’ve used Amazon’s Web Services in the past and one thing that always marred the experience was the convoluted and often confusing website. What Windows [...]
Accessing local data files using Html and Chrome
During the development and testing stages of a new website, there are time when you may need to access Json or xml data stored in a local file. The test site can be running under Visual Studio, IIS Express or even IIS. I recently had to quickly test some javascript code that interacted with Json [...]
Follow Me On The Web!
