I had two tables Customer & Source which are linked by SourceID. The Join was an OuterJoin. There was no referential integrity between them.
In the Source Table, SourceID datatype was Number. I would like it change to AutoNumber Without any problem to existing data.
I am using ADO to connect to MDB file.
I did this one using Query...
I removed the relationship between the Customer and Source.
Created a TempTable with Source Table Structure with AutoNumber.
Deleted the Source Table
Renamed the temp table to Source
Till this it is working fine. But when I try to bring back the relationship, it has a referntial integirty problem with Customer table and query fails. When relationship is added exixting data are checked and the query fails.
How can u create the relationship between tables with NO REFERENTIAL INTEGRITY and with OUTER JOIN as the default join type. How do i create a query for this .
I need all this one in a query, since this will be executed together with my aplication and all the client database will update their database.
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.