share the database from Network server

[Guest]

Hello All,

I have an Access database and I need this to share in the network server.
Actually my users are only using some forms and printing the reports using
the database.

What are the steps I should use in order to access the database by my users
at the same time.

In hepfile, I saw that keep the database in shared mode.

Is that the only thing I have to do?

I am new to this area, any help really appreciated.

 

[Guest]

Hi,
you HAVE TO split your application into a frontend/backend set up.
What makes your database a multi user database? A split application is a
multi user environment. So what you need to do is split your application into
frontend (holding forms/modules/queries/reports) and backend (holding
tables). You can do this manually by creating a blank new database and
importing the one part and deleting it out of the other and then relinking
the two, OR you can use the database splitter which is an easy tool which
does this for you automatically. You can find it under tools--database
utilities--database splitter. It will create two files out of your one mdb
and seperate the objects and create table links in the frontend to link to
the backend.
Now ones you have this split you need to give EACH user a copy of the
frontend. They should store it on their local drive. Then move the ONE
backend to the server/shared drive location which everyone has access to.
Now you just need to relink to this ONE backend from all the frontends since
the location obviously changed. You can do this by individually openeing the
frontends on the local users machines and using the link table manager. You
can right click on any table link in the database window and select link
table manager. This will pop up a new window showing the paths of all links
to the backend. Select them all, check the checkmark on the bottom and press
ok. Then browse to your new location where the ONE backend is and press ok
again. This will automatically refresh all the table links. Then close and
reopen the db and voila you should everything set up the way you want.
HTH
Good luck