Replication ID as Primary Key

  • Thread starter Thread starter jwm
  • Start date Start date
J

jwm

I'm developing a database which, at some future point, may reside on
several, un-networked, computers. Accordingly, I'm considering using a
replication ID as the primary key for my base table.

However, in testing, I'm having difficulty establishing referential rules
using the replication ID amongst the various tables.

Can anyone point to literature on the subject of using replication IDs as
primary keys, inasmuch as Access Help doesn't seem to offer much insight?

TIA.
 
Oops...my error and red faced about it. I had the field type, set in the
tables employing the replication ID as a foreign key, set to the wrong data
type.
 
jwm said:
I'm developing a database which, at some future point, may reside on
several, un-networked, computers. Accordingly, I'm considering using a
replication ID as the primary key for my base table.

However, in testing, I'm having difficulty establishing referential rules
using the replication ID amongst the various tables.

Can anyone point to literature on the subject of using replication IDs as
primary keys, inasmuch as Access Help doesn't seem to offer much insight?
Click to expand...

Not recommended. See
http://www.trigeminal.com/usenet/usenet011.asp?1033. Michka is well
regarded as one of, if not the, leading expert on Access replication.

But I'd also ask in the replication newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Thanks Tony for the link...certainly gives me something on which to
chew...particularly since the database will be in a foreign location which
is not one of my favorites. :)
 
jwm said:
Thanks Tony for the link...certainly gives me something on which to
chew...particularly since the database will be in a foreign location which
is not one of my favorites. :)
Click to expand...

Hmm, foreign location not one of my favourites? To me that would be
Yellowknife, NWT in January. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Not nearly that nice...this beast will reside in the former Soviet
Union...although the temperatures might be similar at that time of year. :)
 
jwm said:
Not nearly that nice...this beast will reside in the former Soviet
Union...although the temperatures might be similar at that time of year. :)
Click to expand...

Oh dear.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Replication ID data type in VB? 3
Same record/Primary key in multiple tables 0
primary key - concatenated or autonumber? 6
Question re: setting Primary Key 2
problem in accessing fields from table with multiple foreign keys referencing single primary key 1
Relationship with a Primary Key? 4
How can I Manually Change Access Primary Key ID Fields ? 2
Can I change Autonumber from integer to replication ID? 0

Back
Top