Code Access Problem???

[marks416]

Hi,

I have a VBA question now.

I have did a VBA application and I debuged and compiled in my local computer.It works fine.

After I copy the application to a network server. It works fine when I access it from my computer .but it doesn't work when somebody else access it from his computer.

I do not know why this happen.

It have compile error (DAO errors) when I try to compile it throuht other's computer.But it error free when I accesee and compile it through my computer.

Thanks for help

M

 

[dinger2121]

Check the references from the machines that are having the errors. You may have to add the dll file to those machines.

 

[marks416]

Do you have if Microsoft have some ADO patches I can download?Thanks

M

 

[dinger2121]

Go into the visual basic editor and check Tools > references.
If you do this on the machine that is erroring out, you should see that one or more is MISSING. Find out what dll that it is looking for and then add that to those machines. After that, they should work.

 

[JerryKlmns]

marks416

You might have referenced ADO 2.8 on your PC while the erroring has ADO 2.6 or DAO 3.6 and DAO 3.51

For othter objects like Word/Excel or whatever if you use late binding you wont have versioning problems

Dim objWord As Object 'Word.Application
Set objWord = CreateObject("Word.Application")

If you like the intellisence while writting code, reference the library on your PC and

Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application")

when finished change the Dim

Late binding is slower than early but saves you from that versioning error

 

[marks416]

Hi Jerry,

Do you mean latr binding do not have version problem.right?

code like

Dim objWord As Object
Set objWord = CreateObject("Word.Application")

Do I have to change reference setting for Word.Application?

Thanks for help

M

 

[JerryKlmns]

If you do use late binding, remove the reference to that library.

 

[marks416]

Hi Jerry,

Based on my understaning.reference settings is for early binding .and we do not need the reference settings if we use late binding.Is that right?

Application with late binding is slow then application with early binding.

Thanks

M

 

[JoeAtWork]

Based on my understaning.reference settings is for early binding .and we do not need the reference settings if we use late binding.Is that right?

That's correct.

Application with late binding is slow then application with early binding.

Yes - but not noticeably so. No one will notice the extra .5 seconds it takes to load.

 

[marks416]

which one is better late binding or early binding?

Thanks

M

 

[PHV]

which one is better late binding or early binding?
When in development: early
For deployment: late

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886