By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 1,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Date() function problem

P: n/a
Dear Access expert

I am trying to use an mde application developed in Access2k with Access
2002. I get an Access error box: Function is not available.. Date() etc.
Is Access 2002 back compatible if so how do I work around this date function
problem?

Ian
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
ng
look up "Missing References" Any time simple stuff like Date() Left()
Right(), or other simple functions quit working, Tools References, then
you'll see "MISSING REFERENCE: blah blah" You can click on it, find out what
file it is, and determine if you can get the file and put it where it wants
it (the library) or, you could try unchecking that library and see if that
doesn't fix your problem.

-dp
"Ian Davies" <ia********@virgin.net> wrote in message
news:Wk*****************@newsfe5-win.ntli.net...
Dear Access expert

I am trying to use an mde application developed in Access2k with Access
2002. I get an Access error box: Function is not available.. Date() etc.
Is Access 2002 back compatible if so how do I work around this date
function
problem?

Ian

Nov 13 '05 #2

P: n/a
Thanks will give it a go

"ng" <ng@ng.com> wrote in message news:bJw6e.15611$B12.10612@trnddc09...
look up "Missing References" Any time simple stuff like Date() Left()
Right(), or other simple functions quit working, Tools References, then
you'll see "MISSING REFERENCE: blah blah" You can click on it, find out what file it is, and determine if you can get the file and put it where it wants it (the library) or, you could try unchecking that library and see if that
doesn't fix your problem.

-dp
"Ian Davies" <ia********@virgin.net> wrote in message
news:Wk*****************@newsfe5-win.ntli.net...
Dear Access expert

I am trying to use an mde application developed in Access2k with Access
2002. I get an Access error box: Function is not available.. Date() etc. Is Access 2002 back compatible if so how do I work around this date
function
problem?

Ian


Nov 13 '05 #3

P: n/a
By the way

Are these missing refs specific to the database or Access as a whole. Can
the missing refs be resolved from any Database or only from an mdb of the
one with the problem.
The reason I ask is that I only want the user to have the mde not the mdb or
an I going to have to take a trip and visit the users pc?

Ian
"Ian Davies" <ia********@virgin.net> wrote in message
news:fq******************@newsfe5-gui.ntli.net...
Thanks will give it a go

"ng" <ng@ng.com> wrote in message news:bJw6e.15611$B12.10612@trnddc09...
look up "Missing References" Any time simple stuff like Date() Left()
Right(), or other simple functions quit working, Tools References, then
you'll see "MISSING REFERENCE: blah blah" You can click on it, find out

what
file it is, and determine if you can get the file and put it where it

wants
it (the library) or, you could try unchecking that library and see if that
doesn't fix your problem.

-dp
"Ian Davies" <ia********@virgin.net> wrote in message
news:Wk*****************@newsfe5-win.ntli.net...
Dear Access expert

I am trying to use an mde application developed in Access2k with Access 2002. I get an Access error box: Function is not available.. Date()

etc. Is Access 2002 back compatible if so how do I work around this date
function
problem?

Ian



Nov 13 '05 #4

P: n/a
Ian Davies wrote:

Are these missing refs specific to the database or Access as a whole. Can
the missing refs be resolved from any Database or only from an mdb of the
one with the problem.
The reason I ask is that I only want the user to have the mde not the mdb or
an I going to have to take a trip and visit the users pc?


I'm afraid it'd be a trip to each PC with an mdb copy and then create an
mde for that computer.

I'm not a 2002 user (I play with 97 and 2003) but it may be that the
refs in 2000 are different from 2002? If I'm wrong here, someone needs
to club me fast so I don't give Ian the wrong info.

If this is the case, what I would do is check the refs on a new mdb on
one of your 2000 machines and then change, if necessary, the refs on the
2002 machine before making it into an mde - that might do the trick.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #5

P: n/a
ng
Well, what I did was made a batch file that copied ALL the libraries to each
of the machines. I did it with a batch script in their startup so they
never knew. But, it was basically:

copy Z:\accessxp\libs\*.* %windir%

Contents of libs:
Volume in drive Z is NTShare
Volume Serial Number is 94CD-2C27

Directory of Z:\AccessXP\admin\libs

11/24/2004 04:48 PM <DIR> .
11/24/2004 04:48 PM <DIR> ..
01/25/2001 05:25 PM 570,128 dao350.dll
07/22/2002 03:05 PM 557,328 dao360.dll
03/07/2001 08:15 AM 435,616 MSACC.OLB
08/04/2004 12:56 AM 536,576 msado15.dll
08/03/2004 10:21 PM 61,440 msado20.tlb
08/03/2004 10:21 PM 61,440 msado21.tlb
08/03/2004 10:21 PM 81,920 msado25.tlb
08/03/2004 10:21 PM 81,920 msado26.tlb
08/03/2004 10:21 PM 81,920 msado27.tlb
08/04/2004 12:56 AM 180,224 msadomd.dll
08/04/2004 12:56 AM 57,344 msador15.dll
08/04/2004 12:56 AM 200,704 msadox.dll
05/08/2001 08:00 AM 1,503,504 msjet40.dll
12/07/1999 08:00 AM 74,000 msrclr40.dll
07/22/2002 03:05 PM 16,896 STDOLE2.TLB
02/16/2001 11:26 PM 483,328 UTILITY.MDA
01/22/2001 07:39 PM 2,498,560 VBE6.DLL
01/22/2001 07:39 PM 45,056 VBE6EXT.OLB
18 File(s) 7,527,904 bytes
2 Dir(s) 2,033,442,816 bytes free

That took care of it on all my OS's.. I have a mix of 98, 2000, and XP.
Isn't that special? I guess it's overkill to have multiple versions of
libraries, but it doesn't matter realty isn't an issue. The MDB just knows
which library it needs, and because it finds it in the sys path, then it's
happy with it's references. Missing references really tick me off in
particular because it's like "WHY DIDN'T THEY GET LOADED ON INSTALL?" Why
ask anything about Microsoft, or how, or why they do what they do. All I
know is I get to keep juggling to accomodate their changes - in everything.

-Brian


"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d3**********@coranto.ucs.mun.ca...
Ian Davies wrote:

Are these missing refs specific to the database or Access as a whole. Can
the missing refs be resolved from any Database or only from an mdb of the
one with the problem.
The reason I ask is that I only want the user to have the mde not the mdb
or
an I going to have to take a trip and visit the users pc?


I'm afraid it'd be a trip to each PC with an mdb copy and then create an
mde for that computer.

I'm not a 2002 user (I play with 97 and 2003) but it may be that the refs
in 2000 are different from 2002? If I'm wrong here, someone needs to club
me fast so I don't give Ian the wrong info.

If this is the case, what I would do is check the refs on a new mdb on one
of your 2000 machines and then change, if necessary, the refs on the 2002
machine before making it into an mde - that might do the trick.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.