General :: Replica Set Lost Key Field?
Aug 21, 2013
Using access 2003 my replica set tables in both the master and replicas seems to have lost the key field! The data and field itself are simply missing from every table. When I look at the data in the tables the key field called 'UID' is not visible but I can still see it in the relationships view and in certain forms and queries. If I try to re join any of the two tables the UID field comes up as an option to join the two with but it's still not visible in any of the tables.
View Replies
ADVERTISEMENT
Jul 9, 2013
I searched this forum just for "treeview" and on the 2nd or 3rd page I found a post with a link for some lessons on treeview. Part 1 was to make a treeview with the word Hello. Part 2 was for another lesson on treeview.Tried to find that link again and for the life of my I'm unable to find it.
View 3 Replies
View Related
Jun 3, 2013
I'm getting an import error that records are being 3 records being deleted and one lost due to violations. However when I go back to check the data that was imported I can't find anything missing. Any clues on what could cause the error but still import the data.
View 1 Replies
View Related
Aug 8, 2015
I have a form frmMember, it has a search button that performs a complex search of fields. after performing my search my [BaseDues] field shows #Name? BaseDues is set by a CBO in the field above.
It works correctly except after the search...
Here is the Code for the Search Button:
Private Sub cmdSearchForm_Click()
On Error GoTo Err_cmdSearchForm_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmSearch"
[Code] .....
View 9 Replies
View Related
Feb 29, 2008
morning
i am adding a new row to an adodb.recordset, one of the fields being a Memo datatype.
all the other fields will write to the database fine, but with the memo, it will mysteriously disappear when i call rs.update
response.write(rs("my_memo_field")) 'give correct output
rs.update
response.write(rs("my_memo_field")) 'gives nothing!
any one else had this happen and have a solution?
cheers
View 2 Replies
View Related
Oct 7, 2013
I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as Parameters instead (Forms!Data!txtInspDate), etc! The new form loads, but of course it is blank with no data. This happens if I load it from a command button or from the navigation sidebar... UNLESS I first load the switchboard in Design Mode, go to VBA window, then reload the Switchboard in Form Mode and press the button. From then on until I close the database, everything works fine!
View 9 Replies
View Related
Jan 14, 2006
Hi All,
With the help of many people on this forum, my database is coming along well (Thank you!). My DB will end up on a server where it will be accessed. My question is; should I use the replica function, or back up the file every day or so.
The database I am replacing has been a replica and it always looses data. I am not sure it is because its a replica or not.
Any thoughts?
Bones
View 8 Replies
View Related
Jul 21, 2005
I am still new to Access and am loving the learning process. I am stuck on a problem though. I have serached the forums here and various other places and haven't found the info I am looking for. I was wondering if there is a way to have a relpica (or a seperate database that can syncronize) that has a modied design. I want the main one to have everything on it, reports/forms/ add/delete/ect, but I want another one that is simply a data entry form, with only the option to input data. I would love to do this and avoid system security measures with usernames and passwords. From my reading it doesn't seem like I can do this, but I still hold in my heart a glimmer of hope. Please help, and if you can explain the process to me, all the better (its how I'm learning).
View 1 Replies
View Related
Feb 4, 2008
Hi
Am using a replica set in order to distribute a school reporting system around teaching staff.
Everything works fine apart from one thing. A marking system (basically 1 to 6 list) is stored in a linked table. Before replication this appears in the correct order. Once the database has been replicated however the list is placed in a random order and I cannot rectify this.
With only 6 items this is not much of a problem but I also want to use a much longer list and the same problem appears.
Can anyone explain why this happens and if there is a simple way to get around it?
Am really only an Access novice and I really appreciate any help that you could give me.
Cheers
Mike
View 9 Replies
View Related
Apr 21, 2006
I know how to setup a Replica's Priority, but where do I go if I want to change it afterwards? I have searched everywhere, or am I just supposed to create another replica and set it then?
View 2 Replies
View Related
Mar 14, 2008
I need the same database as managed and unmanaged in repl manager, I think.
My replica set got scrwd up and now I need to re add an unmanaged replica.
Previously the map displayed a scheduled synchronization line to the replica not managed by synchronizer.
I can add the unmanaged replica, but how do I add the synchronization line?
Do I need the same replica added to the map 2x? 1 managed and the other unmanaged?
i tried uploading 2 bmp files to show the way it was and is now but i dont see them, how do u add bmps to post?
View 1 Replies
View Related
Aug 4, 2005
Love this forum! It orginally helped me build a database to manage customers back in 2002 (using Access 2002). Becuase of our slow server, I was forced to spilt the database and it's been great for years (some glitches). Recently one of the users upgraded to Access 2003. When he sync's to the master file, the master has problems. "...contains a missing or broken reference to the file 'OWC10.DLL' version 1.1" I reviewed the references and it's looking for Microsoft Outlook 11, instead of 10. When other users sync, everyone now inherits this problem. Do you have any ideas for a solution so I don't have to fix reference problems? All users will eventually be on Access 2003 so having him stop using it would only be a temporary solution. Is there a patch or upgrade to fix this problem? Any help? thanks in advance....
View 1 Replies
View Related
Nov 28, 2005
I currently have a database thats A Replica which I need to Convert Back to a Normal Data file, Is there a simple way of doing this other than creating a new db with tables then using Querys to add the data from the replica.
I'm using 2002 and the replica if sized around 470Mb with over 200 Tables.
also does anybody know if the file size for assess 2002 was incresed from access 2000's 2Gb.
thanks
mick
View 2 Replies
View Related
May 2, 2008
I am getting this error on a access 97 database that we have been using for years. the message just started popping. use are still able to access the database, yet this message will not got away.
this member of the replica set has expired because it hasn't been syncronized with another m ember of the replica set.
View 3 Replies
View Related
Apr 14, 2007
I recently was asked to update a client's BE & FE database.
It seems the client only has a replicated version of the database. I don't have the original Design Master.
Problems with negative autonumbers (it seems are due to replication), made me want to remove all need for replication from the database sets.
I attempted to modify some of the Tables in the BE and keep receiving the same error when I try to save it:
ERROR: "You cannot make changes to the design of the database at this replica"
I haven't found a solution on the forum yet. Any ideas?
I found the Replication part of this Microsoft KB article somewhat helpful: http://support.microsoft.com/kb/275561/en-us
View 6 Replies
View Related
May 15, 2006
Hello I have a perplexing problem …
I have been using replication successfully for years. Recently the PC where my Design Master resided crashed taking the hard drive with it. No problems I thought, I used a replica to recover the design master and placed it on the new hard drive (the OS and Access was upgraded from 2000 to XP, however the Access 2000 file format was retained – there are still a couple of laptops with only W2000 software). I understand that moving the path of replicas or design masters is no no, so I proceeded to start from scratch and create a complete new batch of replicas based from the new design master.
Everything was going to plan UNTIL a replica was routinely synchronized with the design master. The design master reverted back to a replica. I recovered the design master again, everything looking fine until again a synchronization causes the design master revert to replica.
Next plan of attack to hopefully fix a potential corruption problem: create a new blank database, import all (non-system) tables, compact and repair, and create a new replica from scratch. From the design master, I created the complementing replicas and sure enough the Design Master again reverted to a Replica after a routine synchronization.
I repeated this “start from scratch” procedure, and the same results prevailed. I am at a loss especially since I verified that the hidden system MSysReplicas table had only two entries after the Design Master and Replica were first created.
I would greatly appreciate any ideas of where to go next with this problem.
Thanking you for your time.
View 1 Replies
View Related
Sep 11, 2014
I have a replica at work, 1 copy on the network, 1 local.. I need to add a column to the main table, getting "Operation is not supported for this type of object".... I have users that use the database but was given a change to the form/report which requires a column addition. What is the simplest way to get around this??? I'm trying not to get into major problems.
View 1 Replies
View Related
Jun 21, 2007
i have just had a problem
if i try to edit an open form by clicking the design icon, i get a message
cant find the call back function or macro "fdesign". ican still close the form and open it from the dbs window
this is affecting accessXP and access20003, but not A97
ive tried repairing/reinstalling the XP installation (but not the 2003 yet), but this has not fixed it.
Any thoughts?
View 5 Replies
View Related
May 23, 2007
I have a table and it has:
namefield
surnamefield
state1
state2
state3
match(Y or No)
importDate
I would like to make a query+ report so that in the report it looks like this:
<<Name>> <<Surname>>
<<state1>> <match>
<<state2>> <match>
<<state3>> <match>
in one line, at the moment I made a query and the name shows 3 times...
can anyone here give me some hints how to show the name once + the match. Thanks in advance
Cheers...
View 2 Replies
View Related
Sep 26, 2007
I am new to using MS Access and am already frustrated that a simple task is getting the better of me.
My situation is that I work for a company that has a number of reps, which are allocated their own ticket books(block). Each book is 50 tickets in size i.e say from number 320500 to 320549. All tickets are entered through our internal system for whatever the ticket was used for.
Now here is my problem. Each block is registered to an individual rep which we need to keep record of as to which tickets are allocated to them, other then having to enter each ticket individually into our ticket block records system, I am trying to make a database entry that accepts the reps name, ticket block start number and then automatically adds the next 50 tickets to that rep, so when we use a search field on any ticket it displays the rep that the ticket was allocated too.
In my head i'm looking for the MS Access way of doing the following:
[tickblockstart]+1 until [ticketblockstart] = [ticketblockstart]+50
Can anyone help me with this probably very easy problem, that i can not seem to grasp at the present time.
Regards
2rsGarry
View 2 Replies
View Related
Nov 16, 2005
hiya, im trying to create a button my form that will move all 'finished' records from where they presently are, to another table.
the button does work, it moves the records into the 'new' table, however it does not DELETE them from the table i moved them from, so now the records are stored in two tables??
the code i have is as follows:
SELECT * INTO Table2
FROM Table1
WHERE Finished='Yes';
if there is something different that i should be doing, or a better way to do this move, please let me know.
(also if this is in the wrong section feel free to move it)
thanks!
View 5 Replies
View Related
Nov 2, 2006
:confused: Fingers crossed I'll get some direction to resolve an issue that I can't even begin to imagine how to search for.My database is used to record detailed work done with clients who are receiving regular support. I'm designing it around a Common Assessment Support Framework that I have no choice but to follow, except for some minor points. There is the potential for approximately 40 different assessments for each client and therefore a lot of duplication in personal details.So far this forum has been a great help and I have learned a lot from those who volunteer their time to those of us who need it from time to time.Following the numerous examples of normalisation posts I have attempted to ensure there is no duplication of information across tables. I've come to a point however where I am stuck:The end result of what I am trying to do is create an individual report called Needs Assessment Planning Tool - rptNAPT.The report will be populated from the fields in qryNAPT that is made up from tblIA1 and tblIA2tblIA1 consists of 17 x 'area of need' that is broken down in to 5 elements: 'Now - Y/N', 'Later - Y/N', 'User Level - Number', 'Worker Level - Number' and 'Disagreement - Memo'. These fields are entered by using frmIA1, and these fields are entered by using frmIA2.So, now I have to enter data in to another form; frmNAPT that includes both theseand thesefields. I only need to show the area of need where Now is True in the form and the subsequent report; rptNAPT.My thoughts about this are (please don't laugh) in the form frmNAPT the 'Area of Need' because in the table there are 17 different areas e.g. Accommodation (improvement), Homelessness, DomesticViolence etc will need to be unbound and in some way filtered to show only those area of need where fldNow is True? and fldUserLevel is NotNull or doesn't equal zero. I will need a minimum of five such fields to show the Areas of Need that the Client and Worker may elect to work on.Sorry for the long post but I'd really appreciate some direction on this, even if it is only to point me in the direction of a link that can be helpful.RegardsDoug
View 5 Replies
View Related
Jun 22, 2005
I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same accounts in my new PC as in the old one but I don't remember the username or password that I was using back then. Any Ideas???
View 4 Replies
View Related
Jul 13, 2005
We have lost an MDB file. Is there a log file where command calls to Access are stored so we can try and recreate the database?
View 1 Replies
View Related
Jan 19, 2006
My database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report?
Thanks!
Gunner...:confused:
View 2 Replies
View Related
Apr 24, 2006
Greetings,
I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.
How do I restore it?
~rbinder
View 2 Replies
View Related