Search results
-
M
Export text wizard - "changes not successful"
Thank you both! @Ranman256 - those are useful tips, I shall try and remember for future.... especially the size limit... but in this case the db is 'only' 600Mb but - @JHB you win the prize - the 'compact and repair' worked! (It's always the obvious solution....) I have the database set... -
M
Export text wizard - "changes not successful"
Hello all, So, this one's got me very confused... I'm using the Export Text Wizard to output a query to a text file. All the other (similar-ish) exports work fine, but on this particular one I get the error message: Export Text Wizard The changes you requested to the table were not... -
M
Change Primary key and update data?
Um... so I have an idea, created by Pete, with Joe and Dave responsible for implementing it. I currently have tblPeople, where Pete = 1, Joe = 2, and Dave = 3 (Name = PersonID) I would therefore have, in tblIdeasBank, for this idea, PersonID_Originator = 1 (i.e. Pete), PersonID_Resp1 = 2... -
M
Change Primary key and update data?
Thanks guys for your help... I hadn't thought about update queries (mainly because I have not done much sql). And, therefore, I'm not very good at it! I understand the theory, but am having difficulty getting the correct syntax to work. I have: tblPeople.InitialLastName: J Bloggs, A Nother... -
M
Change Primary key and update data?
Hello, Firstly, I am very much self-taught on access, so there are several gaping holes in my knowledge, and my database structure is probably not wonderful! I have been learning as I go along, so in the initial stages I have built in several problems which I am now discovering! My db is...