Please Help!! Networking Issues

A

A. Smart

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
 
K

Keith Wilby

A. Smart said:
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?????
Click to expand...
What are the errors?

Keith.
www.keithwilby.com
 
A

A. Smart

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.
 
K

Keith Wilby

A. Smart said:
A command button on my switchboard encounters the error 'There was an error
executing this command'.
Click to expand...

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?
 
A

A. Smart

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????
 
D

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.
 
B

Bob Miller

No matter what errors you are getting you should have a backend (be) db
on the server with only the tables and a frontend (fe) db on each PC
with links to the tables in the be. All of your user interfaces
(queries, forms, etc.) will be in the fe. Doing this will
eliminate/avoid a number of errors that come using a single multiuser
Access database.
 
Top