geekhack

geekhack Community => Other Geeky Stuff => Topic started by: Oqsy on Mon, 15 August 2011, 13:47:21

Title: Help with MS Access database
Post by: Oqsy on Mon, 15 August 2011, 13:47:21

The Access database I use daily at work was moved from server to server against my wishes a couple of times and now I'm working from a "replica".
I can continue to add new records, but I have limited access to many of the tables and lookups because of the "replicated" flag.
I *need* to edit some of that data very badly, but I'm stuck.  Does anyone with Access/SQL experience that know how to kill the replicated flag to allow full privs again?
I'm sure there's a workaround so you don't have to rebuild from scratch, but I can't seem to find anything within the GUI.  

All help is appreciated!
Thanks,
Oqsy

Title: Help with MS Access database
Post by: Rafen on Mon, 15 August 2011, 18:03:00

It would help if you could post exactly what the "replicated flag" says. I think that the only way to gain access to that database again is to have the network administrator adjust your privileges. The whole point of the replication is so that certain data can't be accessed by certain users.

Title: Help with MS Access database
Post by: Rafen on Mon, 15 August 2011, 18:12:27

I don't know how much help i will be since i am still in college but, the whole point of replication is to limit the access of certain data to users and so that you can access it from more than one machine. So i think the only way is to have the network administrator adjust you privileges so that you can access the data.

Title: Help with MS Access database
Post by: Oqsy on Mon, 15 August 2011, 20:39:00

I understand that. The problem is that the replica has no "master" to sync with. Access throws an error and won't let you touch certain files (read only).

Title: Help with MS Access database
Post by: AlleyViper on Mon, 15 August 2011, 21:10:29

I haven't any experience or knowledge with Access. Hope this can elucidate you http://www.extramiledata.com/SnippetsTips/tabid/87/EntryId/22/Remove-replication-from-a-MS-Access-database.aspx . This method still implies the rebuild of another db, but if you tailor that script according to your needs, it might spare a lot of time.
Take special attention if you still require any of Gen_XXX, s_ColLineage, s_Generation, s_GUID, s_Lineage fields, as these are the replication fields omitted by default on it's creation. Please be aware of the possible issues reported on comments, best of luck!

Title: Help with MS Access database
Post by: Oqsy on Mon, 15 August 2011, 21:30:30

Thanks. Thats a great start!