I have a problem and I don't know where to put it. (1 Viewer)

[voidcranium]

I have a Access 2000 database with several forms, the database it just over 5meg in size.
The database is on a server with shortcuts linked to the database.

I have the following modules installed.
modMouseHook.bas - this is to disable the scrolling.
MachineName - this is used to get the machine name
UserName - this is used to get the username

I have had these installed for over a year and have had no problems with them until yesterday.

In my office we have at most 3 people who access and use this database daily. All 3 are using WinXP-Pro SP2.
Yesterday 2 of the 3 users started having problems, my computer is not having any problems.

When opening the database the following errors are shown.
a. Compile error: can't find project or library.
and the debugger shows the following line in YELLOW.
"Function CurrentDBDir() As String"

b. Compile error: can't find project or library.
and the debugger shows the following line in YELLOW.
"Function fOSMachineName() As String"

c. Compile error: can't find project or library.
and the debugger shows the following line in YELLOW.
"Function fOSUserName() As String"

If I close out of the debugger it does open the database but where these text boxes are it just shows "Name?" or "#Error"

Again, my computer opens the database with no problems.

I have taken those modules out of the database and the database opens up but now if I put the DATE() in a text field it just shows "#Name?"

I even put a text box in and put the Environ(5) in one and Environ(28) in the other and still it shows "#Name?" in the text box.

It is important for our work orders to have the date they were printed.

Anybody have any Idea whats going on?

Thanks

 

[gemma-the-husky]

first copy the database to make sure you have a backup?

do you have any tape backups that you can recover to if all else fails?

now a few questions
is the database split, so that users have their own copy of code, and the data tables are on the server. or does everyone log into the server.

it should be the former, the latter situation is much more fragile, and should be remedied if that is the case

anyway, now it is copied try a couple of obvious things

a) tools/database utilities/repair
b) open a code module, look at tools/references and see if any are "missing"

-----------
if still a problem, let us know!

 

[voidcranium]

first copy the database to make sure you have a backup?

do you have any tape backups that you can recover to if all else fails?

now a few questions
is the database split, so that users have their own copy of code, and the data tables are on the server. or does everyone log into the server.

it should be the former, the latter situation is much more fragile, and should be remedied if that is the case

anyway, now it is copied try a couple of obvious things

a) tools/database utilities/repair
b) open a code module, look at tools/references and see if any are "missing"

-----------
if still a problem, let us know!

Yes I have a backup.
No the database is not split.

I have ran the Compact and Repair, is that what you mean by Repair?
Or do you mean The option under HELP > Detect and Repair?

Under References how do I know if it is missing? There are a lot that are NOT checked.

Thanks

 

[voidcranium]

One other note.

Yesterday before all this started I was trying to find a way to get an Excel Spreadsheet on a form. I then found out how to link an excel spreadsheet.

It was after this that all this started.
I have since deleted the form that the was spreadsheet on.

 

[gemma-the-husky]

repair, under compact and repair, as you did
i take it, the repair did not fix the problem.

if there is a missing reference, one of the ticked boxes is likely to declare "missing"

----------
what you could do is create a new empty database, then do file import, and select everything form your faulty database, including in the options bit, file import/output stuff, and relationships

see if that helps

-------------
open the tables one at a time and see if there are any corruptions in the tables - sometimes that happens

-------------
did you mean you have a saved backup of the database before it failed - if so you could revert to that, depending on how easily you could identify and reenter any missing data

-------------
see if any of these work

 

[voidcranium]

Since the database is so small I just do a manual copy evey other month.
I went back to last DEC's backup and try to open it and it still had the same problems.

Right now I don't have the fOSUsername functions enabled, I took them out of the text boxes I was using them in and took out the module for the mouse scroll.
Each user can open and use the database but it does not print the DATE.
I have a text box on the Main screen that just fills in the date, it does not do that now. Everything is working like it should except that.

thanks

All references are there, none of them say Missing.

 

[gemma-the-husky]

very strange, the missing functions point to a missing module (not a reference), but the date thing is confusing.

dont think i can offer any more suggestions

sorry

 

[voidcranium]

Yeah it is strange since it works just fine on my computer but not the others.

 

[voidcranium]

Thanks for your help gemma-the-husky.

I finally found out what was wrong.

I think what happened was when I put a spreadsheet on my form I used the Microsoft spreadsheet 10. and it installed it on my machine but since it was not on the other computers it would not run. ?!?!?!? I have no idea why.
After looking at was installed on my comp vs. the others that was the only thing standing out.

I had to install the Microsoft Office Web Components 10.0 (owc10.exe)

Now it works just fine on all machines.

thanks again for trying to help.

 

[The_Doc_Man]

After the fact, a couple of things might be helped by clarification.

First, references are a registry thing, and that is machine-specific. So it is not really a mystery that it worked one place and failed in another.

Second, references are positional. That is, if two modules both offer something called XYZ, the first (highest) one in the list wins. Which is why the reference dialog box allows you to raise or lower reference order.

Third, installing WEB COMPONENTS probably mucked about the required order of references.