Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing (Access 2000/Windows XP)

    I have a client who I wrote a system for. Said system has a database of just tables using jet. The second database is of forms, reports and queries using the first database. The system was written for Windows 98 and office 2000. The system would allow multiple users to access the tables at the same time. The client upgraded the system to Windows XP, but is using Office 200 still. However, now if the a user opens a form or report using the second database the tables on database one are locked, until the file or files are released. I have checked sharing option and they are still record locking and share. Has anyone else seen this problem? Does any one have any ideas? Does anyone know if going to Office 2003 will solve this problem? I do not want to tell the client to go to Office 2003, which is going to cost thousands of dollars, and still have the problem occurring.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing (Access 2000/Windows XP)

    What version of Windows XP are they using and what service packs have been applied? I seem to recall that there were problems with the vanilla version of XPHome that prevented sharing Access files.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Charlette,
    This is a business and is using pro with all service packs since 01/2004 in place. The installation was done by a dealer who sold the hardware. I myself have little more knowledge of XP then this. All folders and databases have been setup for Adds, Deletes and Changes by everyone. The dealer had reps out on this past Tuesday (2/12/2004), and said everything was set up correctly and that the client needed Office 2003. I just feel I am in the middle, and do not know who's on first.
    Sarge

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sharing (Access 2000/Windows XP)

    I don't know the cause or solution, but I am sure that it is possible to share a database in Access 2000 on Windows XP Pro. Some setting must be wrong, and there is no guarantee that migrating to Access 2003 would solve this.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sharing (Access 2000/Windows XP)

    I agree with Hans - there is no reason you can't run an Access 2000 database in shared mode on Windows XP, and Office 2003 isn't likely to help at all. Did the dealer setup an NT domain, or is it still running as a workgroup? Most likely, as Charlotte suggested, there is a pemissions issue with the folder where the .MDB and .LDB folders are stored. Another possibility - Office 2000 had to be installed on each PC, and it was setup to run Access databases in the exclusive mode. What kind of error message do you get when a second user tries to open the database? Also, is the front-end database shared, or is it installed on each PC?
    Wendell

  6. #6
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Well there are workgroups as far as I can tell. There is no messages. The tables are in one database on a server and is shared. Each of the other computers contain an Access database of forms, queries and reports which link to the first database of tables (jet format) on the server. What happens is one computer opens a form or report using the local Access database. It locks all tables on the Access database on the server, until the user leaves the form or report which was open on the local database. All databases are marked as shared and record locking. I believe that the problem is XP, but they keep saying everything is correct, so it must be Office 2000 that is causing the problem. The thought is one or more of the dll's has changed and Office 2000 can not handle the change. Since I know little about XP, except I do not like it. I am the guilty one, unless I can prove otherwise.
    Sarge <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing (Access 2000/Windows XP)

    The dealer is trying to sell you a pup! There is no reason that Access/Office 2000 cannot run on Windows XP in a shared environment. Are your users using shortcuts to open their database? The shortcut needs to point to the correct workgroup file, as well as to the Access executable and the front end database on each machine. It should NOT have an /excl switch in the shortcut. If they're using a shortcut that does not include the Access executable path, other arguments will be ignored and the database will be opened without the workgroup and other instructions.

    If this database was running properly under Windows NT or 2000, it should do so under XP as well.
    Charlotte

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sharing (Access 2000/Windows XP)

    And I agree with Charlotte - Access 2000 works just fine on XP - we do it regularly. In addition to the things she suggested to check, have a look at the permissions for the folder where the back-end database is stored. It should allow everyone (who wants to use the database) full permissions, including create, delete and edit - with XP your file system is probably NTFS, which has a different file and folder permissions structure than Windows 98, and it's just possible that the lock file (.LDB) doesn't have sufficient permissions.
    Wendell

  9. #9
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Charlotte,
    They run from short cuts, but when I go up there I do not. I use explorer and double click the MDB. And I have the same problems. It ran fine under Windows 98 using Office 2000.
    Sarge

  10. #10
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Wendell,
    Yes the files are now NTFS and not FAT. I thought I had every permission changed to everyone and all could add, modify or delete. As I have said I know little about the Windows XP operating system, and the dealer keeps saying all is right. I believe in my heart of hearts that the problem is theirs, but the client keeps pointing the finger at me. I like solving program problems, like taking a task and computerizing it so that it helps to make some one's tasks easier. However, I have no care to know the inner workings of Windows. When I was a mainframe programmer these problems belonged to the techs. This is the one thing I really hate about PC's is you have to know everything not just your jobs area. Sorry I just have to vent.
    Sarge <img src=/S/smash.gif border=0 alt=smash width=30 height=26>

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sharing (Access 2000/Windows XP)

    The most common issue when working on XP is that the folder in which the .MDB file is stored must allow users to create, modify and delete the .LDB file that Access creates any time someone has the database open. Of course the .MDB file must have those same permissions (actually I think you may be able to turn off the delete, but to get things going turn them all on to start with). I haven't tested this, but users may also need those same permissions for the folder that the front-end is stored in as well. The front-end isn't shared, but it may be that if the front-end can't be opened in the shared mode, then the back-end can't be either. You could also run a test by simply opening the back-end directly from one workstation, and then try it from another - that would take the front-end out of the equation. Good luck.
    Wendell

  12. #12
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Wendell,
    Thanks. I am going to see the client Thursday, so I will see if this helps. Once again thanks for the Help.
    Sarge

  13. #13
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Charlotte,
    I just want to thank you for your help. Thank you.
    Sarge

  14. #14
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing (Access 2000/Windows XP)

    Charlotte,
    Thursday we put Office 2003 on the windows XP system. Now the Access MDB's are working. It seems that some of the dll's changed, and corrected my problems. I just thought you would like to know that the problem is solved.
    Thank you for your astenance.
    Sarge <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •