Functions not working when others use database

[Fairportjay]

I have a problem :-). I am trying to look up and prepopulate names and departments based on their msid. It works great for me when I sign in and do it from any machine however when others try they get the #name error. this is also the case when I try any "precanned" functions like now or date to prepopulate date and time.. it works perfect when I sign in however others are having issues.


as you can see I made sure the function is public and I also confirmed it was on other users PC. I am at a complete loos as like I said no functions seem to be working except under my name
Option Compare Database
Public Function CU()
CU = Environ("USERNAME")
End Function

[mike60smart]

Hi

Is your database split into FE and BE with a copy of the FE on all users PC's ??

[CJ_London]

you don't appear to be using Option Explicit - not doing so could be hiding errors when you compile

#Name is something you will see in a form control when the underlying controlsource cannot be identified. So the issue is probably where you are using it, not the code itself. Also the code needs to be in a module - you haven't said whether or not this is the case.

you haven't declared the function with a datatype, so it will be returning a variant - could also be a problem.

And have you checked the libraries - as a minimum you need

Visual Basic for Applications
Microsoft Access XX.0 Object Library - not sure what XX is for 2007, probably 15
OLE Automation

[Fairportjay]

Mike60smart I am using a shared database. I have it where they just open the database from a shared drive.

Hi

Is your database split into FE and BE with a copy of the FE on all users PC's ??

[Fairportjay]

Its in a module. what I don't get is not a single function will work on their PC's so I am wondering if the libraries are the issue.. I'll look into that next and let you know

you don't appear to be using Option Explicit - not doing so could be hiding errors when you compile

#Name is something you will see in a form control when the underlying controlsource cannot be identified. So the issue is probably where you are using it, not the code itself. Also the code needs to be in a module - you haven't said whether or not this is the case.

you haven't declared the function with a datatype, so it will be returning a variant - could also be a problem.

And have you checked the libraries - as a minimum you need

Visual Basic for Applications
Microsoft Access XX.0 Object Library - not sure what XX is for 2007, probably 15
OLE Automation

[Micron]

no functions seem to be working except under my name

Then I would expect Trusted Locations issue. No code can run in a non trusted location, thus no Environ variable thus no function value. You logging in on another pc where the file is local should mean you wouldn't have access to it so I expect the fe copies are on a server.
Agree with the Ajax's comments too.
EDIT
OK last 2 posts weren't there when I started
The general consensus would be that you're asking for trouble by sharing one non-split db.

[mike60smart]

Hi

You say "I have it where they just open the database from a shared drive."

This is a NO NO NEVER when sharing a database.

[Fairportjay]

Thank you everyone I split the database and made sure everyone marked it as trusted so it fixed the issues