Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SendKeys to "Password Required" window
See the Solution I posted for... Open & CompactOnClose password-protected public db w/o passwrd prompts- dlcksc
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Open & CompactOnClose password-protected public db w/o passwrd prompts
Solution: See below within the While loop... and I removed the "Compact & Repair on Close" from Main.mde & then modified my code a bit because the actual purpose for the compact on close is to make sure Main.mde doesn't exceed 500 megabytes. See below. This works like a charm. This function...- dlcksc
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
SendKeys to "Password Required" window
Access 2000: I'm attempting to close Main.mde from Open.mde. Main.mde is set to compact on close. The "Password Required" window pops up because Main.mde is password-protected. When the code below is executed from Open.mde(to close Main.mde), the "Password Required" window pops up...- dlcksc
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Open & CompactOnClose password-protected public db w/o passwrd prompts
Access 2000: Goal: to open a password-protected public access db (which compacts on close) and hide the password prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected "Main.mde"...- dlcksc
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
