write create microsoft access rights?

I saved a small Access DB, that I developed, on our firm's network drive. I
can open it and read/write just fine, but another employee can not write to
the DB. When I open it on her machine, I get a message saying: The database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

SQL Server allows you to set permissions in just ONE place.. instead
of in 12 different places.

-Aaron



On Apr 16, 9:47*am, ryguy7272
wrote:
I saved a small Access DB, that I developed, on our firm's network drive. *I
can open it and read/write just fine, but another employee can not write to
the DB. *When I open it on her machine, I get a message saying: *The database
is read-only. *You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?

Regrads,
Ryan---

--
RyGuy

Wow! So only one person is allowed to make changes, for instance, to a
query? I am sort of new to the world of Access...I would have expected a lot
more control and a lot less restriction from Access. I really developed this
DB for someone other than myself to do some rather sophisticated queries.
How do I transfer permission to another person?

Regards,
Ryan--

--
RyGuy


"a a r o n . k e m p f @ g m a i l . c o" wrote:

SQL Server allows you to set permissions in just ONE place.. instead
of in 12 different places.

-Aaron



On Apr 16, 9:47 am, ryguy7272
wrote:
I saved a small Access DB, that I developed, on our firm's network drive. I
can open it and read/write just fine, but another employee can not write to
the DB. When I open it on her machine, I get a message saying: The database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?

Regrads,
Ryan---

--
RyGuy

Feel free to ignore Aaron. He is the neighborhood troll and just as likely
to provide misinformation as enlightenment (and that's being generous).

Does the user have full read/write/delete privileges to the network
location?

Is you have multiple people using the db at the same time, is your db
properly split between *local* Frontend (forms, reports, queries) and shared
network backend?

--
HTH,
George


"ryguy7272" wrote in message
news
I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. When I open it on her machine, I get a message saying: The
database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

In terms of the network, yes, full access.

As for the the other question...I don't really know what that means. I'm
learning Access as I go. I have a few books, which are helpful, but as far
as I can tell, none describe what to do in this scenario. Right now,
everything is reported in Excel. I'm quite proficient with Excel, VBA, etc.,
but I'm new to this Access stuff. Can you post a link here, which may
describe what to do in this type of scenario? I just developed the DB with
one table, I have a Form, with code, that allows a user to create some pretty
cool Reports on the fly. I also have a Form that SHOULD allow a user to
create some pretty cool Queries on the fly (with SQL, etc. passed by the Form
to the Query). This specific Query is the one that is a PITA right now. I
can't create any queries except on my own machine. The 'table' that I am
referencing is actually a link to a single sheet in an Excel workbook. If
you have a suggestion please post back. I'd be very surprised if Access
doesn't permit me to do what I am trying to do... It may be a little complex
for me, but I'd bet it is a piece of cake for for some Access MVPs out there.

Regards,
Ryan--

--
RyGuy


"George Nicholson" wrote:

Feel free to ignore Aaron. He is the neighborhood troll and just as likely
to provide misinformation as enlightenment (and that's being generous).

Does the user have full read/write/delete privileges to the network
location?

Is you have multiple people using the db at the same time, is your db
properly split between *local* Frontend (forms, reports, queries) and shared
network backend?

--
HTH,
George


"ryguy7272" wrote in message
news
I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. When I open it on her machine, I get a message saying: The
database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

Users need read/write permissions to the folder in which the mdb or mde file
is located. Access creates a lock file (ldb) during an Access session, and
deletes it when you end the session, which is why read/write permissions are
needed.

"ryguy7272" wrote in message
news
I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. When I open it on her machine, I get a message saying: The
database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

One of the IT guys here fixed it for me:
Right-Click Properties Security Users then check Full Control.

This just happened by default. I've worked with both Word and Excel, for a
very long time, and I've never seen this before. I've worked with Access for
only 6-months or so, but I've never seen this before.

Thanks to everyone for looking...

Regards,
Ryan---

--
RyGuy


"BruceM" wrote:

Users need read/write permissions to the folder in which the mdb or mde file
is located. Access creates a lock file (ldb) during an Access session, and
deletes it when you end the session, which is why read/write permissions are
needed.

"ryguy7272" wrote in message
news
I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. When I open it on her machine, I get a message saying: The
database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

Oops. This was already covered. I guess it had been a while since my
newsreader downloaded new messages.

"BruceM" wrote in message
...
Users need read/write permissions to the folder in which the mdb or mde
file is located. Access creates a lock file (ldb) during an Access
session, and deletes it when you end the session, which is why read/write
permissions are needed.

"ryguy7272" wrote in message
news
I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. When I open it on her machine, I get a message saying: The
database
is read-only. You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?


Regrads,
Ryan---

--
RyGuy

yes; that is correct.

In an Access Database; only one person is allowed to change queries--
due to a poor design. Access databases are a decade obsolete-- it is
no longer reccomended for new people to grow into Access.

It is reccomend that anyone- that wants to learn about databases-
should go and take a class about SQL Server.

With SQL Server; you can build and share queries in between users.
This concept is called 'code reuse'-- and it is not possible with
Microsoft Access.

-Aaron





On Apr 16, 10:33*am, ryguy7272
wrote:
Wow! *So only one person is allowed to make changes, for instance, to a
query? *I am sort of new to the world of Access...I would have expected a lot
more control and a lot less restriction from Access. *I really developed this
DB for someone other than myself to do some rather sophisticated queries. *
How do I transfer permission to another person? *

Regards,
Ryan--

--
RyGuy

"a a r o n . k e m p f @ g m a i l . c o" wrote:



SQL Server allows you to set permissions in just ONE place.. instead
of in 12 different places.

-Aaron

On Apr 16, 9:47 am, ryguy7272
wrote:
I saved a small Access DB, that I developed, on our firm's network drive. *I
can open it and read/write just fine, but another employee can not write to
the DB. *When I open it on her machine, I get a message saying: *The database
is read-only. *You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?

Regrads,
Ryan---

--
RyGuy- Hide quoted text -

- Show quoted text -

Feel free to ignore George. He is the neighborhood troll and just as
likely
to provide misinformation as enlightenment (and that's being
generous).

Have you upgraded to SQL Server yet?

If you have multiple people using the db at the same time, you should
move to SQL Server.

--
HTH,
George




On Apr 16, 11:02*am, "George Nicholson"
wrote:
Feel free to ignore Aaron. He is the neighborhood troll and just as likely
to provide misinformation as enlightenment (and that's being generous).

Does the user have full read/write/delete privileges to the network
location?

Is you have multiple people using the db at the same time, is your db
properly split between *local* Frontend (forms, reports, queries) and shared
network backend?

--
HTH,
George

"ryguy7272" wrote in message

news


I saved a small Access DB, that I developed, on our firm's network drive.
I
can open it and read/write just fine, but another employee can not write
to
the DB. *When I open it on her machine, I get a message saying: *The
database
is read-only. *You won't be able to save the changes made to data...

Is there a setting or control that will allow full read/write rights?

Regrads,
Ryan---

--
RyGuy- Hide quoted text -

- Show quoted text -