Search results for query: *

hi guys, i hope you can help me, there is a stored procedure that i used in a filter form but it keeps timing out when i have over 20 users. I have tried optimizing it but i am stock can anyone tell me what else can i do? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE...

hi guys i had created an activex script that sends emails from sqlserver this is part of the code that pertains to my question: 'establish settings for sending of CDO message myMail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2...

hi guys i am trying to create a procedure that check if data in a column (NumberID) form view [ID CR Alert] exist in two different views i created. If it does'nt exist in view [Existing IDs] then to look in second view [Existing ShipTos], this is what i have so far... in first view i need to...

hi guys i hope you can help me. I have an access form in which i have a jpg in which when i double click i could open it with windows fax viewer from my windows xp computer, using this code: Dim S As Object Set S = CreateObject("WScript.Shell") S.Run "rundll32.exe...

hi guys, i am trying to connect to my backend tables in sql server 2000 from my front end access database and i keep getting this error message: Connection Failed: SQLState: 01000 SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()) Connection...

I am trying to setup an operator to receive a page when a scheduled job fails. I go to the Notification tab on the Job Properties window and select Page Operator, i added my pager number. After the job fails I never receive a page. I do receive the email, there is a pager tab in my outlook...

hi guys. i hope you can help me, i am trying to create a delete button in my form. Basically what this form has to do is delete the row from my main table and then insert that row into my history table. Main Table: tblDetails DistID (PK) SalesNumber SalesStatus (is always active) Notes...

hi guys i have a form in access, is there any way to disable the ctrl+ C feature? i already modified it so the tool bar doesn't come out but still the user can press the ctr+C and copy.

hi guys, i really hope that you can help me. I have a network access database, I created a report that runs correctly and complete in my computer but then when other users try to run the report eventhough it runs without no errors, it cuts a lot of the pages at the end. I thought maybe i could...

hi guys i have sharepoint and i am trying to put a link to my access switchboard form.. can someone give me an example of how the link/url should look like? this is how my url looks like right now: file://myservername/databasename.mdb first it gives me a message about an unknown publisher...

hi guys i have a form which displays an image for each of my products. according to which product the user chooses in my the table the images displays. Now is there a way than when the user double clicks for the image to open in windows picture and fax viewer? Any help will be greatly...

hi guys i am having an issue with my sql server. Now everytime i create a new database and i create a odbc conection to this database from my access front end for the user i only see the system tables and not the tables i created, is there something i am missing?

hi , i was wondering if you can help me, i have several dts jobs in my sql server. I have set them up to that if they fail to send me an email. Is there any way to set them up to send me an email if they run or freeze for a long time? for example from time to time i have this DTS that for some...

hi i have a question, i have the owner of a database in my sql server 2000 to be sysdba, i tried adding a user to this database by goint to EM and then going to the database , add user and just give the user reader rights to this database, then i linked this database in my access database front...

I am working on an Access Report that contains two subreports. My main report is based on a stored procedure in my sql server backend as well as an input form for my paremeter, my problem is that I would like the record source for my first subreport to be based on another stored procedure but...

hi guys , i have a dts that i run manually everyday, in which drops the table and then create it and makes a copy of it from another database. But i need to make a change in the dts to first insert a timestamp of when the data was inserted and that if the date is the same as the day running it...

hi guys! i am trying to change the owner of my dts but i keep getting an error: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'nameofDTS'. this is what i am using: use msdb go sp_reassign_dtspackageowner [@name =] 'nameofdts', [@id =] 'id', [@newloginname =]...

hi guys, i have a dts in which just copies tables from one database to another. If i run it mannually from EM i get no errors. I did a batchfile getting the command line from dtsrunui and it worked perfectly for a long time. but now i keep getting this error mesage: Step Error Source...

hi I run a DTS package mannually and would like to create a package log for it, how do i do that? thanks!