Database sharing

  • Thread starter Thread starter Frank Watson
  • Start date Start date
F

Frank Watson

Two machines networked - both running XP Home and Access
2003. Machine A has data base and works very well,
however on trying to get it to run on B there is all
sorts of error messages starting with security warnings:
unsafe expressions are not blocked - say no goes to new
security warning and advice to download Jet4 service pack
(have done that) say yes to that screen and then open on
next screen. Then I get "There is no object in this
control" and on proceeding it goes through a number of vb
screens. Get through to database, but some of the form
have #error and so forth. I have tried moving the
database over via cd and still get the same set of
problems. Is there anything I can do??

Thanks Frank
 
Hi Frank,

The #error and "there is no object in this control" sounds like it might be a missing reference
problem.
See the following articles on this problem:

http://members.iinet.net.au/~allenbrowne/ser-38.html

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


The security warnings that you are seeing on machine B are a gift to you from Microsoft. You can
set the security level to low, although this is not recommended. You can also create a digital
signature to "sign" your code. This allows you to keep the security setting at the default
medium. I'm not running Access 2003 yet, so I'll need to defer questions of how to create
digital signatures, sign your code, and copy your digital signature to machine B to someone else
who is familiar with this new requirement. You might want to pick up a book on Access 2003 that
covers this topic.

Tom
_______________________________________


Two machines networked - both running XP Home and Access
2003. Machine A has data base and works very well,
however on trying to get it to run on B there is all
sorts of error messages starting with security warnings:
unsafe expressions are not blocked - say no goes to new
security warning and advice to download Jet4 service pack
(have done that) say yes to that screen and then open on
next screen. Then I get "There is no object in this
control" and on proceeding it goes through a number of vb
screens. Get through to database, but some of the form
have #error and so forth. I have tried moving the
database over via cd and still get the same set of
problems. Is there anything I can do??

Thanks Frank
 
Back
Top