new_phoenix wrote: Is it even possible to open the Relationships Window and to enforce referential integrity programmatically? You can use T-SQL DDL statements to enforce referential integrity between tables. See this article[^] for more information. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

I have written a small query to illustrate how to do this. As you were polite in asking for an article and not the code (to be honest it's quicker for me to write the code than find an article). This example shows how to find all the animals in the zoo table that are not on the feeding table - I guess some animals are going to go hungry. :( select distinct z.animal from zoo z left join feeding f on z.animal= f.animal and f.animal is null Regards Guy You always pass failure on the way to success.

So - not stumped by the guaranteed stumper then.;) Deja View - the feeling that you've seen this post before.

You've asked your question in the wrong forum. This forum is for SQL/database related questions. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Does anybody have some code to separate the directory path from the directory path and file name combination? Please provide some assistance... try using dir() like this.. dir(txtOutputFilePath.text) im using it on vb6 hope it helps you..

you could just use string builder and build the thing yourself. Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

Could you explain where the configuration file is in Microsoft Access? I understand in a web application, there is a configuration file, but what about in a networked version of MS Access?

Here is what I did, and interestingly enough...it works. I created code that essentially does nothing but execute a loop and pass a counter to a control. Then I added a control to the form, left it visible, but essentially hid it from the form by making the textbox's background color, border color, and fore color the exact same as the underlying form color. This provided something for the processor to do while the QueryDef was being created. I essentially needed to count to 10000. Here is the code: 'Provides time to create QueryDef qryFinalResult Dim intCount As Integer intCount = 0 For intCount = 1 To 10000 txtCounter.SetFocus txtCounter.Text = "Count: " & intCount & "." intCount = intCount + 1 Next Does anybody have a more elegant way to do this? This code prevents that error message from coming up indicating that the QueryDef that I had just created does not exist. When I step through the code myself, the processor has enough time to create the QueryDef object, but when I run it as an application, it does not have time to create it in time to use it.

Can you not simplify your code with something like: UPDATE [TBLINPUTFILE] SET [NUMINDEX] = [Hyp].[NUMFOREIGNKEY] FROM [TBLHYPERIONMANY2] AS [Hyp] WHERE [Hyp].[COUNTRY] = [TBLINPUTFILE].[COUNTRY] AND [Hyp].[TYPE] = [TBLINPUTFILE].[TYPE] AND [Hyp].[BUSINESS_UNIT] = [TBLINPUTFILE].[BUSINESS_UNIT] AND [Hyp].[L_R_G] = [TBLINPUTFILE].[L_R_G] AND [Hyp].[REGION] = [TBLINPUTFILE].[REGION] AND [Hyp].[JOB_FUNCTION] = [TBLINPUTFILE].[JOB_FUNCTION] Regards Andy

new_phoenix wrote: Set rstHyperionMany = cmdSQLHyperionMany.Execute() The Execute method returns a read-only recordset. You should use the Recordset.Open() method and specify an appropriate CursorType e.g. adOpenKeyset to make your recordset updateable. Paul Marfleet

Thanks, Dave!!!

You probably want to use the ALTER TABLE .... in a query to do that. The following, SQL Tutorial[^] might be helpful. Though I've done databases for over 15 years, even I find it helpful for remembering some SQL that I use in rare cases. "Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus

Read my previous post again. If you don't understand it, explain what it is that you don't understand, instead of just repeating the contents of your original post. --- single minded; short sighted; long gone;