Access database operation software Research _ Database

Source: Internet
Author: User
Tags mdb database access database file permissions

This paper studies some software that does not use access to operate the MDB database, and summarizes the following.


1


This tool is available, can manipulate records, execute SQL statements, manipulate table structures, and create tables is probably somewhat difficult;


2



The software on the Internet, such as the above, is not available, suspected virus;


3


usable; almost 1;


4



This is the current may not install access, the MDB database operation of the most powerful software, but not as good as original access, design table features available;


5


This is not open the table, the estimate is a version problem;


6


This also can not open the table, estimate is the version problem;


7 available three tools to download

Http://pan.baidu.com/s/1slcKxzf


8. ldb files for an Access database

http://blog.csdn.net/wang379275614/article/details/7815728
When we open an Access database file, we find that a. ldb file with the same name will be generated in the same directory. Let's discuss the principle below.
The. ldb file is a temporary file that is generated when an. mdb file is opened. ldb files are important in a multiuser environment. The file is used by the MS Jet DB Engine (Microsoftjet database Engine) V4.0 to determine which record in the shared database is locked and who is locked
The. ldb file is automatically created and deleted by users of the shared database ... The LDB file establishes and stores the computer name, user name, and placement extension domain lock. LDB files generally with. MDB with the same name and with the. MDB files in the same directory, in the. The MDB file is created and locked when it is opened. When the last user closes the shared database, the. ldb file is automatically deleted. However, when the user does not properly shut down the database or the database has been marked as corrupted, then. The ldb file is not automatically deleted because. The LDB file is where the database is being used when the database is corrupted.
Remember to give. LDB the folder in which the file is located has certain permissions.
If you are ready to share a database, the. The MDB file should be placed in a directory where the user has read, write, build, delete permissions (NTSF format). Even if you ask each user to have different file permissions (for example, read-only or writable), all users who can share the data should have read, write, and set permissions to the directory, but you can assign the user to one. The MDB file only has read-only permissions.


Note: If you open a database exclusively, MS JET DB will not be established. LDB file, at which point the user's permissions on the directory require only read and write two permissions.
The contents of the. ldb file:


The MS JET DB ENGINE is available for each user who opens the database in a shared manner. An entry is created in the LDB file with a size of 64 bytes per entry. The first 32 bytes save the computer name, followed by 32 bytes to save the user name. The maximum number of users supported by the JET DB engine is 255, so. The ldb file size will not exceed KB.
When a user closes a shared database, the user is in the. Entries in the LDB file are not immediately deleted, but the entry is overwritten when the next user opens the database. That means you can't get through. LDB file to uniquely determine who is the current user of a database.


. How to use LDB files:


Used by JET DB ENGINE. LDB the information in the file to determine who locked the data and who is writing the data locked by someone else. If the JET DB engine finds a lock conflict with another user, it reads. LDB file to get the computer name and user name who locked the file or record.


In most locking conflicts, you will get a "write conflict" prompt and cancel your changes while storing the records. In some cases you will get the following tips:


Couldn ' t lock table <table name>; Currently in with user <securityname> on computer <computer name>.


Note: The above about. The information for the LDB file is not related to the database file. If one. The ldb file is corrupted and the database file is still functional. But in the hint message that writes the conflict <security name> This part you may see a string of unintelligible words.


9 about the green version of Access

My research on the green version of Access concludes that there is no green version that can be used under Win7. I had to drop it. A Access 2000 green

After decompression the situation follows;



Registry value, does an access have so many registry keys.

I copied all of the registry keys from Access, and my blog crashed, and then I deleted it.

Prompts the following error, cannot be used;




B Dragon's Green Access 2007


Can not be used under the Win7, pop-up following error prompts;




C Other Green Edition

Some downloads are just an update;

Some download to install a home version of Office, and no access;


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.