Hello,
For some reason Ive been trying to create a search function in my database and a " TmprryQryFrLnkFldsCrtn0123456789 " Query has appeared that I cant alter or change. Does anyone know what this is for or about?
Novice
Windows 7 64bit 
Access 2010 64bit
Hello,
For some reason Ive been trying to create a search function in my database and a " TmprryQryFrLnkFldsCrtn0123456789 " Query has appeared that I cant alter or change. Does anyone know what this is for or about?
Administrator
Windows 7 64bit Access 2013
Have you done a Compact and Repair yet?
Novice
Windows 7 64bit Access 2010 64bit
Thank you for the reply. Yes I have done it but still keeps coming up with this.... If I remove it I cant search or amend things. Yet I cant amend the query either. Its barmy lol.Originally Posted by RuralGuy
Administrator
Windows 7 64bit Access 2013
Try *importing* everything BUT that query and see if the problem follows. Just takes a couple of seconds. http://www.btabdevelopment.com/ts/impnew
Novice
Windows 7 64bit Access 2010 64bit
Just done that and it hasn't imported my Customer Table with the message Could not open the object
Novice
Windows 7 64bit Access 2010 64bit
Just got a reserved error -1524 when trying to import it by itself?
Administrator
Windows 7 64bit Access 2013
Sounds like you have some corruption with that table. I hope you have a backup for that table. Here's a couple of links you might want to review:
http://allenbrowne.com/ser-47.html
http://allenbrowne.com/ser-25.html
Posting Permissions
Reply With Quote