Search results for query: *

Cool. I knew it had to be something straightforward but just couldn't figure out what it was. Thanks for your help

Is there any way that an automatic insert can be aborted from the Before Insert Event. I have a situation where records are being inserted into a status table automatically. As part of the before insert I am checking to make sure the effective date of the transaction falls within a prescribed...

Thanks for the suggestion but it didn't work. Still takes two minutes to track back to the first record.

Hi folks. I honestly wasn't sure which forum to put this question in. Has anyone else run into this problem. Two days ago, while adding a couple of new fields to a form, my application started exhibiting real performance issues. These fields were basically a check box and a text field that...

Thanks for the star! Glad you were able to use the solution. That's why I figured I would detail it rather than just say I got it resolved.

I have an Access application that accesses a SQL Server backend. The application is adding a record to the Customer table. Customer table has a Primary Key of CustID which is also an Identity (auto number) field. When a new record is added to the table Customer I need to be able to identify the...

Thanks for your response. Acutally, I was just double clicking on the link for the Customer table. That what was so weird about the problem. Guess what though... a co-worker discovered what the problem was. In the Customer table there is a bit field. The linked table in Access shows this as a...

Here is a strange one. I have an Access 2000 database that is linked to tables in a SQL Server backend via ODBC connections. There are about 35 links to SQL Server tables. One of these tables is a Customer table. I can add new records to the Customer table but if I try to update any fields on...

I was referring to the acutal connection object. Which is set up as the destination connection for the transformation. Is there another connection property in DTS that I am missing? How can you check to see if it is pointing to local or not?

Thanks for your quick response. It does reference 123 DB on server abc. There is nowhere (that I can see) that refrences server xyz in my DTS package.

I have run across a situation in DTS that is extremely frustrating. The package should be a simple one but there is an error which is holding me up. I have an Excel file that I need to import into a SQL Server table. The Excel file is located on my C:\ drive. The database "123" is on server...

Is there a function available to determine the last day of a given month? I've been searching and come up with nothing. TIA Greenfella

I almost fell over when I got these responses. Thanks for the link nimarii. Thanks for the example RickSpr. I'm going to have to put that in my code samples book. I eventually did figure something out for this problem although not nearly as elegant. Thanks again. Greenfella

Thanks for your help sfreeman. That did the trick. My Ubiquitous [[b{F1} (aka HELP) didn't list any details regarding Randomize or RND(). Guess the full help guide isn't installed on this machine. Greenfella

I was hoping to generate Random numbers within Access VBA but was unsure of how to go about this. The RND() function does not do the trick. Nor did the RANDOMBETWEEN function. Any light that can be shed would be greatly appreciated. Thanks Greenfella

Thanks for the help. Much appreciated.

My apologies... I think I have found where I need to perform this in EM.

Thanks for your quick response. I have been looking in Enterprise Manager but can't find where I would go to create the diagram. Any light you could shine would be greatly appreciated. As well, can Visio generate the database model or would you just manually create the model? Thanks again.

Is there any way that I can capture a data model showing the relationships between all the tables in SQL Server? Or would I have to create the data model manually? TIA

Thanks legos. In the words of Mr. Burns... eeeeeeeeexcellent. I knew there had to be a way that I was missing but do you think I could find it? Nope. Thanks again. Greenfella