 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Replication / August 2004Why Can't I replicate Tables
I want to replicate some tables in a database. The primary keys are Autonumbers, is this the problem? What IS the problem? Are you already using a replicated database? If not, then you must first Create Replica (under Tools, Replication.) This will convert the database to a design master and create a replica. When the database is converted to a design master, the Autonumber switches from increment to random. (a price to be paid for replication). Is your's the design master? If not, you are not allowed to add replicated tables. You must do that from the design master. If it is your design master, then right click the table, Properties, set Replicable. Beyond this, we need to know more about the problem. Stephen Rasey Houston http://wiserways.com http://excelsig.org You must first > I want to replicate some tables in a database. The > primary keys are Autonumbers, is this the problem? Since I am not the creator of the Database, I can not answer if the database is a replicate. THis I will check with the creator. I noticed the problem when I clicked on properties and the replicate choice was greyed out. THanks for your input jf >-----Original Message----- >What IS the problem? [quoted text clipped - 22 lines] > >. Can you get to the Database Window to see the list of table. If yes, and there is a yellow circular icon next to some of the tables, then you have a replicated database. If there are none, then your database is not replicated. Talk with the designer about whether replication is a good idea. Maybe the best thing is to create your own replicated database with critical replicated tables. Then link your main database to the replicated tables. Stephen Rasey Houston http://wiserways.com http://excelsig.org > Since I am not the creator of the Database, I can not > answer if the database is a replicate. THis I will check [quoted text clipped - 41 lines] > > > >. No there is no replication symbols by the table names or is it titled as a replicate. The database I am working on is a copy of a database that was received because I had to readjust it to fit our needs. I believe it was originally designed in Access 2000 and then converted to Access 97, which I am using. >-----Original Message----- >Can you get to the Database Window to see the list of table. [quoted text clipped - 60 lines] > >. No there isn't circular icons by the tables. This database is a copy of the original database. And also I believe that the database was first created in Access 2000 and then converted to Access 97 for our use. >-----Original Message----- >Can you get to the Database Window to see the list of table. [quoted text clipped - 60 lines] > >. Well, then, You can try to create a design master yourself. Do it on a test copy of the database. From Menu, Tools, Replication..., Create Replica. Replication has some pitfalls, but you can best learn by doing. Stephen > No there isn't circular icons by the tables. This > database is a copy of the original database. And also I [quoted text clipped - 72 lines] > > > >. THanks, I don't why I didn't think of that myself..DUHHH. JF >-----Original Message----- >Well, then, [quoted text clipped - 84 lines] > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.