Recent content by chaeljc

Guys (and gals).. As i stagger through my learning of the access replication process could i ask for some related guidance on an issue or two which is confusing me somewhat.... in the usual non replicated scenario where users are permanently connected to the network i use a split database...

Good morning! Hi Dave many thanks for that... it's what i was doing.. using the random nos as pk/fk... but great to have it confirmed by you. many thanks Michael

yeah ... cant really use the large nos as a job ref any more! lol are you saying that you dont even let the system use the large number even as a primary key to link tables in relationships? the replication process has linked up numerous tables automatically inthis way. all seems ok so...

yeah ... cant really use the large nos as a job ref any more! lol are you saying that you dont even let the system use the large number even as a primary key to link tables in relationships? the replication process has linked up numerous tables automatically inthis way. all seems ok so...

hi David i am familar with ado disconnected recordsets and have previously set up databases where the front and back ends connect to each other. with that in mind i was thinking originally of some kind of method similar to what you are are lining using dsn. im trying my best to see if...

hey Dave (of Gemma) thanks for your info. yes it seems tricky to me! lol im looking into the replication side of things as we speak. would still love to hear from any one with experience of such a prob. as i get to a solution ill post up what i find and hopefully it will prove useful to...

hi all i would be most grateful for advice on database design - i think in the area of relication vs splitting a database... but im not entirely sure. If i could give you the scenario. its access 2003. No choice. i am pretty familar with general dB design, splitting databases and vba with...

Re: relationship design diffs - SOLVED hi all just a brief note to let you know that this problem has been solved.... see cross thread note earlier. thanks to all for your assistance. regards michael

hi severin That would be most appreciated ( im in work here stilllll struggling away trying to resolove the prob) if you look back a couple of posts the database has already been uploaded 'Project Database.zip' if you need any further clarification, please don't hesitate to contact me...

hey jdraw many thanks for your advice. cross post link read and understood. :-) the link to the original thread is.... ive tried posting the link to the thread as advised but as my post count is low it wont let me. with that in mind you can find the original post at access forums . net...

hi guys and gals im hoping someone can help me with a problem i am having designing a database. the structure is something like this... At the top are Projects. Stages Projects have (work related) Stages. Each project can have many stages. A master list of stages exists from which...

hi all my name is michael, im 45 and live in n ireland uk. i've been building various access databases for a number of years enhanced here and there with a little vba. i've no formal training and am certainly no expert, but im not a complete beginner. think im happy (ish) enough around...