VB Functions Dont Work with Workgroup Security
- From: ricky.fung@xxxxxxxxx
- Date: 30 Aug 2006 19:48:11 -0700
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!
.
- Prev by Date: Re: Summing a Query
- Next by Date: Re: ANSI vs Unicode and the character map
- Previous by thread: "Shell"ing to Adobe update question
- Next by thread: Link table structure
- Index(es):