Recent content by JoJ

I understand now. Initially, I was under the impression that code/space management took precedence over individual website's independence. (For instance, in an environment with multiple sites, copies of identical scripts are found in each website folder. I then assumed that creating a "shared"...

Want to share your folder organization system? Here's a very basic one that I might use: shared> images> scripts> styles> site1> images> scripts> styles> site2> images> scripts> styles> Did I...

Some FSO functions I used in the past: Private Sub FSOSamples() Dim objFSO As Object Dim objFolder As Object Dim objFolderContents As Object Dim objFile As Object Dim strPathCheck As String strPathCheck = "c:\Current\Active\" Set objFSO =...

I can't think of a way to solve your problem with queries. But yes, try the whole process in VBA. Here, try this for starters: Dim rstClient As New ADODB.Recordset Dim rstOffice As New ADODB.Recordset rstClient.Open "Client", CurrentProject.Connection, adOpenForwardOnly, adLockOptimistic...

Access was chosen cuz I was hoping to be productive right away. (It's portable - plus I can administer the dB myself.) MySQL could be the eventual dB. For now, im still in the hunt for that "zero install" JDBC driver for Access.

Your problem might be better solved by using VBA code. Imagine a nested loop where your ZIP table is the outer loop and your Office table in the inner loop. In the inner loop, calculate the distances of each office and with an IF statement store the closest distance and update your closest...

Does anyone know of any JDBC Driver that: 1) is FREE 2) database=MS Access 2000 3) supports getGeneratedKeys() unlike the standard JdbcOdbc 4) doesnt require a full install (a simple JAR file download just like MySQL's driver would be perfect) Being a Java beginner, I dont know if im asking...

There's a number of Help Authoring tools out there. But I personally have not tried any in Access: http://www.google.ca/search?hl=en&q=create+help+authoring+chm&btnG=Search&meta= I have tired a trial version of this in vb.net last year http://www.helpandmanual.com/hmpage.htm Their website...

In this forum, I read a couple more of your tips in different threads. One was replaceAll("\\\\", "/"); and another about the forward slash being usable in both unix and windows. I applied those tips to my tests and am happy with results. For other members who might find it useful, Here's my...

I added the LOCAL option in the string, and that worked: sqlText = "LOAD DATA LOCAL INFILE \"" + fn + "\" INTO TABLE " + tb + " (line)"; I may not have realized it sooner if you had not gotten me to type the stack trace which gave me the chance to really stare at the drive letter V: -- Thank you.

Ill keep your mysqlimport.exe suggestion in mind. But at this point m curious as to how java, jdbc & mysql are handling the path. I cant cut&paste texts from the console so im typing the error stack portion that you might be looking for: java.sql.SQLException: General error message from...

My mistake ... m trying to construct a db application. Much of its source data (flat files, no delimeters) is to be loaded in a MySQL table (3 columns: trans#, batch#, line) on the network. [java 1.5 & MySQL 4.0 on XP's] I keep getting an SQLException. I pass something similar to the ff (i...

My first instinct is to send a "LOAD DATA INFILE ..." string to the executeUpdate() method. So far none of my tests seem to work. It may have something to do with Java's handling of the file path.

If the price is reasonable, I would like to upgrade to a newer Acrobat. Else, as you suggested, i'll reinstall 5.0. Thanks

Using the Change button in the Add/Remove Programs, I mistakenly removed a program (Acrobat 5.0, the writer) from the list. The entry is no longer in the registry ...Windows\Uninstall... Is there a way to restore the program back in the list?