Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

file access/modification across a network

  • 24-08-2009 12:17pm
    #1
    humaxf1
    Registered Users, Registered Users 2 Posts: 865 ✭✭✭


    Hi all,

    Lets say you have a Vista Business PC acting as a "file server" and a XP Pro PC on a simple peer-peer workgroup network. There is a MS Access database on the Vista PC (MS Office 2007). The plan is to have the database open on both machines at the same time and be able to make changes from either machine. Access 2003 is installed on the XP Pro machine.

    Via a mapped drive, the XP Pro PC can open the database, but a popup says it's READ ONLY.

    1. XP and Vista user accounts are password protected
    2. I added the credentials of the XP Pro machine user on the Vista machine
    3. I added the XP Pro user account to the security for the database file and gave it full control

    The READ ONLY message still comes up. Is this a networking, Access version issue or? I'm no Access expert by any means.

    Any ideas? thanks in advance


Comments

  • #2
    Fysh
    Moderators, Arts Moderators, Regional Abroad Moderators Posts: 11,106 Mod ✭✭✭✭Fysh


    It could be down to the database file format - Office 2007 introduced new default file formats which aren't backwards compatible, and Office 2003 has an update which allows the files to be viewed but not modified. If you've got your database stored as an acddb file, then Access 2003 will open it as read-only - try saving the database as an mdb file as that's a format Access 2003 understands.

    All of this being said, I'm not convinced that you'll be able to have the DB open on more than one machine at the same time - I have the feeling you need to be sharing the files using Sharepoint on a Windows Server machine to allow concurrent use of the same file, but I could be wrong.


  • #3
    humaxf1
    Registered Users, Registered Users 2 Posts: 865 ✭✭✭humaxf1


    Good point on the file extension. Why the hell did MS have to re-invent the wheel with their Office 2007 extensions. God knows what woes Office 2010 will bring arrrrrrrghhhhhhhh!!!

    I did a little experiment today. (on my laptop - XP Pro SP3, Access 2003) I copied the DB into a folder. I shared out the folder & ticked "allow users to make changes" blah blah and no more.

    I then went to the XP PC and from the run box \\<ip address> of the laptop, into the folder and opened the DB with no read only message. Modified a few fields etc.

    When I looked at the DB on the laptop, the changes were there. It's only dawned on me right now that the DB was NOT open on the laptop at the time. Anyhow, would this suggest that Vista sharing permissions are too locked down for it's own good/Access 2007 issue?

    :confused:


  • #4
    CCSL
    Closed Accounts Posts: 422 ✭✭CCSL


    Vista defaults to only giving Read only access to shared directories.

    Go into sharing - Advanced sharing and permissions add full control to everyone and off you go! (probably)

    In Access you will also need to check the default method for opening a file and make sure it is set to shared not exclusive. its in Tools options in the 2003 version.

    I do this kind of setup often and it can be a bit fiddley with vista.
    :o


Advertisement