Question Installing db on a server

[Tumby]

I have completed my first database and tomorrow I have to install it on a server and four PC's.
The 4 PC's all have Access, the server does not.

Am I correct in doing the following?

Installing it on one PC, splitting it and putting the backend in the shared folder on the server. The backend will automatically link to this PC.

I thought I would then copy the frontend onto my memory stick and install it on the other three PC's.

Do I have to manually link to the backend tables from the other 3 PC'c?

Also if everything goes well, will the tables automatically update when the users enter data into their frontends?

As you can probably tell I am a novice!

I have read threads and articles on this but still feel very nervous about doing it.

Any help will be greatly appreciated.
Don't know what I would do without this forum, it's been such a great help to me and I have learned so much.

 

[Rabbie]

I have completed my first database and tomorrow I have to install it on a server and four PC's.
The 4 PC's all have Access, the server does not.

Am I correct in doing the following?

Installing it on one PC, splitting it and putting the backend in the shared folder on the server. The backend will automatically link to this PC.

This is correct.

I thought I would then copy the frontend onto my memory stick and install it on the other three PC's.

Do I have to manually link to the backend tables from the other 3 PC'c?

If the path to the folder on the server holding the BE is the same on all PCs then you won' have to manually link.

Also if everything goes well, will the tables automatically update when the users enter data into their frontends?

Yes

As you can probably tell I am a novice!

I have read threads and articles on this but still feel very nervous about doing it.

Any help will be greatly appreciated.
Don't know what I would do without this forum, it's been such a great help to me and I have learned so much.

good luck.

it will be worth your while to check out the utility on Bob Larson's website for keeping the FE dbs in sync.

 

[Tumby]

Thank you very much Rabbie, I will sleep well tonight now!

I'm pretty sure the path to the server will be the same on all PC's but I will check.

I will also check out Bob Larson's website.

Thanks very much again!