Setting Permissions

[Guest]

Uploaded database in MSacess 2007 format to public html doc. Set database
with full permissions using 777 code. Verified that it does show full public
permissions on server. When I open thru my web page it comes up read only.
Any ideas?
Before upload permissions set to everyone full control.

 

['69 Camaro]

Hi.

Uploaded database in MSacess 2007 format to public html doc.

So in English, you FTP'd a Microsoft Access database to a Web server, where
a Web page on that server is accessible by the public (presumably via the
Internet) and has a link to this database file's location for Web visitors
to download the file to their own workstations. Correct?

Set database
with full permissions using 777 code.

If you mean that you used:

chmod 777 DBName.accdb

.. . . or a GUI that set this particular permission level, then the file is
on a Linux or Unix Web server. Don't expect to "run" the database from a
Web page with SQL queries. (If you wanted to do that, then you would need
to switch to a Windows Web server and set appropriate Windows security
permissions on the directory and the file.)

When I open thru my web page it comes up read only.

Access isn't designed to be opened or used from the Web, but with certain
versions of the Windows operating system and Access, and certain settings on
the client workstation, the database file can be downloaded from a Web
server and opened without a separate step of opening the file via Windows
Explorer or an open session of Access. Don't expect all users to have those
specific versions of Windows, Access, and those settings. And with Access
2007, one needs to deal with the Macro Security issues as well.

My suggestion is to download the database file to your hard drive, navigate
to the directory in Windows Explorer, check the file for viruses, then
right-click on the file name and select "Properties" from the pop-up menu.
Uncheck the "Read-only" attribute and select the "OK" button to save the
change. (Also select the "Unblock" button if it appears on the Properties
dialog window.) Then open the database file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Thanks for the input. I am trying to share this database on a closed network.
(log in only access). I have three offices in different cities each with
there own database networked. I wanted the other offices to have full access
to the database and take the existing offices off a network and work from the
internet.Yes I am using the chmod code.All offices are running MSacess 2007.
Thanks again

 

['69 Camaro]

Hi.

I wanted the other offices to have full access
to the database and take the existing offices off a network and work from
the
internet.Yes I am using the chmod code.All offices are running MSacess
2007.

Microsoft Access doesn't run natively on a Linux or Unix Web server. It
requires a Windows server. To "work from the Internet," a Web application
needs to be built to interact with the data stored in the Access database,
because the forms, reports, et cetera, in the Access database application
aren't designed to be run from the Web. Access is a desktop database
application, not a Web application.

I am trying to share this database on a closed network.
(log in only access). I have three offices in different cities each with
there own database networked.

In other words, you have a WAN (Wide Area Network), which is not recommended
for Access databases, due to very slow speeds and possible disconnects.
Consider using Terminal Services instead to "work across the Internet," not
"work from the Internet," which would require building a Web application to
access the data in the database file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.