Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rcollman

    SQL Connection err "not running at spec Port"

    I am making a Pervasive ODBC connection on a Novell 4.11 network. The client and engine seem to be pointed in the right direction where a DDF file exists. Had to Add programs, XP Standard and added MSQuery this afternoon. "Error during connection". It is telling me I can not get to...
  2. rcollman

    Access extracts into Excel - is there a way to automatically update?

    Dreamboat, Last week I was in Excel refining a project, making the command button for the person who could not remember to data >refresh. Decided I didn't like the refresh upon open but rediscovered the minute by minute option. My user is a picky person and likes to CYA. So I knew she would...
  3. rcollman

    Access extracts into Excel - is there a way to automatically update?

    Did you check out the External Data Range Properties? You can set it to refresh upon open or tell it how many minutes. I've only used the refresh on open. In the data range, this would be tool > get external data >External Data Range Properties. Or I recorded a marco and got this...
  4. rcollman

    Dumb ? Client-Engine help

    Humm. On my home/office NT network I was able to duplicate the problem. I can import a table into Access but get an error message with a Link file. The application can create a DDF file for each folder (each folder is a company) and this must have some workaround for their field naming...
  5. rcollman

    Dumb ? Client-Engine help

    "Somebody" moved a database that used pervasive from a workstation I will call WSPSQL (which acted like a server) to a Linux server. They also moved an Access database that does a simple file import on user demand. Why is WSPSQL the only workstation that can import a file into...
  6. rcollman

    ODBC call failed - MS Access 2000

    It could be many things and I offer moral support. These kind of non-specific error messages drive me nuts. I got this message a year ago because I needed to put in the IP address instead of the server name, while so called experts outside this forum "never had any problems" with...
  7. rcollman

    Slowed when moved

    Our hero discovered the cause. In ODBC (Control Panel > ODBC32) There is a tab called Tracing, with two confusing buttons in Win98. Make sure the button is toggled to read "Start Tracing Now", so that it is turned off. See the default SQL.log file? That is where all the activity...
  8. rcollman

    speed up

    Ditto above comment and a suggestion in the meantime. Turn the calculation mode to manual instead of automatic. Tools>options>calculations . You will get to know the F9 key but at least you can change data without waiting for it to recalc. I would edit>move sheet to a new workbooks and play...
  9. rcollman

    Slowed when moved

    Client moved a Pervasive database to a RedHat sever from a workstation. In Access I have a routine that imports 6 files and a button on the switchboard that triggers the process. Before the move, when Access, its databases and the pervasive databases were all on the workstation, it took less...
  10. rcollman

    Copy ODBC's to new PC

    Thanks for this tip, did not know about ODBC.ini Wouldn't it be nice just to copy the file from the old to the new. I think I see why that will not work when I look at my Pervasive links. Chris

Part and Inventory Search

Back
Top