VB Functions Dont Work with Workgroup Security




I have several VBA functions in my Access Database that do not work.

I have a combobox that filters my subform data however I cannot select
anything when logged in with Read Only permission.

The statusbar comes up with a message saying:
"Recordset is not updatable"

This combobox works with Admin permissions but not Read Only.

Secondly I have a VBA function that does not work even with admin
permissions. It uses the following connection string:

strConnectionString = Application.CurrentProject.AccessConnection

I have a feeling this connection string is invalid when security has
been implemented so i guess the question is, is there a function I can
use to bypass security from a coding level or is there a way where I
can hardcode admin username and password for any VBA code.

Thanks in advance!

.