Share Database on LAN

[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

 

[Golfinray]

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

 

[George]

Thanks - Thought it would be easier....

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

 

[Klatuu]

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.

 

[jrthor_85 via AccessMonster.com]

... www.member.shaw.ca/albertkallal

Would it be possible for you to check that address? I'm quite interested in
reading through suggested "good reading" on this, but the link only pops up a
"user not found" dialogue box.

Thanks in advance,
John

 

[Klatuu]

There is no www. It should be:
http://members.shaw.ca/albertkallal/

Albert is one of the very best.