Error 15135 on upsizing Access to Sql Server "Paul Proefrock" <proefrock[ at ]sbcglobal.net> 15.07.2006 03:05:13 I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs fine when I try it locally to Sql Server Express 2005. When I try to upload it to our remote server, I keep getting a bunch of errors " Server Error 15135: Object is invalid. Extended properties are not permitted on 'dbo.<table>.<field>', or the object does not exist." I googled the error but all I could find was a change in coding to correct it. Since this is a Microsoft Wizard, I can't change any coding. Any ideas on what is causing it, how to correct it? thanks Paul P

Re: Error 15135 on upsizing Access to Sql Server "Gil Lapid Shafriri" <gilsh[ at ]microsoft.com> 15.07.2006 04:23:47 Why don't you try the SQL Server Migration Assistant for Access http://www.microsoft.com/sql/solutions/migration/default.mspx It is in beta now (release at the end of the mounth) but it is working fine. Gil Gil Lapid Shafriri Program Manager SQL Server Migration Assistant Microsoft 425-7054487 "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs >fine when I try it locally to Sql Server Express 2005. > > When I try to upload it to our remote server, I keep getting a bunch of > errors " > Server Error 15135: Object is invalid. Extended properties are not > permitted on 'dbo.<table>.<field>', or the object does not exist." > > > > I googled the error but all I could find was a change in coding to correct > it. Since this is a Microsoft Wizard, I can't change any coding. > > > > Any ideas on what is causing it, how to correct it? > > > > thanks > > > > Paul P > >

Re: Error 15135 on upsizing Access to Sql Server "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 15.07.2006 04:50:33 Hi Paul, do you have enough permissions (should be dbOnwer) for remote database? try to check this -- Best regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs >fine when I try it locally to Sql Server Express 2005. > > When I try to upload it to our remote server, I keep getting a bunch of > errors " > Server Error 15135: Object is invalid. Extended properties are not > permitted on 'dbo.<table>.<field>', or the object does not exist." > > > > I googled the error but all I could find was a change in coding to correct > it. Since this is a Microsoft Wizard, I can't change any coding. > > > > Any ideas on what is causing it, how to correct it? > > > > thanks > > > > Paul P > >

Re: Error 15135 on upsizing Access to Sql Server "Paul Proefrock" <proefrock[ at ]sbcglobal.net> 15.07.2006 13:44:55 Gil Thanks, I'll give it a try. I am currently in a testing mode so it may benefit both of us. Paul P "Gil Lapid Shafriri" <gilsh[ at ]microsoft.com> wrote in message news:uyZo8Z8pGHA.1600[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Why don't you try the SQL Server Migration Assistant for Access > > http://www.microsoft.com/sql/solutions/migration/default.mspx > > It is in beta now (release at the end of the mounth) but it is working > fine. > > Gil > > Gil Lapid Shafriri > Program Manager > SQL Server Migration Assistant > Microsoft > 425-7054487 > > > "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message > news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... >>I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs >>fine when I try it locally to Sql Server Express 2005. >> >> When I try to upload it to our remote server, I keep getting a bunch of >> errors " >> Server Error 15135: Object is invalid. Extended properties are not >> permitted on 'dbo.<table>.<field>', or the object does not exist." >> >> >> >> I googled the error but all I could find was a change in coding to >> correct it. Since this is a Microsoft Wizard, I can't change any coding. >> >> >> >> Any ideas on what is causing it, how to correct it? >> >> >> >> thanks >> >> >> >> Paul P >> >> > >

Re: Error 15135 on upsizing Access to Sql Server "Paul Proefrock" <proefrock[ at ]sbcglobal.net> 15.07.2006 14:32:38 Alex, I am the only user of the database and owner is checked under my user name. The database is on a leased server, I am not the admin of the server, if that makes a difference. Paul P "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message news:OgCQ1o8pGHA.4960[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Hi Paul, > do you have enough permissions (should be dbOnwer) for remote database? > try to check this > > -- > Best regards, > ___________ > Alex Dybenko (MVP) > http://alexdyb.blogspot.com > http://www.PointLtd.com > > "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message > news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... >>I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs >>fine when I try it locally to Sql Server Express 2005. >> >> When I try to upload it to our remote server, I keep getting a bunch of >> errors " >> Server Error 15135: Object is invalid. Extended properties are not >> permitted on 'dbo.<table>.<field>', or the object does not exist." >> >> >> >> I googled the error but all I could find was a change in coding to >> correct it. Since this is a Microsoft Wizard, I can't change any coding. >> >> >> >> Any ideas on what is causing it, how to correct it? >> >> >> >> thanks >> >> >> >> Paul P >> >> >

Re: Error 15135 on upsizing Access to Sql Server "Paul Proefrock" <proefrock[ at ]sbcglobal.net> 15.07.2006 14:36:35 Gil, Just noticed the page for the Access Migration tool calls for 1Gig memory. Is that for the machine it runs on or for the server? Am I going to hit a wall on my laptop with 512? Paul "Gil Lapid Shafriri" <gilsh[ at ]microsoft.com> wrote in message news:uyZo8Z8pGHA.1600[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Why don't you try the SQL Server Migration Assistant for Access > > http://www.microsoft.com/sql/solutions/migration/default.mspx > > It is in beta now (release at the end of the mounth) but it is working > fine. > > Gil > > Gil Lapid Shafriri > Program Manager > SQL Server Migration Assistant > Microsoft > 425-7054487 > > > "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message > news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... >>I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs >>fine when I try it locally to Sql Server Express 2005. >> >> When I try to upload it to our remote server, I keep getting a bunch of >> errors " >> Server Error 15135: Object is invalid. Extended properties are not >> permitted on 'dbo.<table>.<field>', or the object does not exist." >> >> >> >> I googled the error but all I could find was a change in coding to >> correct it. Since this is a Microsoft Wizard, I can't change any coding. >> >> >> >> Any ideas on what is causing it, how to correct it? >> >> >> >> thanks >> >> >> >> Paul P >> >> > >

Re: Error 15135 on upsizing Access to Sql Server "Gil Lapid Shafriri" <gilsh[ at ]microsoft.com> 15.07.2006 21:27:10 Should be OK as well. "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message news:uDh%23ZwBqGHA.524[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Gil, > Just noticed the page for the Access Migration tool calls for 1Gig memory. > Is that for the machine it runs on or for the server? > > Am I going to hit a wall on my laptop with 512? > > Paul > > > "Gil Lapid Shafriri" <gilsh[ at ]microsoft.com> wrote in message > news:uyZo8Z8pGHA.1600[ at ]TK2MSFTNGP04.phx.gbl... >> Why don't you try the SQL Server Migration Assistant for Access >> >> http://www.microsoft.com/sql/solutions/migration/default.mspx >> >> It is in beta now (release at the end of the mounth) but it is working >> fine. >> >> Gil >> >> Gil Lapid Shafriri >> Program Manager >> SQL Server Migration Assistant >> Microsoft >> 425-7054487 >> >> >> "Paul Proefrock" <proefrock[ at ]sbcglobal.net> wrote in message >> news:ev0pEu7pGHA.4988[ at ]TK2MSFTNGP04.phx.gbl... >>>I am trying to upsize an Access DB to Sql Server. The upsizing wizard >>>runs fine when I try it locally to Sql Server Express 2005. >>> >>> When I try to upload it to our remote server, I keep getting a bunch of >>> errors " >>> Server Error 15135: Object is invalid. Extended properties are not >>> permitted on 'dbo.<table>.<field>', or the object does not exist." >>> >>> >>> >>> I googled the error but all I could find was a change in coding to >>> correct it. Since this is a Microsoft Wizard, I can't change any coding. >>> >>> >>> >>> Any ideas on what is causing it, how to correct it? >>> >>> >>> >>> thanks >>> >>> >>> >>> Paul P >>> >>> >> >> > >