Search results for query: *

Does anyone have any idea how to use a global variable in an ExecuteSQLTask or possibly any sample code? I have the variable setup through the property section and also have a Dynamic Properties Task setup to change the value of the global variable based on a query. I have 81 ExecuteSQLTasks...

We have tried publishing to our IIS 5, Windows 2000 web server via FTP using the web publishing wizard. Everytime we have tried it returns the error 550 Access Denied. We have granted the user full access to the FTP site and even made it an administrator on the server and we are still...

Is there a way to fail the entire DTS package based on whether or not a connection to another Database is established? We have had issues with the job still executing even if the server with the database is down. Any info would be appreciated. thanks!

I have already tried to import the tables into a blank mdb and I still received the original error message. I did find some code to try to find the corrupted row, but I was unsuccessful. We are looking into pulling it from a backup. Thanks for all of your help.

I downloaded that utility and I got the error: "Error Compacting database." Any other ideas?

It won't let us open it up to compact and repair. When I hold the shift down to open it the error message comes up. When we open up Access and select compact and repair and then select the database to compact and repair it brings up the same error. Any other ideas???

We have a database that everytime we try to open it, it gives the following error: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." I know that this is not possible since I copied the database...

We are trying to figure out how to enable users on the company intranet to run a CR8.5 report with parameters. Specifically, we need info on what tools we need and a description on how to, but any info would be greatly appreciated. Thanks!

Following is an example of my cross-tab: Week 1 Week 2 Week 3 Doe, John incoming 45 57 49 duration 180920 176543 169233 outgoing 11 22 33 Smith, Jim incoming 47 59 51 duration 180922 176545...

I setup a user as db_datareader and db_datawriter. When I logon as that user it allows me to view the tables and query them in SQL Server. However, when I try to access one of the tables through a web I am creating with that user name and password, it gives me an error of "Invalid object...

You can use the following query in MSAccess to format the date after they enter it. SELECT Format([YourDateField],"dddd"", ""mmm d") AS NameForYourDateField FROM tblDate; The help files in Access list the symbols available to customize your date. Hope this helps.

I am using an sql statement to pull values for each drop down box from the sql 2000 database. I just need to know how to make the second drop down box repopulate on update of the first drop down box. For example, once the user picks a state it provides the second drop down list includes all...

I am using FrontPage 2002 and connecting to SQLServer. I am using text fields for the users to update the database. I have a customer table, dealer table and purchases table. My first problem is that I need the customer number field to be entered into the customer table and purchase table...