Read Only table

S

stucampbell

I have a database which has always functioned fine. Recently I had Access
installed on a new PC to access the database from a different desk. From the
new PC I can not enter information into the main table I use for storing
information, rendering the database useless. However, from the old PC the
database still functions as normal.

The only difference that I can think of is that Office SP2 is installed on
the new machine and not on the old one.

Has anyone seen this before or have any ideas?

Stu.
 
D

Dennis

What version of Access? Is the application split into a front-end/back-end
design? If so, is the back-end a SQL or Oracle database?
 
J

John W. Vinson

I have a database which has always functioned fine. Recently I had Access
installed on a new PC to access the database from a different desk. From the
new PC I can not enter information into the main table I use for storing
information, rendering the database useless. However, from the old PC the
database still functions as normal.

The only difference that I can think of is that Office SP2 is installed on
the new machine and not on the old one.

Has anyone seen this before or have any ideas?

Stu.
Click to expand...

The user of the new PC must have *full* read, write, create and delete
privileges to the (network) folder containing the database.

Note that for a multiuser networked application it's a very good idea (some
would say essential, though it's not absolutely so) to use a "split" database
architecture:

http://www.granite.ab.ca/access/splitapp.htm

John W. Vinson [MVP]
 
Top