Hi, I have several access databases stored on a server and each user can access any of the databases in edit mode from their work stations - that is all but one. She can access every other databases stored on the server in edit mode but when she tries to open the one in question it will only open in read only mode for her (and her only - for everyone else it is fine). Does anyone know how to give her access to this database in edit mode also.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.
You say corrupt, in what way exactly? Do you get any specific error numbers/messages?
Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.
Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.
If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you. https://access.recoverytoolbox.com/
back up files on external hard drive!! mirror hard drive, will keep corrupted file, it might cause further problems. you have lost some critical files, but you might have isolated a virus . Move on, do a clean install, after reload the backed up files one at a time.
"The Microsoft Jet Database Engine cannot open the file '(unknown)'"There are several causes for this error message:
The account that Microsoft Internet Information Server (IIS) is
using (which is usually IUSR) does not have the correct Windows NT
permissions for a file-based database or for the folder that contains
The file and the data source name are marked as Exclusive.
Another process or user has the Access database open.
error may be caused by a delegation issue. Check the authentication
method (Basic versus NTLM), if any. If the connection string uses the
Universal Naming Convention (UNC), try to use Basic authentication or
an absolute path such as C:\Mydata\Data.mdb. This problem can occur
even if the UNC points to a resource that is local to the IIS computer.
error may also occur when you access a local Microsoft Access database
that is linked to a table where the table is in an Access database on a
Check the permissions on the file and the folder. Make sure
that you have the ability to create and/or destroy any temporary files.
Temporary files are usually created in the same folder as the database,
but the file may also be created in other folders such as the WINNT
folder. For additional information about how to identify which folder
does not have the correct permissions and how to configure temporary
files, click the following article number to view the article in the
Microsoft Knowledge Base:
Microsoft Access 97 database connectivity fails in Active Server Pages
If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.
Verify that the file and the data source name (DSN) are not marked as Exclusive.
"other user" may be Microsoft Visual InterDev. Close any Visual
InterDev projects that contain a data connection to the database.
Simplify. Use a System DSN that uses a local drive letter. If necessary, move the database to the local drive to test.
Follow the instructions in the following article to work around this problem:
FIX: ASP fails to access network files under IIS 4.0 and IIS 5.0
You could distribute your tables over a number of databases, and link them back into the original database. To do this, you can use the database splitter to get the initial setup, and then manually move some of the tables from the backen-database to a different database, and reling these moved tables into the original database.
Another good idea would be to move the backend storage to be SQL Server rather than Access, which would give you a more stable and more scaleable solution.
SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:- SQL Database Recovery
Whenever you open an Access database, a file with the same name as the database and an extension of LDB will be opened automatically. For example if you open Northwind.mdb in the samples directory of your Access/Office installation, a file called Northwind.ldb will be generated. This new file keeps track of users and the objects that require some form of locking in the database. When all users have exited gracefully from the database, the LDB file is closed down and deleted.
Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.
SQL Server runs on port 1433, so any firewall has to have it open.
Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.
Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.
Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.