Microsoft Office Standard for PC Logo

Question about Microsoft Office Standard for PC

3 Answers

Microsoft JET Database Engine error '80040e09'

I have remove all the attributes of the mdb file. Now i have uploaded this mdb file on internet and my web page is generating the following error. .......................................... Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only. /malsha/CreatePricingCategory.asp, line 109 ..........................................

Posted by smchauhan on

  • Edward Paul
    Edward Paul Sep 22, 2017

    In order to fix access “Microsoft Jet Database Engine Stopped The Process “error you must try out these fixes. Just read here:
    http://www.accessrepairnrecovery.com/blo...

×

Ad

3 Answers

Anonymous

I had such a similar problem too with tale editor..i tried everything to no avail. then i studied the program SOLUTION: try giving full rights to IUSR or guestin the following files 1...ur data base 2....the asp page that tries to change database settings 3...the applicatin itself has a database change the rights there too MOE [email protected]

Posted on Sep 05, 2007

Ad

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 150 Answers

When putting files up on your hosted site (or on your own server), make sure the file and the directory have the proper writes to Read/Write/Create. A special file called the .LDB file must be created and if it can't a ReadOnly status could be issued. It's a file that contains the names of the users currently accessing the MDB file. It stands for Lock Database.

If you are running on Windows add these attributes, if it's linux (not sure why you'd use MDB on a LINUX box, but it would be chmod +777.

Posted on Nov 25, 2007

Ad

ZepMichael

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

This worked for me in a similar situation; make a copy of the .mdb file in the same folder. Delete the original .mdb file and rename the copy with the name you used for the original. This should get rid of the read-only aspect. Good luck.

Posted on Aug 30, 2007

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
4answers

I have a database in mdb format that will not open. When I try to open the file I get an error: The Microsoft Access database engine stopped the process because you and another user are attempting to...

You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more: https://access.recoverytoolbox.com/
1helpful
6answers

Database corrupted

You can use Recovery Toolbox for Access is used for recovering data from corrupted Microsoft Access database files with *.mdb, *.accdb extensions.

For more: https://recoverytoolbox.com/repair_access.html
1helpful
4answers

Damaged mdb 2010 file gives strange error message

First one apply short guide, second make use of http://www.mdb.openfiletool.com/ MDB Open File Tool
· Launch the Microsoft Access application, but do not try to open the corrupted MDB file.· Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.· Highlight the MDB file that you want to restore and click the "Compact" button.· Enter a name for a new database file, which will contain the restored data from the damaged MDB file.· Navigate to the location on your hard drive where you want to save the restored version of the file.· Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.
1helpful
6answers

Access database 2003 problem with a copy of database file. How to fix?

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/
1helpful
8answers

MS Access database recovery

Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

Or:
You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information: http://access.erepairtools.com/

If doesn't help, look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/933-ms-access-database-recovery
4helpful
11answers

How to recover MDB file?

You can try to use third party Access file recovery program to recover your lost and corrupted data from .mdb files. For more details about this software:-
Access File Recovery Software
12helpful
4answers

Error 3343 when I start PC Charge, how can I fix this?

error 3343 is a database error. Unfortunately, PCCharge is still in the stone-ages of computer technology and they think VB6.0 and MS Access 2.0 are stable and secure ... At any rate. 3343 is simply an unrecognizable database, in this case due to corruption. There is a program in the PCCharge directory called VisData. This will allow you to run a repair and compact the database. To use:
First make a backup of your PCCW.MDB database in your PCCharge directory (C:\Program Files\Active-Charge (PaymentServer); C:\Program
Files\PCCW (PRO)).

Execute VISDATA.exe.
File -> Repair MDB.
Select the PCCW.MDB database from your PCCharge directory.
Select 'No" to open Repaired Database.
File -> Compact MDB ... 2.0 MDB
Again, Select the PCCW.MDB
It will then prompt for what you want the database to be named. Simply select PCCW.MDB again, select 'YES' to replace existing database.
Select 'NO' to encrypt database.
Select 'NO' to Open Compacted database
Exit Visdata and start PCCharge.

It would also be a good idea to go ahead and update to the latest available Scripting Runtime library. This can be found by going to microsoft.com and searching for the phrase 'windows script'. (To my knowledge, 5.7 is the latest version).
0helpful
1answer

Remove error 0*80040e09 cannot update

When putting files up on your hosted site (or on your own server), make sure the file and the directory have the proper writes to Read/Write/Create. A special file called the .LDB file must be created and if it can't a ReadOnly status could be issued. It's a file that contains the names of the users currently accessing the MDB file. It stands for Lock Database. 
If you are running on Windows add these attributes, if it's linux (not sure why you'd use MDB on a LINUX box, but it would be chmod +777.

0helpful
1answer

Code for find the Ms access database size using visual basic

The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()
0helpful
2answers

Access problem

see if the LDB file still exist and delete it...

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.

thanks for rating
Not finding what you are looking for?

1,979 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2994 Answers

Mehandi Husain ...

Level 3 Expert

1654 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...