copy paste problem

[brino]

hi all ,

one of my clients was copying & pasting into one of the tables in a
database that i designed for them.
suddenly about 6 months ago the database will not allow them to copy
data into the table.
i have not touched the database at all in this time.
can anyone help me with this as im a bit stumped.
im not sure if there IT Support guy has changed there security
settings or not?
i can still copy data into the database on my laptop , but it will not
work on there system.

thanks

 

[Larry Daugherty]

Allowing your users to have direct access to the tables of your
application is a really, really, really *bad* idea. Your data is
vulnerable to user created data errors whether inadvertent or
deliberate. Access is not a flawed version of Excel. They are
distinctly different platforms and each is excellent in its sphere of
operations.

You should be providing your users with Forms based on Queries which
are based on your tables. By doing that you can present your users
with only the data in which they are interested and protect the rest
of the data from casual interference.

As to your immediate symptoms, it is most likely that IT has "fixed"
things to be right with the poetry in their heads. They have probably
changed the Access Control List. A way to test that is to try to
create a new file in the destination folder. and save and edit it.
Just a simple text file would do. To properly use Access you need all
rights on the target folder, no exceptions.

HTH