Microsoft Access - Recent Questions, Troubleshooting & Support
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.
on Apr 15, 2019
How to password protect .mdb, just one table
1. open access. 2. From file menu select open => select the location of .mdb file and while selecting open option you notice a small triangle. Click that triangle and select open exclusive. after file opening go to database tools and select set database password. give the password and save it. Thats the procedure
on Apr 10, 2019
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/
on May 04, 2017
Want to populate a form with data from a table,
Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.
on Oct 16, 2010
What is run time error '-2147467259(80004005)' how
"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
on Oct 16, 2009
Unable to import text file to access table
Hey everyone, I was able to fix my problem using the following:
filnam = Me![Text2]
Set objFile = CreateObject("Scripting.FileSystemObject")
Set objText = objFile.OpenTextFile(filnam)
Set rs = CurrentDb.OpenRecordset("FlatFileImport")
once = False
If Not IsNull(Me.Text2) Then filnam = Me.Text2
Open filnam For Binary As #1
Do While Not objText.AtEndOfStream
strTextLine = objText.Readline
Data = Split(strTextLine, ",")
If once Then
rs.Fields(1) = Data(0) 'Site ID
rs.Fields(2) = Data(1) 'Client ID
rs.Fields(3) = Data(2) 'Client Name
rs.Fields(4) = Data(3) 'DDA Account
rs.Fields(5) = Data(4) 'Process Date
rs.Fields(6) = Data(5) 'Good Checks Singles
rs.Fields(7) = Data(6) 'Good Checks Stubs
rs.Fields(8) = Data(7) 'Good Checks Partial
rs.Fields(9) = Data(8) 'Good Stubs Partial
rs.Fields(10) = Data(9) 'Good Checks Multi
rs.Fields(11) = Data(10) 'Good Stubs Multi
rs.Fields(12) = Data(11) 'Check Only Checks
rs.Fields(13) = Data(12) 'Check Only Stubs
rs.Fields(14) = Data(13) 'Check And List Stubs
rs.Fields(15) = Data(14) 'Check And List Checks
rs.Fields(16) = Data(15) 'Suspense Checks
rs.Fields(17) = Data(16) 'Suspense Stubs
rs.Fields(18) = Data(17) 'Correspondence
rs.Fields(19) = Data(18) 'Envelopes
rs.Fields(20) = Data(19) 'Express Mail
rs.Fields(21) = Data(20) 'Lookup Stubs
rs.Fields(22) = Data(21) 'Online Lookups
rs.Fields(23) = Data(22) 'Stubs Only
rs.Fields(24) = Data(23) 'StopFile Hits
rs.Fields(25) = Data(24) 'SLC
rs.Fields(26) = Data(25) 'SL2
rs.Fields(27) = Data(26) 'MICR Scanline
rs.Fields(28) = Data(27) 'KeyStrokes Correspondence
rs.Fields(29) = Data(28) 'Keystrokes SLC
rs.Fields(30) = Data(29) 'Keystrokes SL2
rs.Fields(39) = Data(38) 'Exception Queue
rs.Fields(40) = Data(39) 'COA Queue
'IMAGE ARCHIVE ITEMS
rs.Fields(41) = Data(40) 'Image Archive Reports
rs.Fields(42) = Data(41) 'Image Archive Storage
rs.Fields(43) = Data(42) 'Batches Processed
rs.Fields(44) = Data(43) 'Low Speed ARC Attempts
rs.Fields(45) = Data(44) 'High Speed ARC Attempts
rs.Fields(46) = Data(45) 'Low Speed ARC Converted
rs.Fields(47) = Data(46) 'High Speed ARC Converted
rs.Fields(48) = Data(47) 'ICL Attempts
rs.Fields(49) = Data(48) 'ICL Converted
rs.Fields(50) = Data(49) 'ICL Non-Conforming images
rs.Fields(51) = Data(50) 'Auto Returns
rs.Fields(52) = Data(51) 'Returned Items
'POSITIVE POST (CDM) ITEMS
rs.Fields(53) = Data(52) 'Positive Post Checks
rs.Fields(54) = Data(53) 'Positive Post Stubs
'REMOTE PAYMENT CAPTURE ITEMS
rs.Fields(55) = Data(54) 'Remote Payment Single Checks
rs.Fields(56) = Data(55) 'Remote Payment Single Stubs
rs.Fields(57) = Data(56) 'Remote Payment Multi Checks
rs.Fields(58) = Data(57) 'Remote Payment Multi Stubs
rs.Fields(59) = Data(58) 'Remote Payment Check Only Checks
rs.Fields(60) = Data(59) 'Remote Payment Check Only Stubs
rs.Fields(61) = Data(60) 'Remote Payment Check & List Checks
rs.Fields(62) = Data(61) 'Remote Payment Check & List Stubs
'DOLLAR DEPOSTIED & PP CORRO REJECT ITEMS
rs.Fields(71) = Data(70) 'Dollars Deposited
rs.Fields(72) = Data(71) 'PP Corro Rejects
once = True
MyLine = ""
MyLine = MyLine & ch
MyLocation = Loc(1)
MsgBox " File has been successfully imported! "
Close #1 ' Close file.
'close and erase the file from memory
Set objText = Nothing
Set rs = Nothing
on Sep 09, 2009
Mdb could not be used concurrently for two users
Please make sure that the other user has a read/write permission to the database. Make sure also that the ip address being used by the users are allowed to access the database.
If you could also give more info regarding this, it will make the resolution faster. I am pertaining to error logs etc.
on Aug 24, 2009
Problem opening Access Database-upgrade from Access 2003 to 2007
if the form "products" really exists, then your office 2007 security settings are not allowing to load macros. Try the following settings:-
Office 2007 has some security settings disabled by default to prevent any harm to your system.
go to trustcenter settings(click the office button at the top left of the office 2007 screen then click Access options, then select Trustcenter, then click trustcenter settings.)
In trustcenter settings, select message bar then select "Show the message bar in all applications when content is blocked" radio button.
Then from macro settings ,make sure to select "Disable all macros with notification" . Click ok twice to close the settings windows and try opening the file again.
on Aug 12, 2009
Microsoft access form problem
In the Design view for your form element (eg textbox), go to the Data Tab. Look at the options for:
Input Mask, Validation Rule and Validation Text. You can use any combination of these to force a user to enter something in the field. If you just want to check that the contents of the element has a non-zero length, then you can write an event (Events tab) to check the length of the values entered. If 0, then throw a message box and re-focus the cursor on the textbox.
on May 19, 2009
Not finding what you are looking for?