splitting - beginner

[Linda]

Bonjour, I'm setting up a db to share with 6 others. Now
when I split it, it asks me to save and has an automatic
BE in the name, no problem there. When I come back to my
screen there is an arrow next to the title of my table.
What is that? Also, now that the db is split, which part
of it do I send the the users and which one do I keep?
Many thanks!

 

[Douglas J. Steele]

The arrow is just a way of indentifying that the table is linked.

Each user should have his/her own copy of the front-end, preferably on
his/her hard drive (as opposed to on the network). The back-end, which all
of the users will be sharing, must be on the server.

Note that each user must have Change (Read, Write, eXecute, Delete) access
to the folder where the MDB is located on the server. This is because the
first user to connect to the back-end will cause a locking file (.LDB) to be
created in that folder, subsequent users will update that file, and the last
user out will cause the file to be deleted.

Note too that if your front-end is linked to the back-end using a drive
letter, each user must have that drive letter mapped the same way. If you
don't have a standard logon script that maps drives for your users, you
might find it easier to link using a UNC (\\server\share\folder\file.mdb,
rather than F:\folder\file.mdb)

 

[Dave]

When I come back to my

screen there is an arrow next to the title of my table.
What is that?

this indicates that the table is linked and not local

The idea is you place the BE (Back End) on the server and the six users all
get a copy of the front end.

The problem you may now have is that the link path for the tables will be
something like "C:\Databases\NewDatabase\somethingBE.mdb"
What you need to do is go into the front end uand change this path to where
the db will reside.

The easiest way is to use the Linked table manager, in A97 this is in
Tools->Add-Ins
Select 'always prompt for new location' and then select all
Click on OK and then find the BE database make sure you look accross the
network and not locally so the path is //SERVER/c/etc

then you should be able to copy the front end to the uisers machines.

Back up everything before you do this incase everything ive told you is wong

hope this helps
Dave