Please Help!! Networking Issues

[Guest]

I have created a Database that is located on our local server. I need to
allow everyone on our network to use this database, but if I open it from
someone elses computer it encounters errors.
What is the best way to 'network' the access database?????

Cheers

 

[Keith Wilby]

I have created a Database that is located on our local server. I need to
allow everyone on our network to use this database, but if I open it from
someone elses computer it encounters errors.
What is the best way to 'network' the access database?????

What are the errors?

Keith.
www.keithwilby.com

 

[Albert D.Kallal]

You should split the database, otherwise it tends to be un-relaiblary.

You can read about splitting here:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

And, after you split, you can read additonal notes on using ms-access in a
wide area network here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[Guest]

A command button on my switchboard encounters the error 'There was an error
executing this command'. Also reports are supposed to be opened from a form
but this doesn't happen?!?!? I only encounter these errors when opening the
file on somebody else's computer.

 

[Keith Wilby]

A command button on my switchboard encounters the error 'There was an error
executing this command'.

This error can occur when the user doesn't have permissions to the object
being called. Have you implemented any aspects of user-level security?
Does the other user have full network permissions to the network folder?

 

[Guest]

I would rather not split if possible, the reason being that I'm trying to
open the file from a web page on our intranet. Is there any work around or do
you have any ideas if I did split it????

 

[Douglas J Steele]

As far as I'm concerned, there's no justification not to split.

Having multiple users sharing the same front end, especially from a web
server, dramatically increases the risk of database corruption.