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

Google drive messed up access database

  • 18-06-2012 9:00pm
    #1
    ScumLord
    Registered Users, Registered Users 2 Posts: 28,789 ✭✭✭✭


    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,789 ✭✭✭✭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