Login Form Not Opening?

[zia]

I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this problem?
Kindly guide.

 

[Gasman]

Add your new folder as trusted.

 

[GaP42]

Try opening your access database while holding the shift key down. No code runs so you can then review your code to adjust.

 

[Gasman]

Try opening your access database while holding the shift key down. No code runs so you can then review your code to adjust.

You do not need to open a database to get to the Trust Center, just Access.

 

[The_Doc_Man]

If you find yourself making frequent changes to a DB, you should have a work area where you keep a private copy of the DB and a separate area where you do all final staging and preparation for general use. This link might be helpful, even though it is perhaps more than you wanted.

How to make a large project?

The question has changed and none of the answers seem to be what the OP wants. In fact, despite asking very specifically about how to avoid it reaching design limits he doesn't seem to want to know what those limits are, or what anyone here's experience has been with a very large project. I'm out.

www.access-programmers.co.uk

 

[DHookom]

Another suggestion is to provide a descriptive title for your question. "Hi everyone" might be appropriate in the Introduce Yourself forum.

 

[CJ_London]

It was in the introduction forum. - I moved it

 

[zia]

Good day,

I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this problem?

What I want is that, whenever I would open my database a login form should pop up and ask to enter user's name and password, previously it was working fine but now I have changed my PC and in new PC this error occurred. Problem is that now i am using my database as a user rather than an admin due to which it does not allow me to make changes and even I can't open few reports and forms.
ERROR RESPONSE IS THAT: [Record(s) can not be read; no read permission on "approval reports".]. kindly guide what can i do now.

 

[Gasman]

Asked yet again?

LOGIN FORM NOT POPUP WHILE OPENING DATABASE

Good day, I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this...

www.access-programmers.co.uk

 

[Gasman]

Asked already.

Login Form Not Opening?

I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this problem...

www.access-programmers.co.uk

 

[Uncle Gizmo]

Good day,

I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this problem?

What I want is that, whenever I would open my database a login form should pop up and ask to enter user's name and password, previously it was working fine but now I have changed my PC and in new PC this error occurred. Problem is that now i am using my database as a user rather than an admin due to which it does not allow me to make changes and even I can't open few reports and forms.
ERROR RESPONSE IS THAT: [Record(s) can not be read; no read permission on "approval reports".]. kindly guide what can i do now.

Chatty Said:-
It seems that several issues might be affecting your Access database, stemming primarily from the relocation of your database and a possible change in permissions or configurations. Here’s a step-by-step guide to troubleshoot and resolve your issues:

---

​

1. Login Form Not Appearing:
   • It may no longer be configured as the default startup form after the database relocation or system migration.
2. Read-Only Mode:
   • This could be due to insufficient permissions, the database being opened in a shared location, or linked tables not connecting properly.
3. Record Read Error:
   • This might occur if Access cannot find the required permissions or if the database security was altered during the transfer.

---

​

​

• Ensure Full Control:
  • Right-click the database file and select Properties.
  • Navigate to the Security tab, and ensure that your user account has Full Control.
  • Repeat this for the folder containing the database.
• If the database is on a network drive, ensure network permissions allow Modify or Full Control.

---

​

• Open Access while holding down the Shift key (this bypasses any startup form or VBA code).
• Once the database is open:
  • Go to File > Options > Current Database.
  • Under Display Form, ensure your login form is set as the default startup form.
  • Save changes and restart the database.

---

​

• If your database relies on linked tables:
  • Go to External Data > Linked Table Manager.
  • Refresh or re-link the tables to ensure Access can locate the data sources.
• If the back-end database file was also moved, update its location.

---

​

• If the database uses an older User-Level Security (ULS) system:
  • Ensure you have the .mdw workgroup file that defines user accounts and permissions.
  • Join the correct workgroup file:
    • Open Access > File > Options > Client Settings > Advanced.
    • Under the Workgroup Information File, ensure the correct .mdw file is selected.
• Without the correct .mdw, you won’t have admin access.

---

​

• If the database is in read-only mode, ensure it's not being opened in a restrictive manner:
  • Check if the database file is flagged as Read-only:
    • Right-click the file, select Properties, and uncheck Read-only.
  • Ensure no .ldb locking file remains in the folder when no one is using the database.
• Make sure you're logged in with an account that has admin permissions in Access.

---

​

• This error usually indicates a permissions problem or corruption:
  • Verify permissions on the table or query that is causing the error.
  • Run Compact and Repair Database from Database Tools to fix potential corruption.

---

​

• Before making any significant changes, create a copy of your database to prevent data loss.

---

​

• If you're unable to resolve the issue, share additional details:
  • Was the database developed using a different version of Access?
  • Are you using any custom VBA or macros that interact with the login process?
  • Are you working in a split-database environment (frontend/backend)?

 

[theDBguy]

Asked yet again?

LOGIN FORM NOT POPUP WHILE OPENING DATABASE

Good day, I have a problem with my access database, my login form doesn't appear upon opening access. That's why I can't make any changes in my database, it opens as read only. The reason came in mind is that, it is because I had change the location of my database folder. How could I fix this...

www.access-programmers.co.uk

I've merged the two threads.