Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Google drive messed up access database

  • 18-06-2012 10:00PM
    #1
    ScumLord
    Registered Users, Registered Users 2 Posts: 28,787 ✭✭✭✭


    I tried moving an access database on a windows server 2003 machine into a google drive folder in the hopes it would be a way of backing up the database.

    Since doing that I'm having trouble with the database. The first error was " this site is located outside your intranet....." But after research that seemed to be solved by putting the server into internet explorers trusted sites.

    The current problem is that when I open the database on the client machines the forms are blank. When I go into into design view and the data tab and set data entry to off I can see the forms fine but obviously can't ad any new data.

    I have been researching the problem on this site and have read talk about the primary key being missing, which I think it is. I'm assuming that me moving the database on the server into the google drive folder has somehow corrupted it and I'm hoping it's an easy fix.


Comments

  • #2
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    Restore it back to the windows server from the backup you took before moving it.


  • #3
    ScumLord
    Registered Users, Registered Users 2 Posts: 28,787 ✭✭✭✭ScumLord


    FSL wrote: »
    Restore it back to the windows server from the backup you took before moving it.
    The backup will be short a bit of data so I'd prefer to get this up and running and I'm really close now.

    I can't for sure say why it's mostly working now, the issue was with folder permissions but after a few restarts of the server it just seems to be working now bar one table, the main table. How do I fix the link between the form and the table?


  • #4
    CreepingDeath
    Closed Accounts Posts: 8,015 ✭✭✭CreepingDeath


    ScumLord wrote: »
    I tried moving an access database on a windows server 2003 machine into a google drive folder in the hopes it would be a way of backing up the database.

    Did you try backing up the database while the database was open?
    That's a sure fire way of corrupting something, especially a toy database like Ms Access.


Advertisement
Advertisement