Multiusers? 1

[BT24]

Hello
I tried to split my database so that there could be multiusers, i just thought that it would make a duplicate that i could put on the network so that i could still change things and the operators could still enter there data. but what happened is that it only made a copy of the tables. is this what is supposed to happen? thanks for the help
BT24

 

[Junior1544]

When you run the database slitter, it makes a new mdb, and moves all the tables over to that mdb. then, in the origanel mdb, it put's a link to the back end mdb... so all the forms, queries, reports, and all that good stuff is in the one (the front end) and just the tables and table relationships are in the other (the back end).

Now, the back end needs to be put on a server where all users have full access(they need read, wright, and delete) to the directory. The front end needs to then have the tables refreashed... (Tools>database utilities>Linked table manager)

now you can distribute the front end to all your users... they use that to access the back end because they are linked

--JAmes
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[BT24]

Oh i see thanks! so when the tables are linked automatically?
Thanks James

 

[Junior1544]

yup, but you need to re link the tables if you move the back end... (the mdb that has the tables in it...)

Hope i helped... junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[BT24]

You were very helpful thanks