A2k Front End not working!

[Fuga]

I´ve started to place the FE´s on the different user´s local drives. When I got to the ones with A2k, I encountered the following problem. Please help me with this one, half the company can´t use the db unless this problem is solved.

When adding a record automatically to a tbl in the BE, it registers the date, using the date() function. This works fine with those FE´s that are in A97, but with A2k I get an errormessage.

What is the problem? What is the solution?

Fuga.

 

[The_Doc_Man]

Sounds like a references problem.

As a test, go to one of the Acc2K stations. Log in as an Admin type who can update software on the station. (I don't know your security setup, so I'm assuming it is not just wide open.)

Open up any general module or class module so you can see a code window. In the CODE window's menu bar, follow path

Tools>>References

You'll see a dialog box that lists rows consisting of a check box and a module name. Look in that box for any names that are tagged as MISSING.

When you single-click-select the module name, the file name it was seeking is listed at the bottom of the box. Note the names of the missing modules. Now uncheck all that are missing. Go back and BROWSE for each one.

When you get to the directories where those names are expected to be, see if there is another file with a very similar name in the same directory. A case most often in point is, for AC97, you want the DAO35.TLB file, but for AC2K you want DAO36.TLB - a new version. Look for other cases like that for each missing file. For each file you find, click on the Open button when you find it. Make sure the check box is checked in the References dialog box.

Now, the curve-ball... if any of the items are .OCX files, you might also have to separately Register them. It's an item on the main Access menu bar, Tools>>ActiveX, where you can register the modules you need. (If you have the right kind of kit, you can...)

If this fixes your problem, do it for all affected AC2K workstations.
If this DOESN'T fix your problem, I hope someone else can offer help.

 

[Fuga]

missing files?

Thanks for your reply!

You were right, there was a DAO file missing.

However, the path to the file was incorrect, so I looked in what I believed to be the right path. I only found "Dao360.dll". That´s not the right one, is it?

Next, I looked at one of the working A97 stations. It had a file called "Dao2535.tlb", and a .dll.

Am I missing the "Dao36.tlb" file alltogether, or what is going on here. Can I replace it with another file?

The error message I get is:

"Unknown function "date" in tbl.fld" or something like that. (translation from swedish).

Now, I´m in a bit over my head here, so please answer in a way that I can understand, like The_Doc-man did.

Fuga.