VBA Question

S

shoe

I am fairly new to the VBA environment but managed to put together an
application that will import all files within a folder and move them to an
archive directory. I am accomplishing this in an unsecure database (Access
2000). The issue is the code will not execute on anyone else's workstation
except for mine. Are there any suggestions as to what could cause this? The
mdb file is located in a network directory. Thanks in advance for any
responses I may receive.
 
A

Alex White MCDBA MCSE

A Couple of questions,

what versions of Access are the other workstations running? (If any)

What OS is running the computer with the MDB on it?
 
S

shoe

All other PC's have Access 2000 and WIndows 2000. I have created other VB
code before but never had this issue.
 
A

Albert D.Kallal

I would try opening the database on a another machine (that does not work),
and then try compiling the code.

Further, you might want to check for broken references.
Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html

Having done the above, for reliability, you do need to split your database
if multiple users are going to work with it...
You can read about this here:
http://www.granite.ab.ca/access/splitapp.htm
 
S

shoe

Thanks for the information Albert. Unfortunately, I couldn't find anything
to fix the issue. The database does not allow me to compile the code because
once it is compiled the option is grayed out. None of the other links seem
to give me what I was looking for. Any other suggestions would be greatly
appreciated. Thanks.
 
A

Albert D.Kallal

shoe said:
Thanks for the information Albert. Unfortunately, I couldn't find
anything
to fix the issue. The database does not allow me to compile the code
because
once it is compiled the option is grayed out.
Click to expand...

yes, I suppose you could just open up some code...hit enter a few times..and
then save..and then try to compile..

Another thing is to try and make a mde file on that machine...as that should
complain if a ref is damaged.
 
S

shoe

Thank you for all your help. Unfortunately, the code still doesn't work. I
am going to mess around with Service pack updates and make sure their pc's
are configured properly. Thanks again.
 
Top