Search results for query: *

THANKS, the typos were the problem. Now that I got that working, I was hoping I could avoid the need to right the file altogether. <---Code-----> cn.Open application("dataconn") rs.Open "SELECT TOP 1 DocID, Doc_IMG, DocumentName FROM documents",cn,2,3 mydocument = rs("DocumentName") myBuffer =...

Same result, regardless what content type I use. Additionaly, what content type would you have for say (Autocad, paradox, word perfect, dll, tubo tax .tax files) these are just a few, there are thousands out there. -- bnhcomputing

I have the same exact problem. I even tried directly streaming from a file. The source DOC is valid, the destination is twice(2) the size, and all junked up as described.

<%@ Language=VBScript %> <% Response.Buffer=true Response.clear set st = server.CreateObject (adodb.strem") Response.ContentType = "application/unknown" Response.Addheader "ContentType", "application/unknown" Response.Addheader "Content-Disposition", "inline; filename=test.doc" st.open...

When VB6 or a portion thereof is installed, it potentially updates certain DLL’s that Microsoft considers operating system specific. Given this, I would expect the application to behave radically or even fail without the reboot. Another option that comes to mind, although I have not tested...

It would appear that you are using a DAO record set. From what I see in the MSDN documentation, this can be easily done using a ADO record set instead. The MSDN documentation talks about Hierarchical Cursors that allow this type of thing. Hope this points you in the right direction, good luck...

Been down that road. Progressbar.Refresh and Form.refresh. I put several of these statements throughout the loop. No change. Any other ideas?

I have an Access 2000 database that consists of two related tables, and a form/subform combination. If I open the database, I seem to be OK. However, if I open the main form, then the database is locked, and no one else can add data to the database. I have checked all of the “locking”...

I have a VB6 application. It reads data from an ASCII file and updates an Access database via an ODBC connection using ADO. The application works great. I added a form and some progress controls to inform the user as to what is happening. Sometimes the form is OK, but most of the time, the...

I am using MySQL in a client server environment with a VB client. I guess I'm more familiar with MS-SQL where a backup agent is used. If I just copy the files, what happens if the files get out of sinc during the copy? MySQL AB mentions an administration utility, but it doesn't look like this...

Sorry for not being more specific. Running on WIN2000, MySQL version 4.0.16-nt Thanks, Hubert

I need to backup my MySQL database while it is in use. What is the recommended procedure / tool for backing up MySQL without shutting it down? Thanks in advance, Hubert Hoffman

PERFECT!!! Thank you very much. Only have constraints on the Xref tables and when I delete from a main table, the Xref tables are all cleared out automatically. Thanks again for helping me understand how to read. Hubert Hoffman

If I remove the constraint from the employee table, then it is possible to remove records from the employee table without removing the records from the Xref table leaving alienated records in the Xref table. It was my understanding that the constraint with the cascade delete would prevent this...

I want it both ways, but lets just start out with the employee table. The way I read this is: If I delete a record from employee, then delete all records with the same employeeID from the Xref table. If I add records to employee, do nothing. Am I misreading? Once this works, then I will...

CREATE TABLE `employee` ( `EmployeeID` varchar(10) NOT NULL default '', `FirstName` tinytext NOT NULL, `LastName` tinytext NOT NULL, `EStatus` char(1) NOT NULL default '', `HireDate` date NOT NULL default '0000-00-00', `TermDate` date default NULL, `ReviewDate` date default NULL...

If I set the foreign keys, then I can not insert into any of the three tables. Without the foreign keys, then I can add records. EmployeeID 1, JobId 1, then I add a record to the Xref table 1,1. This works OK, but then there aren't any constraints. If I add the constraints before adding any...

Sorry for the lack of information. I am using: version 4.0.16-nt on a win2000 server innoDB is my table type. Hubert Hoffman

Table 1: Employee has employeeID and other info. Table 2: Jobs has jobid, jobtitle and other info. Table 3: EmplxrfJob Has employeeID and jobid only. I should be able to set a foreign key in all tables so that: Emplyee Table Employee added, OK. Employee deleted, cascade delete...

Additional Information: I have installed Office 2000 on a WIN2K server running terminal services. At this time the server has only the administrator user. This happens everytime I start Excel, and Only Excel. Thanks again, for any information. Hubert Hoffman