access-database-training - Database replicas

Resolved · Low Priority · Version Standard

Database replicas

Dan has attended:
Access Intermediate course

by - delegate Dan [11 posts] (2007 Aug 30 Thu, 08:43) Reply

After creating a replica, it was deleted and now we just have the replica and not the master.

When trying to change the programming in the database I get the message.

'You cannot make changes to the design of the database at this replica'

To counter this I have tried to re-replicate the database to make a new master, and when trying that I get the message

'Cannot replicate MSysAccessObjects in Tables container replicable'

How can I change the format of the database to enable amendments to the program?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Database replicas

by - trainer David gold contributer [428 posts] (2007 Sep 13 Thu, 15:53) Reply

Hi Dan

I have not come across this problem myself, however I suggest that you have a look at the setting when you create the replica. There may be some settings that you need to change in order to create a replica that you can use.

Hope this helps.
David

RE: Database replicas

by - delegate Dan [11 posts] (2007 Sep 19 Wed, 09:45) Reply

I don't understand when you say
' look at the setting when you create the replica. '

there doesn't seem to be any option to set anything?

RE: Database replicas

by - trainer David gold contributer [428 posts] (2007 Sep 19 Wed, 15:36) Reply

Hi Dan

That was just an option I thought may/should have been there. I will look in to this further for you and if I find an answer I will let you know. At this point currently do not have a solution for you.

Good luck, If you find an answer before I do, please post the solution.

Thanks
David

· Why go on a Microsoft Access Training Course?
· Get More Out of MS Access Courses
· Access VBA Training Adds Power to your Databases
· How to Find a Third-Party Venue for Microsoft Access Training
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Rate this page: