accessing shared database table

[Guest]

I have volunteered to help a small catholic school in my neighborhood. Last
year, the principal spent her summer trying to compile 40 teacher's separate
booklists for the new term. (I didn't know that Silver-Burdett <publisher>
could be written so many ways!) I thought that I could help by creating a
simple Access db where each teacher can oder her books by accessing a simple
form on their network.

I have a pretty good idea of how to creat the tables and form, but I'm
unsure how to get each teacher to access it.

I have been reading several posts regarding splitting the database. I know I
don't want them to have access to my tables.

I am not a programmer. Just a mom-volunteer trying to help some good folks.
I want to make this as simple as possible.

Any help in this task would be greatly appreciated!

Kris

 

[Joseph Meehan]

I have volunteered to help a small catholic school in my neighborhood.
Last year, the principal spent her summer trying to compile 40
teacher's separate booklists for the new term. (I didn't know that
Silver-Burdett <publisher> could be written so many ways!) I thought
that I could help by creating a simple Access db where each teacher
can oder her books by accessing a simple form on their network.

I have a pretty good idea of how to creat the tables and form, but I'm
unsure how to get each teacher to access it.

I have been reading several posts regarding splitting the database. I
know I don't want them to have access to my tables.

I am not a programmer. Just a mom-volunteer trying to help some good
folks. I want to make this as simple as possible.

Any help in this task would be greatly appreciated!

Kris

Splitting the database is a good thing generally. If it is likely two
or more might be trying to access the database at the same time I suggest
that you split the database.

The question of letting them access your tables, is a totally different
mater. That is addressed with security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

Thank you

I have volunteered to help a small catholic school in my neighborhood.
Last year, the principal spent her summer trying to compile 40
teacher's separate booklists for the new term. (I didn't know that
Silver-Burdett <publisher> could be written so many ways!) I thought
that I could help by creating a simple Access db where each teacher
can oder her books by accessing a simple form on their network.

I have a pretty good idea of how to creat the tables and form, but I'm
unsure how to get each teacher to access it.

I have been reading several posts regarding splitting the database. I
know I don't want them to have access to my tables.

I am not a programmer. Just a mom-volunteer trying to help some good
folks. I want to make this as simple as possible.

Any help in this task would be greatly appreciated!

Kris

Splitting the database is a good thing generally. If it is likely two
or more might be trying to access the database at the same time I suggest
that you split the database.

The question of letting them access your tables, is a totally different
mater. That is addressed with security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.