Question about Compilers & Programming Tools

1 Answer

MS access database file sharing

I am using ms access in my database and it is used in a network. my problem is some clients are responding really slow... can you help me find ways to speed up the connection?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

There could be a shared-connections issue here, as well as a table-locking issue, if you are using linked tables, as I suspect you are. If not, how are connections being managed? And finally, it could be a network issue, though if you are using linked tabled and haven't set up a row locking policy, it is probably an app-level issue.

In short: More questions to answer rather than answers to the question. :)

Posted on Feb 27, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Some major factors in corruption of MS windows XP


Use Hiren Boot CD for recovery and many other purpose. Find below link for more info and download. Hiren Pankaj Homepage www hiren info

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

Tip

Access Password Recovery 5.0


MS Access is one part of Microsoft Office Package and it is one of the most popular database programs used in millions of offices worldwide. Password protection is an important feature that limits access to authorized personnel only and prevents strangers from obtaining confidential data. Unfortunately, people do lose or forget their passwords, making it impossible to access that data. Luckily, it does not mean that the data is lost forever. Access Password Recovery 5.0 will help the user to recover lost or forgotten passwords for MS Access database files. http://www.recoverlostpassword.com/products/accesspasswordrecovery.html

on Jul 12, 2010 | Compilers & Programming Tools

4 Answers

HOW TO SOLVE VFP FILE CURRUPT WHEN POWER FAILURE


At times, you may view that your MS Visual FoxPro 9.0 database is behaving abnormally. Some of the abnormal symptoms could be an error message while opening any database table, invalid characters in place of pre-defined values, and and more. The main reason for abnormal behavior of the database is its corruption due some logical crash. Few common reasons for corruption of MS Visual FoxPro 9.0 database are abnormal termination, faulty network devices, simultaneous modifications, conflicting third-party software, and incompatible service packs.
To overcome such database corruption scenarios, the user can use an up-to-date backup and perform restoration. However, restoration fails in cases where the user either forgets to create a database or the database backup itself gets damaged. In such cases, the database users can use a third-party DBF File Repair application to repair his/her corrupted database.
To illustrate the above case, consider a real-time scenario wherein you execute a query to modify your MS Visual FoxPro 9.0 database. While the query was performing the modification, the system shutdown due to power failure. However, the next time you tried to mount the database, you encountered an error message that did not allow you to access the database records. Moreover, the same error message appears every time you try to access the database.
Cause:
The root cause for the error message is MS Visual FoxPro 9.0 database corruption due to improper system shutdown.
Resolution:
The database corruption error message can be surmounted by following the below steps:
Use a complete database backup and perform restoration. However, in case of database backup unavailability, you will need to search for a commercial DBF File Repair utility.
A third-party DBF Repair application uses effective repair techniques to repair logically damaged MS Visual FoxPro 9.0 database and restore it at a new and safe location. The original database during the repair process remains intact. The tool is easy-to-understand and allows even a non-technical person to perform repair.
DBF Recovery Software is a comprehensive solution to repair databases created in MS Visual FoxPro 9.0, MS Visual FoxPro 8.0, and MS Visual FoxPro 7.0. The tool also repairs databases built in dBase III, dBase IV, and dBase V. Supported by Windows 7, Vista, 2003, XP, and 2000, the DBF Repair tool creates a new repaired file that can be attached to existing database.
Tanvi Sharma is a self employed Internet entrepreneur and product reviewer. This DBF Repair utility is extremely useful when the dBase and Foxpro database gets corrupted due to internal program errors, hardware malfunctioning, accidental deletion of data and more. This DBF Repair software repairs all types of database components including table name, column name, column data type, indexes and primary keys.

May 31, 2010 | Microsoft Visual FoxPro Professional...

1 Answer

How to connect c++ program to database


In order to use MS Access or any other SQL database you need to learn the SQL language -- or at least have a basic understanding of it..

Mar 12, 2010 | Microsoft Mlf Visual Studio Enterprise...

1 Answer

What is IBMDirector.mdb and IBMDirector.ldb? what is use for and how to removed?? Thank you!!


Anything that ends with .mdb belongs to MS Access and is a database file.

The IDMB is a massive database that deals with tracking movie information.

The ldb file signifies the database was opened at one point, and if not open now, was not cleanly closed.

You should be able to safely delete both of those files if you do not use the database.

Delete the .ldb file and then the .mdb file.

HTH
-Aaron

Apr 10, 2009 | IBM Compilers & Programming Tools

1 Answer

Choices available to create database of c++ program


Hi,

You should use the MySQL database as it is free to use and has great functionalities.

go to the belo link to get details about creating database and using in ur c++ code.

http://c-programming.suite101.com/article.cfm/using_a_mysql_databases_with_c


Thanks!

Mar 31, 2009 | Compilers & Programming Tools

1 Answer

Write into excel format


Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file

Feb 17, 2009 | Microsoft Visual Basic Professional...

1 Answer

Write into excel format


You can use ADO or SQL to open the excel file directly (provided it is constructed correctly, ie fields names) and write the data to it without Access.
That might be eaiser thatn converting it from Access to Excel, if that can even be done.

Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

117 people viewed this question

Ask a Question

Usually answered in minutes!

Top Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Florin

Level 3 Expert

733 Answers

Are you a Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...