Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Split Database (Access 97)

    Ever since I split my database, I can no longer access my table via Microsoft Query. Is there something I did wrong during my split?

    thanks
    christine
    thanks
    christine

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

    Re: Split Database (Access 97)

    Hi Christine,

    You should use MS Query to connect directly to the table in the backend database. Trying to connect through the linked table in the frontend probably won't work.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    I am trying to go directly to the dataset. I am still getting a "cannot access" message. I am trying all 3 data source definitions:MS Access 97 Database*
    MS Access Database (not sharable)
    MS Access Database*
    thanks
    christine

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    I just found an error that states I have the database open exclusively. Strange. I have it setup for shared. All users are in right now and working. What did I do?

    I also just kicked all users out to clear the lock. It still is showing the files in use with no one in. What do I do with this?
    thanks
    christine

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

    Re: Split Database (Access 97)

    Did a rogue .ldb file get left behind in the same folder as the database?

  6. #6
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    I think so. I trace it back to a user that I just had shut down their entire system. No luck. I can't get by the files.
    thanks
    christine

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

    Re: Split Database (Access 97)

    I'm not an expert in this, but if the database is on a network share, perhaps the network administrator can reset the file locks or something like that, and remove the .ldb if it is still there.

  8. #8
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    Okay, it only took a few hours, but I finally got it all cleared up. No one is in the database, no records are locked, nothing! The problem with Query is still happening. Where to now?

    thanks
    christine
    thanks
    christine

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

    Re: Split Database (Access 97)

    What happens if you make a copy of the backend database? Can MS Query retrieve data from the copy?
    If that doesn't work, create a new blank database in the same folder, and import all tables from the backend database. Can MS Query retrieve data from the new database?

  10. #10
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    I've tried the copy and the importing suggestion. No luck. I'm still getting the "cannot access" error.
    thanks
    christine

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

    Re: Split Database (Access 97)

    Umm, you didn't happen to secure your database at the same time you split it, did you?

  12. #12
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    No, it's been secured for months. I changed everyone's password when I split it, though. Everyone is in there working and updating with no problems. Even some of the reports that I have written before I did the split work fine. It's only when I try to create a new one that I get the problem.
    thanks
    christine

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

    Re: Split Database (Access 97)

    If you're sure that you could get at the data using MS Query after securing but before splitting the database, I'm stumped. Splitting should have no influence whatsoever; the back end is just a database with all the tables from the original, without any modification. I'm sorry...

  14. #14
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Split Database (Access 97)

    Okay, I think I've found something. I tried to create a new database, totally unrelated to my original. I have a brand-new table and found the same problem. It's got to be the workgroup setup. But, when I went to review the permission, there was nothing unusal. Am I missing something?
    thanks
    christine

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

    Re: Split Database (Access 97)

    Have you tried joining the default unsecured workgroup System.mdw (assuming that you haven't modified that)?

Page 1 of 2 12 LastLast

Posting Permissions

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