Access Run Time Error

[AppzDev]

I am receiving a run-time 48 error loading dll error in access 2000.

The database works fine, on my machine, but seemingly not on any other access 2000 machine.

There are 4 linked tables to a SQL database.

When the main form is opened, i have a dropdown with a list of employee names. When you click in the dropdown to select another employee, the error occurs. Here is the code i am using which, when you select an employee, is supposed to load that employees demographic information.

Private Sub Form_Current()
[Combo170] = [NameSearch]
End Sub

Private Sub Combo170_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[NameSearch] = '" & Me![Combo170] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

I'm sure alot of you have seen similar code.

Does anyone have any idea why this would work on my machine and not on any other's i have tried? I even did a fresh install of Office2k on a WIN2k OS...the same as mine. Service Packs are the same, the same OfficeCD install was used etc. I do however have VB.NET installed on my PC where this database works as well as SQL Enterprise Manager and Query analyzer. I'm not sure if there is some dll that was installed that makes this work.

Any help is appreciated. If not by letting me know what dll i migh be missing, an option for code that may do what i want.

Thanks for the help.

dc~

 

[GHolden]

If on one of the machine which is not working you go into any piece of code. then click on tools - references you may find MISSING next to one of them, this will tell you which DLL is missing.

There are two ways to write error-free programs; only the third one works.

 

[AppzDev]

I tried this and didn't seem to see anything saying "MISSING" I will look at another machine that it does not seem to be working on. I am comparing VB*.dll's at the moment to see if there is something that jumps out at me...tedious process to say the least but i'm at my wits end on this.

Thanks for the reply and if anyone else has some input, please post, i'm willing to try anything at this point.

dc~

 

[cgondolf]

Try creating a new database on the machine with the problem & then importing everything from the original database. Then relink the tables. I've used this several times.

 

[AppzDev]

I may try the import idea if a thought i had does not work. The PC i am "attempting" to put this on runs a payroll application. I know for a fact this application has been running in the background when i've tried to run this access database. I only noticed it when i happened to really look at the ODBC connections defined for this pc. If there is an error loading a .dll file, could the application already running be using that .dll file preventing my access database from using it? I am not that familiar with the structure of .dll's. I do know how they work with programs, in theory, but i am unsure as to 2 programs can call the same .dll if needed.

Thanks,

dc~