Microsoft Access

RE: DeadLock

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: how to do a Common Task with stored procedure

ccundy, Here is a link you may find of interest: http://www.algonet.se/~sommar/arrays-in-sql.html He has a couple of functions that convert lists into tables. --Lenard

RE: Saving Global Variables

You cannot save the values of the global variables from run to run. As for looping through global variables: Dim objPackage Set objPackage = DTSGlobalVariables.Parent For each objGlVar in objPackage.GlobalVariables Set objGVProperties = objGlVar.Properties strName = objGVProperties("Name").Value strValue = objGVProperties("Value").Value ' your stuff can be inserted ' here NEXT

RE: Protecting sensitive data

Hi Bill, I'll get in this ring first quote: It is a common (but bad) practice to take a dump of a production database, then restore it on a box for developer's to access (for testing, bug fixes, etc.) Some of the data could contain SSN, Driver's numbers, Names, etc and personal info that shouldn't […]

RE: Self referencing tables & Identity columns

The Identity Seed Gets incremented every time you insert a record! if you want to reuse the Identity value that you deleted then you must run: DBCC CHECKIDENT ('able Name', RESEED, 'reuse value') I believe that you don't have to drop the Foreign Key constraint, just be AWARE that you should be able to live […]

RE: A virtual drink for everyone !!!

Well done Frank. All that hard work's paid off. What are you going to do when they find out you're spending most of your day solving other people's problems... and you've been awarded EOTM by 27 other companies around the world? Cheers, - Mark

Display Defragmentation Of Selected Tables

This script will display the defragmentation of table(s) all indexes of selected tables and display a table/list of the DBCC SHOWCONTIG. It will aslo will report if there are tables in the list that can't be found in the current database. Run the script in the database where the tables you want to check are.Check […]

RE: Selecting data from a Fox Pro based LS

If anyone needs it here is a sample of how to use the where clause. You simply use double quotes. SELECT * FROM OPENQUERY(UNDERWRITING,'SELECT * FROM RS_INV03 where memb_num="01804-00"')

RE: help

Thanx mark. I tried Your solution and it worked out. Pay Respect to People on your way up. For you will meet the same People on your way down.