using access 2K on a network

[Alienz]

Hey guys heres my network question:
1- when I selet Tools-startup and limit the access to access, it
applies to all of the users on the network who are accessing the
database through a network folder. How can I let the startup feature
be unique for whoever has it setup. Would it have to do with creating
a linked replica that each user uses (tools menu-create replica). I
havent looked at the password issues yet so this is my main question.

2- when I open access im notified that its read only because someone
else has it opened first. But, although we were both using the same
mdb file we were using separate forms. Should we link the forums to
separate mdb files.. is linking the solution here..

-please skip your lunch and answer my questions!!!!!!!!!!!!!!!!!!!

[Ray]

ks*****@yahoo.com (Alienz) wrote in message news:<58**************************@posting.google. com>...

Hey guys heres my network question:
1- when I selet Tools-startup and limit the access to access, it
applies to all of the users on the network who are accessing the
database through a network folder. How can I let the startup feature
be unique for whoever has it setup. Would it have to do with creating
a linked replica that each user uses (tools menu-create replica). I
havent looked at the password issues yet so this is my main question.

2- when I open access im notified that its read only because someone
else has it opened first. But, although we were both using the same
mdb file we were using separate forms. Should we link the forums to
separate mdb files.. is linking the solution here..

-please skip your lunch and answer my questions!!!!!!!!!!!!!!!!!!!

Hello,

Now that my lunch is interrupted.......

Try setting up a front-end / back-end system.

Front End: Holds all objects except tables.
Back End: Holds ONLY the tables.

Link the Frontend to the backend, Located on server.

Put the newly linked Front-end onto the users computers
to access from. Make sure when the front-end is linked,
it is done while the back-end is on the server drive.

Now each user will have their own Front-end and access
the data at the same time without any read-only conflicts.

Regards,

Ray

Back to Lunch.

[Alienz]

thanks.. but if I linked forums like this would it automatically
update any updates that I'd make to the forum design for that user?

[Alienz]

thanks.. but if I linked forums like this would it automatically
update any updates that I'd make to the forum design for that user?