Any idea why another user can't access my switchboard?

kilroyscarnival

Registered User.
Local time
Today, 19:35
Joined
Mar 6, 2002
Messages
76
I built the darn switchboard to simplify for a coworker's use! And though it appears fine on my PC, on hers it not only won't auto-open, it won't open at all.

The piece of code highlighted as the problem is triple-bracketed below {{{ }}}:

' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = {{{Application.CurrentProject.Connection}}}
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset

Why would that be a problem for one user and not another? Isn't the form saved as part of the database apart from my computer? It's saved on a shared drive.

Thanks!

--Ann
 

Users who are viewing this thread

Back
Top Bottom