I added a reference to "Microsoft Visual Basic for Applications Extensibility
5.3" within the coding in my database. I made this change because my date()
function was not working correctly. Adding this reference solved the problem.

Will I need to make this change on all the computers that access my database
or will making the change within the file affect all users?

Thanks.

References live with the database. The issue will be whether your users have
the same version of the file on their machine or not.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"MEAD5432" <(E-Mail Removed)> wrote in message
news:E39E7BCB-6F8D-4DD4-8ABF-(E-Mail Removed)...
>I added a reference to "Microsoft Visual Basic for Applications
>Extensibility
> 5.3" within the coding in my database. I made this change because my
> date()
> function was not working correctly. Adding this reference solved the
> problem.
>
> Will I need to make this change on all the computers that access my
> database
> or will making the change within the file affect all users?
>
> Thanks.
>
>
>
>
>
>

MEAD5432 <(E-Mail Removed)> wrote:

>I added a reference to "Microsoft Visual Basic for Applications Extensibility
>5.3" within the coding in my database. I made this change because my date()
>function was not working correctly. Adding this reference solved the problem.
>
>Will I need to make this change on all the computers that access my database
>or will making the change within the file affect all users?

I'd far sooner remove that reference, compile the code and fix up the
problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/