Search results

I am importing reports from 1 database to another. Everytime I run the import wizard I keep getting a error message that says "Record (s) can't be read; no read permission on MSysModules'." Can any one tell me how to fix this problem? Steve :)

Sorry, not being more specific. What else would you need to know to better understand what I'm asking? I created a form that feed table 1. On this same form I want it now to write to a NEW table without changing any of the fields. I will be adding the NEW fields that are needed to write to...

Can anyone tell if you can link to tables together without having to write a SQL statment, without using a wizard? The reason I'm not using a wizard is because I already have the form created. Steve

Pat, I wanted to let you know I found a way to make it work. In table 2 I had a autonumber as the PK, I took the PK for all together. Now there's no PK in table. When I change the data in table 1 it doesn't delete it from table 2 now. Thank you for your help. Steve:cool:

Pat, I just tried what you said to, It still is not letting change the information in table 2 with out losing information. Do you have anything else for me to try? Steve

Pat, Thanks for getting back to me. Let me give you more info on the tables that I am working with. Table 1 Holds: unique info for people like names, address, and DOB. Each person is assigned a unique number (almost like a SSN) which is the PK. This unique numbers up date when they move to...

Pat, Thank you for your respones. The second table that I am building the relationship, I am not using a PK. The PK is a autonumber in the second table. the relationship type is "one to many". Do you have any thing us that I can look at that mite help me? Steve

I am tring to build a relationship that will update other tables. When I update the primary key in the main table it does not update the same data in a secondary table. I have tryed to set the enforcing integrity, however the block is disabled?? How do I enable this box?:confused: