Search results for query: *

Denny, thanks for your post... I am using the full UNC path. I believe it is some sort of permissions issue, but if the account is already a domain account with proper privileges, then what am I missing? drStealth

This is puzzling to me....we are on SQL 2000 SP 4, Windows server 2003. We have several DTS processes scheduled as jobs. When SQL Agent executes the job it reports as being "Successful". However, the file has not updated the data with the export as it should. The job is run using a domain...

Catadmin and SQLBill, thanks for your responses. We will look into the SQL profiler, we are not using it at the moment. As for rebuuilding indexes the answer is yes we are doing that with our production databases and you are right SQLBill this does fill up the tempdb. However, the processes in...

We have a recurring issue with the tempdb growing rapidly in a short time. We have set up alerts in the system to forewarn us of such an event, and we've successful in restoring the size of the tempdb to a manageable level before the tempdb fills up completely. Attemping to figure out the...

GOT IT Used a command button inside the subform. On click it refreshes the form. The data is now available in the combo box. Not ideal (I think they prefer this to happen without another button on the form) but it works. Thanks to all. drStealth

Norris68, This makes logical sense to me but the requery is not working. The data is in the table, I can see it immediately after it is updated. The combo box that needs to read this "refreshed" data is in the subform. If I exit and re-enter the database then it is available...

All, OK got another form/subform question today. In a form/subform structure I have a combo box in the subform which loads relevant values for a particular selection. Example, I'm working on an inventory database. In the subform the user can select from available model numbers and auto-populate...

Bob, as usual I tried to make it harder than it should be. Your suggestion worked like a charm, I appreciate the assist. Thanks. drStealth

Hello all, I have a form / subform structure working well. The intent is to enter multiple inventory items for each location. Example, one person's cube may have a workstation, telephone, printer. The Main form identifies the cube's code, the subform is linked to the main form by this code and...

Terry, thanks for the response, will try it out. drStealth

Everyone, I have a table with field ID as an identity, and another field Revision (both are PK, both integer). Many other fields follow. The idea is each ID can have multiple revisions. The problem is I don't want a user to have to enter data every time there is a new revision. I would like...

Everyone, I have not quite seen this in any posting.... Say I have a SQL table: Team League NY Yankees American KC Royals American LA Dodgers National Atlanta Braves National On an Access form, I have a combo box for the user to select the league, either American...

Samulayo, when I get the "record set not available" message, it has always been because I didn't have a primary key defined in the table. Current data will display but new data cannot be added. Make sure you have a primary key. drStealth

Jennifer, thanks for your input. The fields are currently in multiple tables but I do have a stored procedure that can be used where all the necessary fields are together. If code needs to be written (I assume VB), then can you or someone suggest a good book as a reference. I don't know VB and...

Hello all, I am working with an Access Project. I have an Access Form which is interacting with a SQL table. I want the user to select a value from a combo box, and then have the related data populate other fields on the form. This is frustrating because I got this to work in Access 97 using...

Hi everyone, we have SQL Server 2000 system and data files on one disk (disk A), and transaction logs and backups on another (disk B). We will soon need to replace disk B with a larger disk as it is becoming full. To transfer all logs to the new disk will require detaching the database, moving...

Terry, thanks for your response, a similar structure seems to have done the trick. drStealth

Hello all, this looks simple enough but we're having some difficulty in solving it: We have two tables with sample values as follows: Table1 Table2 A A B B C Y D Z We'd like to join these to create a result set that would show the...

Hello everyone, This seems straightforward enough but I'm having a difficult time getting this to work... We have SQL views and stored procedures which feed a MS-Access report. The report groups totals and gives the percentage of each item's total relative to the group total. Example: Total...

Rick, thanks for your input. I will run it by our Oracle guy and see what he has to say. Thanks for your time and effort to help us out. drStealth