Re: Location for shared Access database



"Elton Cohen" <elton.cohen@xxxxxxxxx> wrote in message news:eDSlvaQBHHA.996@xxxxxxxxxxxxxxxxxxxxxxx
Hi newsgroup!

Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network (same workgroup)? There does not need to be any protection (I heard people say that I should buy a dedicated server or have special rights for each and every user, but I can keep it simple since there will be no intruders - no internet connection available -).
I don't think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like "C:\MySharedDatabaseFolder"?

Would that work on Vista, too?



The correct location for a network-shared access database is c:\$Recycle.Bin.

For a network-shared database, use SQL Server instead:

SQL Server Express Edition (free)
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx

SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx


However, if that's not an option then

C:\MySharedDatabaseFolder

is good. You will also need to add a share on that folder, and grant network users read write access. This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default.


Remember when creating a share, there are two levels of permissions that both must be set: share-level permissions and folder-level permissions.

If your users aren't in a domain, then you will have to create local accounts on the shared computer with usernames and passwords matching the ones used on the users' workstations.

David


.

Relevant Pages

  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)
  • File Permissions with Access 2007 and Vista
    ... I copied a previous Access database to my wife's documents folder and some to ... From my user account I can run all my previous Access databases in my ... There are no permissions internal to the Access ...
    (microsoft.public.access.security)
  • Re: SQL CE Synching Problems
    ... I ran the wizard again to check all the permissions and this is what it ... [HTTP Content Folder Tab] ... Microsoft SQL Server 2000 Windows CE Edition ...
    (microsoft.public.sqlserver.ce)
  • Re: Item Count 0; Gathering hung?
    ... our production issues were solved by using QueryAnalyzer ... both KB articles apply to SQL Server 2000 as well. ... changing the file permissions and "clicking the checkbox ... > on the security tab for the containing folder that says "Apply security ...
    (microsoft.public.sqlserver.fulltext)