...is limiting me to read only.
Hello everyone,
I am only a humble user and notice that you’re all programmers, coders and tech support so I apologise for the limits in my technical vocabulary. However I’m really at sea at this point because the folks on my company helpdesk are not familiar with SQL / Access overlap queries. They suggested looking on the web so here I am. I'll give you the background first...
It all started earlier this year, when I was becoming quite good at using "normal" MS Access 2000. But there came a point when the size of data I needed to manipulate necessitated some extra capacity. So a developer friend called Giles in another part of the bank kindly gave me a spare SQL licence and software package and fixed me up so I could use my PC box as a server and effectively super-size my MS Access 2000 tables, queries and processing speed.
He was a jolly nice chap and used to come over and help every now and then when my inability exceeded the demands of the software. The PC liked this. As long as I brought Giles every now and then it would tolerate me. However, the plot thickens. Giles was obviously such a skilled developer and nice chap that this must have made a significant contribution to his success at interview in landing a great new job elsewhere getting loads more money. Apart from being sorry to see him go I also feared that my delicate partnership with SQL and MS Access would deteriorate rapidly once the software buddies smelt my fear at the prospect of no Giles to help out when they got upset. All was going swimmingly until yesterday. I was trying to transfer the results of a large query to a shared network drive from my PC. I tried “exporting” which didn’t work so thought I could just clipboard it into another Network supported MS Access table via pasting into a .txt file. I knew they would get upset because they explicitly told me that any more than 65000 lines of data would result in a downing of tools until Giles came back to calm them down. Stupidly I went ahead with 135000 lines of data. Oh dear oh dear oh dear. That was it. Dead. Nothing. Nada.
And I could almost hear them saying "We told you so."
Because my clipboard “copy” exceeded the clipboard capacity of 65,000 lines of data it started to hang. So after a while I did an “end task” on the task manager and shut down and restarted. When I tried to go back in, through my network stored .adp file that effectively uses data stored on my PC box installed SQL server, all I got was a message saying I could “read only”. However all was not lost: the good news was that I could run existing queries and look at data within tables. The problem came when I tried to create new queries or import new tables. It (or they) wouldn’t let me. I figured this was because it was read only. I am the only user so I assume that somewhere in the background it (or they) thinks I’m still trying to do my paste from yesterday. So I called the help desk who couldn’t help. They suggested the web so to the web I have come. And then I found you guys and read some of the comments on this site. I noted with glee that one chap had an almost similar problem which suggested copying the .adp file and pretending that I’m another user so I can go in and do what I like. I thought this was great as the MS Access SQL buddies might show pity on the “other” user while the “original/yesterday” me was still receiving the cold shoulder. So I did a copy paste on the network drive where the .adp is stored and tried to go in through “copy of database.adp”.
Boy was I wrong. Clearly insulted by my pathetic attempt to masquerade as another user the buddies have escalated this to another level. So now we get to the first part of my subject line. Not only does it now announce that it is read only but it now appears to have disconnected me from the source tables, views and other data. Both in the copy AND the original. Previously it felt like I was on parole and restricted to visiting rights for my initial “crime” of exceeding the clipboard limit. Now it feels like I’ve breached those terms so they’ve now denied me even view only rights.
So in summary, my relationship with MS Access 2000 was once quite healthy, but since it found a new friend in SQL and Giles the developer has gone I am left in bit of a pickle. Any suggestions as to how I can connect my .adp back into the local SQL stored data or how I get over the whole read only/visitor rights thing would be great.
Best regards to one and all, hattonjc
Hello everyone,
I am only a humble user and notice that you’re all programmers, coders and tech support so I apologise for the limits in my technical vocabulary. However I’m really at sea at this point because the folks on my company helpdesk are not familiar with SQL / Access overlap queries. They suggested looking on the web so here I am. I'll give you the background first...
It all started earlier this year, when I was becoming quite good at using "normal" MS Access 2000. But there came a point when the size of data I needed to manipulate necessitated some extra capacity. So a developer friend called Giles in another part of the bank kindly gave me a spare SQL licence and software package and fixed me up so I could use my PC box as a server and effectively super-size my MS Access 2000 tables, queries and processing speed.
He was a jolly nice chap and used to come over and help every now and then when my inability exceeded the demands of the software. The PC liked this. As long as I brought Giles every now and then it would tolerate me. However, the plot thickens. Giles was obviously such a skilled developer and nice chap that this must have made a significant contribution to his success at interview in landing a great new job elsewhere getting loads more money. Apart from being sorry to see him go I also feared that my delicate partnership with SQL and MS Access would deteriorate rapidly once the software buddies smelt my fear at the prospect of no Giles to help out when they got upset. All was going swimmingly until yesterday. I was trying to transfer the results of a large query to a shared network drive from my PC. I tried “exporting” which didn’t work so thought I could just clipboard it into another Network supported MS Access table via pasting into a .txt file. I knew they would get upset because they explicitly told me that any more than 65000 lines of data would result in a downing of tools until Giles came back to calm them down. Stupidly I went ahead with 135000 lines of data. Oh dear oh dear oh dear. That was it. Dead. Nothing. Nada.
And I could almost hear them saying "We told you so."
Because my clipboard “copy” exceeded the clipboard capacity of 65,000 lines of data it started to hang. So after a while I did an “end task” on the task manager and shut down and restarted. When I tried to go back in, through my network stored .adp file that effectively uses data stored on my PC box installed SQL server, all I got was a message saying I could “read only”. However all was not lost: the good news was that I could run existing queries and look at data within tables. The problem came when I tried to create new queries or import new tables. It (or they) wouldn’t let me. I figured this was because it was read only. I am the only user so I assume that somewhere in the background it (or they) thinks I’m still trying to do my paste from yesterday. So I called the help desk who couldn’t help. They suggested the web so to the web I have come. And then I found you guys and read some of the comments on this site. I noted with glee that one chap had an almost similar problem which suggested copying the .adp file and pretending that I’m another user so I can go in and do what I like. I thought this was great as the MS Access SQL buddies might show pity on the “other” user while the “original/yesterday” me was still receiving the cold shoulder. So I did a copy paste on the network drive where the .adp is stored and tried to go in through “copy of database.adp”.
Boy was I wrong. Clearly insulted by my pathetic attempt to masquerade as another user the buddies have escalated this to another level. So now we get to the first part of my subject line. Not only does it now announce that it is read only but it now appears to have disconnected me from the source tables, views and other data. Both in the copy AND the original. Previously it felt like I was on parole and restricted to visiting rights for my initial “crime” of exceeding the clipboard limit. Now it feels like I’ve breached those terms so they’ve now denied me even view only rights.
So in summary, my relationship with MS Access 2000 was once quite healthy, but since it found a new friend in SQL and Giles the developer has gone I am left in bit of a pickle. Any suggestions as to how I can connect my .adp back into the local SQL stored data or how I get over the whole read only/visitor rights thing would be great.
Best regards to one and all, hattonjc