Multiple user's issue

[pablofonto]

Hello Everyone,

I have a database that I splited the tables on one file and queries, forms and macros in another. The front end file (the one with the forms) I published it in our intranet, so when some one clicks on the link a form pops up which is the way it supposed to work. The problem I have is when some other people in my area go to the intranet and click on the link and get the error that the file is read-only and the macro that makes the form open up fails. I checked the file's properties and is NOT read-only, so I don't knwo what the problem is.

Please help!

thanks,

Pablo

 

[jamesmor]

maybe the front end is being opened in exclusive mode? or more than 1 person is trying to get into the db at once?

 

[ByteMyzer]

The problem is that the location where your front-end file resides in a location where not everyone has complete read AND write access. Regardless of your file's attributes, if a user has Read-Only access to the file's location (ex. H:\Intranet Folder\), then ANY file in that location will be read-only to that user.

 

[pablofonto]

I will check to see what access these users have to the file location and will post my findings.

Thanks for the input.

Pablo

 

[pablofonto]

Thanks for the information

ByteMyzer you were right on the spot. I asked some of my users to modified a simple excel file located in the same place where my access file resides and they were not able to make changes to it. I will work with my IT guys to see if I can get access to this network location for my users so that will solve the issue.

Thanks for your help!

Pablo