Share Database on LAN

  • Thread starter Thread starter George
  • Start date Start date
G

George

I created a database and it works great as a stand alone application. When I
put it on our company LAN only one person at a time can have it open, how can
I fix it so multiple people can open the program?

Thanks - George Williams
 
Split your database. Be sure and make a backup copy FIRST. Then go into
tools/database utilities/database splitter and split the database into 2
pieces. One will be your mdb and contain all your queries, forms, reports,
and pages. The other, called the BE will be your tables. The mdb will now
contain links to all your tables. Some people then recommend that you go
ahead and create an mde file if you are concerned about security. Read the
help file on mde if you you are concerned about it. With the mdb and BE on
your lan, go to each user and copy the mdb into their My Documents folder.
Then create a shortcut to it on their desktop. Now users will each have their
own copies of the forms, report, and be linked to the tables on the LAN.
Albert Kallal has a great article on database splitting at
www.member.shaw.ca/albertkallal
 
Thanks - Thought it would be easier....

Golfinray said:
Split your database. Be sure and make a backup copy FIRST. Then go into
tools/database utilities/database splitter and split the database into 2
pieces. One will be your mdb and contain all your queries, forms, reports,
and pages. The other, called the BE will be your tables. The mdb will now
contain links to all your tables. Some people then recommend that you go
ahead and create an mde file if you are concerned about security. Read the
help file on mde if you you are concerned about it. With the mdb and BE on
your lan, go to each user and copy the mdb into their My Documents folder.
Then create a shortcut to it on their desktop. Now users will each have their
own copies of the forms, report, and be linked to the tables on the LAN.
Albert Kallal has a great article on database splitting at
www.member.shaw.ca/albertkallal
Click to expand...
 
There is an easier, faster way, but you don't want to do it.
Taking the time and effort to do it correctly will save you a lot of grief
and work later.
 
Back
Top