Search results

The foxpro app continues to be used; however, I'm told that it's not very stable. The data in the foxpro free tables come with trailing spaces etc... For some reason, I don't trust the FoxPro ODBC driver link enough to build an entire application around them. I take it your experience has...

Is this approach folly? FoxPro, Access intermingling In my application, I will have tables originating from and periodically updated (serveral times daily) using existing FoxPro application data, alongside tables created and managed within Access. I.e. through a series of ODBC links and...

data type = hyperlink in design view of the table, set the data type for the field to 'hyperlink' in the field, right-click and go to hyperlink>edit hyperlink

new development it seems there were 2 fields in the linked table that would cause an odbc failure. After removing them from the make table query or the append query everything came out ok. Although, I'd still love to hear if there is a way to use the transferdatabase method. Thanks - Noel

I've been successful programmatically importing into Access a FoxPro free table using the TransferDatabase method on a specific dbf. However, there's another dbf in the same Visual FoxPro application that I want to do the same with, but with no success. I am, however, able to manually create...

thanks for the replies I think I posted indicating that I got the transferdatabase method to work using the odbc argument. My problem was related to the visual fox pro odbc driver, which I subsequently resolved...the correct driver is that which is dated 12/7/1999 (don't be fooled by a driver...

Hmmm Thanks. I need to be better at searching the forum first.

yes re: multi-user environment multiple users can open the FE, but only one user can open and operate the BE at a time. The BE mainly has a procedure to go out and get a foxpro table(s), import it into access and then update various access tables.

I'm deploying a frontend (FE) mdb and backend (BE) mdb in a network environment. I'm going back and forth with where the application tables should be stored. If I store them in the BE, then the update procedures that occur in the BE should benefit in terms of speed, but it seems the FE will...

I'm runnings some fairly straight forward FSO script to copy a file from one directory to another. I've read somewhere that some form of Resume Next (I'm using On Error Resume Next) needs to be put in the procedure as error handling. Are there other error handling scripts appropriate for fso...

numbers in the table the fields are: year week and both have data type = number (long integer)

addition info when the form and textboxes are unbound, then the functions work! THanks in advance for your input. Noel

I have a public function in a module that returns the week number (see below): Public Function Week(d) Week = Format(DateValue(d), "ww") 'Debug.Print Week End Function and, I have a form with a calendar control (ActiveX). When I pass the calendar control value (ocxCalendar.Value) to the Week()...

thanks folks I'll try out turning transactions off since I'm working with duplicate data (foxpro origin) anyway.

hmmmm I guess I didn't test thoroughly. The FE does infact complain when another computer has an instance of the FE open plus has the BE open exclusively; due to the fact that the tables are linked. What's an approach where the FE can continue to operate while the BE is in use? What if I...

sorry DJKarl, I forgot to ask When you say turn transactions off, you don't mean setwarnings false, right? Thanks. NOel

thanks DJKarl re: having to close the FE in order for the BE to be opened exclusively - The opencurrentdatabase does that for you without all the users having to exit. The tests I've run seemed to work. Thanks for the RunSQL and Execute ideas. Noel

Any thoughts on the best, most efficient, least susceptible to corruption approach would be greatly appreciated. The MS Access application is being designed as a multi-user (network) calendar app that uses data from a foxpro application. Specifically foxpro free tables (dbfs) that I'm...

the ascii character codes are as follows: ≤=2264 ≥=2265, I thought you could use them like chrw(2265) or chr(2265), but its not returning the right characters. Sorry

additional info along the lines of the other responses. Build your import specs by first doing a manual import (file>get external data>import) for each csv and save the spec (click advance somewhere along the manual import procedure) then refer to the import spec in the transfertext method