Access on Lan

[Golfinray]

I am running Access 2003 on 7 computers, all with xp and dual core
processors. 5 of the computers work perfectly. 2 computers cannot run certain
parts of forms, like combo filters, and cannot run certain reports either. I
went to those machines and tried to run the queries those forms and reports
run on and some of them won't work either. Both machines have been completely
reloaded by our IT people with fresh reloads and still the same. Help! Thanks
a bunch!!!!

 

[Arvin Meyer [MVP]]

Remember that to run properly on a LAN, you must split your database and put
only the data on the LAN, with a copy of the front-end on each workstation.

If you are doing that, check the references from any code window:

Tools >>> References

and uncheck or find any mark as missing.

 

[Golfinray]

What references do I need to have set? Thanks!!

Remember that to run properly on a LAN, you must split your database and put
only the data on the LAN, with a copy of the front-end on each workstation.

If you are doing that, check the references from any code window:

Tools >>> References

and uncheck or find any mark as missing.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

That totally depends upon what you are running in the database. There are 3
that are generally a part of every database, you can add a reference to DAO,
or replace ADO with DAO. Others are for ActiveX controls or early binding to
other apps.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tom Wickerath]

Hi Golfinray,

What references do I need to have set?

The minimum number required for any VBA code in your database to compile
successfully, no more and no less. You should "starve" the references list;
in other words, only include a checked reference if it is absolutely
necessary for your code to compile (in the VBE editor, Debug > Compile
ProjectName). If you remove a reference and your code still compiles without
an error, then you did not need the reference you just removed.

Here are two excellent articles on the topic of missing references:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________