Read only when loging in

[albert.repasky]

It has been awhile since I did this. I have created an Access 2003
program and have sent the DB to someone. She says she only has read
permissions and can not write out new records. I know it has
something to do with the System.MDW file. Do I just send her mine and
tell her where to put it? This DB does not need any special
permissions or passwords for people. I just want to make it simple.
Soon this will go on a server. What do I do them?

Maybe I seem like someone new, but it has been a long time and I do
not have any references or can I find any references on this.

So can anyone help me? Thanks for the help ahead of time.

arep

 

[Joan Wild]

It doesn't necessarily have anything to do with the mdw file. Is this database secured?

How did you send the file - via CD/email? Perhaps the file has the Read-Only flag set.


--
Joan Wild
Microsoft Access MVP
: It has been awhile since I did this. I have created an Access 2003
: program and have sent the DB to someone. She says she only has read
: permissions and can not write out new records. I know it has
: something to do with the System.MDW file. Do I just send her mine and
: tell her where to put it? This DB does not need any special
: permissions or passwords for people. I just want to make it simple.
: Soon this will go on a server. What do I do them?
:
: Maybe I seem like someone new, but it has been a long time and I do
: not have any references or can I find any references on this.
:
: So can anyone help me? Thanks for the help ahead of time.
:
: arep

 

[albert.repasky]

It doesn't necessarily have anything to do with the mdw file.  Is this database secured?

How did you send the file - via CD/email?  Perhaps the file has the Read-Only flag set.

--
Joan Wild

: It has been awhile since I did this.  I have created an Access 2003
: program and have sent the DB to someone.  She says she only has read
: permissions and can not write out new records.  I know it has
: something to do with the System.MDW file.  Do I just send her mine and
: tell her where to put it?  This DB does not need any special
: permissions or passwords for people.  I just want to make it simple.
: Soon this will go on a server.  What do I do them?
:
: Maybe I seem like someone new, but it has been a long time and I do
: not have any references or can I find any references on this.
:
: So can anyone help me?  Thanks for the help ahead of time.
:
: arep

I did not do anything in the DB for security, if that is what you want
to know. I did not do anything special. All I did was on startup,
hide everything so that the could not see the tables,etc. and limit
the toolbars.

I sent the DB by email by attaching the file in zipped format.

I suggested that she update to our version of Access, the 2003.

Anymore ideas?

Thanks,
arep

 

[Joan Wild]

I did not do anything in the DB for security, if that is what you want
to know. I did not do anything special. All I did was on startup,
hide everything so that the could not see the tables,etc. and limit
the toolbars.

I sent the DB by email by attaching the file in zipped format.

I suggested that she update to our version of Access, the 2003.

Anymore ideas?

Thanks,
arep

Sometimes a user's description can lead you astray. Does she get a message on opening that it is read only? Has someone else got it open at the same time? Does she (all users) have full permissions on the folder where the mdb is located? Does she get no message, but just isn't able to add a new record - that could be because the recordsource for the form isn't updateable.

 

[albert.repasky]

I did not do anything in the DB for security, if that is what you want
to know.  I did not do anything special.  All I did was on startup,
hide everything so that the could not see the tables,etc. and limit
the toolbars.

I sent the DB by email by attaching the file in zipped format.

I suggested that she update to our version of Access, the 2003.

Anymore ideas?

Thanks,
arep

Sometimes a user's description can lead you astray.  Does she get a message on opening that it is read only?  Has someone else got it open at the same time?  Does she (all users) have full permissions on the folder wherethe mdb is located?  Does she get no message, but just isn't able to add a new record - that could be because the recordsource for the form isn't updateable.

I found out she is out until tomorrow. She did not get an error
message. She tried to add a record and after adding it, it was not
there. No one else if using the DB. I just sent it to her to try it
out. Eventually it will be put on a server.

I do not know where she put it so I will ask her tomorrow. So I do
not know if she has full permissions on the file.

arep

 

[Joan Wild]

Sometimes a user's description can lead you astray. Does she get a message on opening that it is read only? Has someone else got it open at the same time? Does she (all users) have full permissions on the folder where the mdb is located? Does she get no message, but just isn't able to add a new record - that could be because the recordsource for the form isn't updateable.
I found out she is out until tomorrow. She did not get an error
message. She tried to add a record and after adding it, it was not
there. No one else if using the DB. I just sent it to her to try it
out. Eventually it will be put on a server.

I do not know where she put it so I will ask her tomorrow. So I do
not know if she has full permissions on the file.

arep

'After adding it, it was not there' - umm records don't just disappear. This is not an issue with file location, or file permissions. Is it possible that the form this person is using is set to Data Entry i.e. it always opens to add a new record/existing records aren't shown? Can she open the table and actually verify that the record isn't there? Is the form she's using bound?

 

[Margaret]

Please visit [email protected]/blog
I am starting up a business and need new customers. Any help that you could
give me, I would really appreciate it. Im not spaming anyone, so please let
me know if there are anyone you know who lives in the london area and would
be interested in the purchase of medical uniforms.

Im trying to get as many customers as i can. i need help tho. Please pass
this email on to whom ever you know who would be interested. I would really
appreciate it.

Here is a little about it:

We are a business that makes Medical Uniforms which are made for Nurse's,
Doctors, and any Medical team that there is out there like PSW's.

You can find more out about it at: [email protected]/blog

We have flexible plans to accommodate growth. All size's, styles and colors
that you can think of

We are located in London, Ontario

Thank you for your time.

Margaret