Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Change password in MS Access

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-11-2009
Member
 
Join Date: May 2009
Posts: 974
Change password in MS Access
  

Hi,
I am a newbie on Microsoft Access. I have imported some database in my application for general work. Some database has passwords on them. I want to change to remove them completely. How to do this. Second thing is there a way by which I can compact a large database in the application. How can figure out the path of the database running in the software. I also need some more configuration information on Microsoft Access.

Reply With Quote
  #2  
Old 11-11-2009
Member
 
Join Date: May 2008
Posts: 4,343
Re: Change password in MS Access

To change the password you must be logged in as user: for each password you want change, you must login with the user login and password. Then you change the password by going in Tools > Security > User, change the password from here. For manually compacting a database go to Tools > Utilities > databases. For setting the same on Automatic go to Menu > Tools > Options > General> Compact on Close.
Reply With Quote
  #3  
Old 11-11-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Change password in MS Access

Sometime the AutoExec macro launched at startup which is quiet annoying. You can prevent that by holding the shift key while opening. This trick works with most Office applications. You can also change the icon of the applications. There is an option to set the application icon to display in the title bar of the database. Go to Tools Menu > Startup > Application icon. You can also open a from or run a code on startup. To open a form to start the application, go to Tools then Startup. Property Set Startup Form. To run a process to launch the application, create a macro named AutoExec including actions that you need. In general, the developer will provide this macro one action: Run Code thereby launch a VBA function to start up its product.
Reply With Quote
  #4  
Old 11-11-2009
Member
 
Join Date: Apr 2008
Posts: 4,096
Re: Change password in MS Access

To get a path of the database which contains tables you will have to use the listed functions. The function GetLinkedDBName () returns the network path of the table passed as parameter. The function DriveLinkedTable () returns the same way but without the filename of the database. And if you want to use the Access on the internet to get your database you will have to first, ru Access in a Windows front end, not on a web front end. So we can use the interface (forms) on the Internet, however, the tables and their data are used. You can also copy objects from one database to another. The solution is to import the desired objects (queries, forms, tables, macros or states). To do this open your destination database (create one blank if necessary) and use Insert > Table > Import table.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Change password in MS Access"
Thread Thread Starter Forum Replies Last Post
Not able to change forgotten keychain access password in Lion OS X Hammond Operating Systems 5 26-04-2012 10:18 PM
old password usable after a password change ADAMEE Active Directory 1 22-05-2011 06:05 AM
Need Password Reset Disk to change password for Windows 7 Alfanumeric Operating Systems 3 11-01-2011 03:06 PM
Change password for users with blank password: Error Ihit Active Directory 3 06-06-2008 06:21 PM
Change password/disable account - password cached? gbug Active Directory 3 25-04-2008 05:09 AM


All times are GMT +5.5. The time now is 01:55 PM.