You want clean running computers The following best practices are primarily for multi-user Paradox applications. Problems begin if you use. Using sample Paradox file from samples: No thanks Submit review. This issue applies to Microsoft Windows NT 4. This site uses cookies for analytics, personalized content and ads.

Uploader: Mazubar
Date Added: 5 August 2015
File Size: 6.87 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 62973
Price: Free* [*Free Regsitration Required]

Up 0 Down Reply More Cancel.

Then after teh connection to the database has been created preform standard database fucntions like queries updates and inserts. Working and Private Directory Suggestion Some Paradox developers are recommending you set your working and private directories at least two folders down from the root. First connect to a variety of different database with ODBC connection strings provided by the plugin. Close ; Executing of cmd. BDESettingsRecommendations.

This site uses cookies for analytics, personalized content and ads. For example, although the following network shares resolve to the same location, we recommend all workstations use the same connect path. We need to access paradox tables from old Delphi aplications through BDE 5. I have heard that MS recommends it be turned off if using their desktop database Access, and have found what seems to be the source of that.

Other Threads

Articles by Mike Prestwood. Mike has authored 6 computer books and over 1, articles.


Business Database Applications A business database application is a multi-user application with 2 or more users A. First off, should you use Paradox tables for your data?

FireDAC & ODBC for Paradox and dBase tables. – Blog – Developer Tools – IDERA Community

Recent Microsoft Betas may be the culprit. Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community.

Because it is better to be safe than sorry, we’ve expanded the term best practice to include practices “believed” to be most appropriate under the circumstances. This note also applies if you are using a file server and occassionally access bbde Paradox tables using a BDE application installed on the file server.

So we had to manage our code to not use them. Or, you can Create a Free account now. Use indexed searches for speed powerful insert and update commands as well as robust reporting functionality. Install now to protect your privacy.

Client Programs Stop Responding – http: If your application connects to a database or works with data, then you really need to look at FireDAC. Browse the web up to 8x faster than Chrome and Safari.

If one system has the database mapped to drive “N”, then every computer with access to that database must also have it mapped to drive “N”. Do you recommend it?


parallel access to paradox via BDE and ODBC

Comment 2 of 3. Brave blocks unwanted content by default and keeps count. Do not ignore the “use a file server” standard already discussed, but if you do choose to go down that dangerous road, you must be sure that the computer that actually hosts the database does not use a local drive letter for data access nor for the NetDir. Use a file server not a workstation to store your data, disable Oplocks on the filer server, and configure the BDE local share to true and optimize if desired.

File based databases are still valuable and actively developed and marketed.

Should you stay with Paradox tables?

OpLocks are an additional protocol on top of the file-system locking protocol and was implemented pdbc performance reasons.

My belief is raising it to is fine for most modern users of the BDE. Thursday, September 8, 3: No thanks Submit review. Just reveal the connection string value so I can see how you are trying to connection.