Question about Microsoft Access 2003 for PC

1 Answer

How to password protect .mdb, just one table alone.

Posted by on

  • Emuobosa Onerhime
    Emuobosa Onerhime May 11, 2010

    You can only password protect a database and not just one table. If you want a table to be password protected and others not, make different databases. There are different ways to password protect a database in the different versions of Microsoft Access. Can you tell me which version you use? (in Microsoft Office 97 - 2000, Microsoft Office 2003 or Microsoft Office 2007). Thank you

  • Ben Aaron
    Ben Aaron Apr 10, 2019

    How could I protect my database with a password? I often write articles on a topic such as Is america falling apart by anthony burgess and I do not want somebody to find that.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 19 Answers

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

Posted on Oct 21, 2017

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

6 Answers

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

Oct 29, 2015 | Microsoft Office Computers & Internet

7 Answers

How do I easily repair corrupt or inaccessible Access database file?


Why to depend on anyone else suggestion. You may download one of the best access recovery tool which will repair your inaccessible access database file. This tool work on windows 10 & below versions also best thing is that free version of this tool will preview all your records after repairing your database. So you may preview your database and can easily review that your data is recovered and to export it you have to use full version. Try this access recovery tool. Access Recovery Tool Repair and Manage MDB or Accdb Database Files

Sep 09, 2015 | Computers & Internet

4 Answers

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.

Jun 23, 2015 | Microsoft Access Computers & Internet

5 Answers

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/

Feb 23, 2015 | Microsoft Access 2003 for PC

5 Answers

Need guidance to restore mdb file from Access


Here is a link http://www.en.accessrecovery.org and http://www.compactaccessdatabase.net on the same particular problem that I resolved effectively using this tool. This tool is smartly programmed and allow to restore database from a corrupt database table without hassle.

Apr 11, 2014 | Computers & Internet

1 Answer

How to stop people accessing .mdb table using link, which was established sometime back.


I would need more info to be certain, but it sounds like you need to

a. remove the link

b. in a server domain, remove the permissions of those improperly accessing

or
c. password protect it

Hope this helps.

Apr 03, 2010 | Microsoft Access 2003 for PC

7 Answers

Undelete records from access table


ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

2 Answers

Convert my database from dpf to mdb


Use access to import external data. It can read dbf and create mdb

Jan 06, 2009 | Microsoft Visual FoxPro Professional...

1 Answer

Create access mdb file by vfp code


Try this

#define dbLogical 1
#define dbNumber 2
#define dbInteger 3
#define dbLongInteger 4
#define dbCurrency 5
#define dbSingle 6
#define dbDouble 7
#define dbDateTime 8
#define dbBinary 9
#define dbText 10
#define dbOLEObject 11
#define dbMemo 12
#define dbReplication 15
#define dbDecimal 16
if file("C:\accesstest.mdb")
delete file c:\accesstest.mdb
endif
public oAccess
oAccess = createobject("Access.application")
oAccess.visible= .t.
newMDB = oAccess.NewCurrentDatabase("C:\accesstest")
newtable = oAccess.CurrentDb.CreateTableDef('testtable')
with newtable
.fields.append(.CreateField("Field1", dbLogical))
.fields.append(.CreateField("Field2", dbNumber))
.fields.append(.CreateField("Field3", dbInteger))
endwith
oAccess.CurrentDb.TableDefs.append( newtable)
dbc2Convert = "\\tpdfiles\data\dfreeman\tip\data\rta\rta"
open database (dbc2convert)

dbgetprop(rta,"table",)

After it runs you will need to close the MDB and reopen it.

Oct 15, 2008 | Microsoft Computers & Internet

1 Answer

MS-ACCESS fields


It is not possible. Access only allows 255 fields per table and 32,768 tables in a single .mdb file. You should never let a table get that big. Creating small tables is the better option for best performance and manageability.

Hope this helps! : )

Jun 24, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?
Microsoft Access 2003 for PC Logo

Related Topics:

433 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

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

Answer questions

Manuals & User Guides

Loading...