Search results for query: *

This is on behalf of WDP as he is away at the moment. The PC has 512MB already. It can happen in any mode, it will just sit there, then you can stop it and re run again, it may work or it may require you to repeat the process a couple more times. Cheers Dave Dave dab@completebs.com...

You can do fancy stuff in DTS but a straighforward way would be to bring the CSV data into a 'PreWash' table that consists of pure char fields where there is problem data, then add a process to the dts to execute a stored proceedure that uses convert to rewrite the problem field into a valid...

Hi, Have you tried using the Crosstab function assumeing you are using SQL7/2000. Look for 'crosstab' under Books On Line. Cheers Dave Dave dab@completebs.com http://www.completebs.com See website for more info but we can develop most things for most people.

Hi, If you added a Identity column the last record would be the highest value identity column for the Workobject group ie IdentityCol WorkObject 1 5666 2 5666 3 5666 4 5667 You can use the MAX(IdentityCol) in a select statement to find the...

Hi, You need to write the image in from the front end whether it be VB or Access or another, there is no way I know that you can do it with SQL itself, you could possibly break it into binary objects (BLOB) and write it into the field a bit at a time. The Northwind Access front end Employees...

Hi, I am having a problem where although the debug routine is active the debugger just executes the stored proceedure and then all of the actual debug controls are greyed out. I can set a breakpoint but it just ignores it and goes straight through. I am sure the permissions are ok because we...

Hi Mark I assume you are using a query for the basis of the report and have something like, Select * From MyTable Where Colour Like "Orange*" If you want records that contain orange the statement should be Select * From MyTable Where Colour Like "*Orange*" This looks for...

You could use a timer event on an Access form that is always open in the app ie Menu to check the table, but this requires the app to be running all the time. Or In the modules section goto references and find the Microsoft Outlook object library, this will then allow you to read and write...

Could you swich to transactional replication, this has an upper limit of 8000 Bytes, also make sure your column limit has not exceeded 256. Cheers Dave Dave dab@completebs.com http://www.completebs.com See website for more info but we can develop most things for most people.

Try also checking the opportunistic locking in the registry settings, see microsoft knowledgebase, the workstation os may need this setting correctly for performance on Novell. Dave dab@completebs.com http://www.completebs.com See website for more info but we can develop most things for most...

I have not used the AddListItems before, but I may be inclined to go back to basics and put a break on the setrst line and use ?qry in the immediate window to show the contents of the qry string, it may be better if you are not already doing so to also add qry = "" set rst = nothing...

I assume you are using the automation objects to write the excel out, i have experienced similar problems to this it seems to be due to the fact windows cant recognise the fact that you closed the previous instance of excel, make sure you have issued the = nothing statement for the excel...

You would need the Office Development Kit to distribute the system as a setup.exe assuming you wish to send out the Runtime as well. If you just want to send the mdb file and various docs you could get away with a commercial installation creater such as Wise Or InstallSheild. Remember if you...

This is the sort of thing you may need Sorry the formatings to pot but they have changed this site layout. The report to be run is set into a var and in the section marked ##### the report is sent to crystal fro printing but as a text file, in this app the report is printed out to disk as a text...

I am trying to run a stored proceedure on SQL 6,5 form VB6 with ADO, due to the size of the process the last one took 4 days, i would like to free up the VB app so that it can show the user things are still happining. I have acheived most of this with the use of adAsyncExecute but what i am...

Also how is the data being passed to and from the server odbc linked tables ado or stored procedures Dave dab@completebs.com http://www.completebs.com See website for more info but we can develop most things for most people.

This usually indicates the query you are trying to run cannot perform an update, either the table is open or locked by something else or if you have a multi table query it may not understand which field in which table it needs to update. Try simplyfing the query or try the same process on a...

Jim have you checked the file is not set to exclusive, if the front end is only installed on one machine and in View..Options..Multi/User..DefaultOpenMode = Exclusive, then only one user can use the database, either change this to shared or give the remote user a front end with tables attached...

If running on NT a quick fix is to map the J: drive on the server to the server drive the databases are located on. Dave dab@completebs.com http://www.completebs.com See website for more info but we can develop most things for most people.

Also you may want to look at the Raid Controller setup, sql 6.5 was not always happy to coexisit with one which had it's own cache on board, you may want to try running without this for a while if possible. Dave dab@completebs.com http://www.completebs.com See website for more info but we can...