I have use the trim function as part of SQL statements when reading data from a MS Access database. I have used this as part of search criteria in the SQL statement to make sure that any random spaces are removed so that matches are found. I am trying to read data from a SQL Server database and the trim function does not work because it is not a built in function. Is their any equivalent to the trim function that can be used with SQL server. An example of what i have used with access databases is as follows:
SELECT * from tblInfo where Trim(Rec_ID) = '" & sCrit & "'"
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…