« previous next »
Pages:  [1]     Go Down

Author Topic: Help with MS Access database  (Read 2331 times)

0 Members and 1 Guest are viewing this topic.

Offline Oqsy

  • Thread Starter
  • Posts: 861
Help with MS Access database
« 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
Logged
[sigpic]Currently in use: Rosewill RK9000 and CH DT225[/sigpic]
"Private misfortunes make for public welfare."

Offline Rafen

  • Posts: 491
  • Location: NA
Help with MS Access database
« Reply #1 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.
« Last Edit: Mon, 15 August 2011, 18:08:34 by Rafen »
Logged

Offline Rafen

  • Posts: 491
  • Location: NA
Help with MS Access database
« Reply #2 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.
Logged

Offline Oqsy

  • Thread Starter
  • Posts: 861
Help with MS Access database
« Reply #3 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).
Logged
[sigpic]Currently in use: Rosewill RK9000 and CH DT225[/sigpic]
"Private misfortunes make for public welfare."

Offline AlleyViper

  • Posts: 101
Help with MS Access database
« Reply #4 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!
« Last Edit: Mon, 15 August 2011, 21:21:57 by AlleyViper »
Logged

Offline Oqsy

  • Thread Starter
  • Posts: 861
Help with MS Access database
« Reply #5 on: Mon, 15 August 2011, 21:30:30 »
Thanks. Thats a great start!
Logged
[sigpic]Currently in use: Rosewill RK9000 and CH DT225[/sigpic]
"Private misfortunes make for public welfare."
Pages:  [1]     Go Up
« previous next »