Can't change or add something to an ADP ? "Rob Hofkens" <robhofkens[ at ]xs4all.nl> 04.03.2006 08:01:09 Hello everyone , First time for me to use Access with SQL server and got problems starting. I am trying to use Access 2000 on a client with SQL Server 2000 on a server. For testing I created a Test database on the SQL Server and set the right permissions with Windows Authentication. Next I started Access 2000 on a Win XP client and made a new Project with an excisting database. I gave it a name and saved the project to a local folder on the client. After this I got the connection window and I selected the SQL server, set Windows Authentication and selected the Test database. Then I tested the connection wich turned out ok! After pressing Ok I find myself looking at the database , ready for usage. BUT evertime I want to create something I get this error: You don't have exclusive access to the database. Changes won't be saved. (translated from Dutch). I found an option to open the project exclusive but that doesn't change anything. Some help would be appreciated. Thanx in advance. Rob.

Re: Can't change or add something to an ADP ? "aaron.kempf[ at ]gmail.com" <aaron.kempf[ at ]gmail.com> 04.03.2006 17:40:00 are you a local admin on the machine? by default you would have permissions. do you have office service packs? i reccomend anything other than Access 2000; i mean some idiot in redmond decided to make Access 2000 and SQL 2000 not compatable. -Aaron

Re: Can't change or add something to an ADP ? "Rob Hofkens" <robhofkens[ at ]xs4all.nl> 05.03.2006 21:11:21 Hi Aaron ! Thanx for answering my question :) I have local admin rights but don't have any office packs installed. I am shocked to hear that the regular Access 2000 and SQL 2000 ain't compatible :( I could try Access 2003 since I have one copy available. Or is installing the office 2000 service pack(s) sufficiant ? Rob. <aaron.kempf[ at ]gmail.com> schreef in bericht news:1141494000.312056.210000[ at ]z34g2000cwc.googlegroups.com... [Quoted Text] > are you a local admin on the machine? by default you would have > permissions. > > do you have office service packs? > > i reccomend anything other than Access 2000; i mean some idiot in > redmond decided to make Access 2000 and SQL 2000 not compatable. > > -Aaron >

Re: Can't change or add something to an ADP ? "Rob Hofkens" <rob[ at ]marmerindustrie.nl> 06.03.2006 08:04:01 First thing I did this morning was installing SP3 for MS Office 2000. And the problem is solved..yay. But I got a warning message that not all functions are supported in Access 2000 with SQL 2000. So maybe Access 2003 is better in that respect ? Thank you very much ! Rob. "Rob Hofkens" <robhofkens[ at ]xs4all.nl> schreef in bericht news:440b53fd$0$11079$e4fe514c[ at ]news.xs4all.nl... [Quoted Text] > Hi Aaron ! > > Thanx for answering my question :) > I have local admin rights but don't have any office packs installed. > I am shocked to hear that the regular Access 2000 and SQL 2000 ain't > compatible :( > I could try Access 2003 since I have one copy available. > Or is installing the office 2000 service pack(s) sufficiant ? > > Rob. > > <aaron.kempf[ at ]gmail.com> schreef in bericht > news:1141494000.312056.210000[ at ]z34g2000cwc.googlegroups.com... >> are you a local admin on the machine? by default you would have >> permissions. >> >> do you have office service packs? >> >> i reccomend anything other than Access 2000; i mean some idiot in >> redmond decided to make Access 2000 and SQL 2000 not compatable. >> >> -Aaron >> > >

Re: Can't change or add something to an ADP ? "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 06.03.2006 17:08:07 There is a lot of bugs that have been corrected between the ADP 2000 and the 2002 version and a few bugs between 2002 and 2003. There is still a number of bugs that remains in the A2003 version; however, if you are serious about ADP, you should definitely forget about A2000 and probably about A2002, too. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Rob Hofkens" <rob[ at ]marmerindustrie.nl> wrote in message news:440bed05$0$11067$e4fe514c[ at ]news.xs4all.nl... [Quoted Text] > First thing I did this morning was installing SP3 for MS Office 2000. > And the problem is solved..yay. > But I got a warning message that not all functions are supported in Access > 2000 with SQL 2000. > So maybe Access 2003 is better in that respect ? > > Thank you very much ! > > Rob. > > > "Rob Hofkens" <robhofkens[ at ]xs4all.nl> schreef in bericht > news:440b53fd$0$11079$e4fe514c[ at ]news.xs4all.nl... >> Hi Aaron ! >> >> Thanx for answering my question :) >> I have local admin rights but don't have any office packs installed. >> I am shocked to hear that the regular Access 2000 and SQL 2000 ain't >> compatible :( >> I could try Access 2003 since I have one copy available. >> Or is installing the office 2000 service pack(s) sufficiant ? >> >> Rob. >> >> <aaron.kempf[ at ]gmail.com> schreef in bericht >> news:1141494000.312056.210000[ at ]z34g2000cwc.googlegroups.com... >>> are you a local admin on the machine? by default you would have >>> permissions. >>> >>> do you have office service packs? >>> >>> i reccomend anything other than Access 2000; i mean some idiot in >>> redmond decided to make Access 2000 and SQL 2000 not compatable. >>> >>> -Aaron >>> >> >> > >

Re: Can't change or add something to an ADP ? "Rob Hofkens" <rob[ at ]marmerindustrie.nl> 07.03.2006 16:11:55 Thank you for the info. I hope I won't get more of these weird problems. Rob. "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> schreef in bericht news:%23VNlLCUQGHA.4264[ at ]TK2MSFTNGP11.phx.gbl... [Quoted Text] > There is a lot of bugs that have been corrected between the ADP 2000 and > the 2002 version and a few bugs between 2002 and 2003. > > There is still a number of bugs that remains in the A2003 version; > however, if you are serious about ADP, you should definitely forget about > A2000 and probably about A2002, too. > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > "Rob Hofkens" <rob[ at ]marmerindustrie.nl> wrote in message > news:440bed05$0$11067$e4fe514c[ at ]news.xs4all.nl... >> First thing I did this morning was installing SP3 for MS Office 2000. >> And the problem is solved..yay. >> But I got a warning message that not all functions are supported in >> Access 2000 with SQL 2000. >> So maybe Access 2003 is better in that respect ? >> >> Thank you very much ! >> >> Rob. >> >> >> "Rob Hofkens" <robhofkens[ at ]xs4all.nl> schreef in bericht >> news:440b53fd$0$11079$e4fe514c[ at ]news.xs4all.nl... >>> Hi Aaron ! >>> >>> Thanx for answering my question :) >>> I have local admin rights but don't have any office packs installed. >>> I am shocked to hear that the regular Access 2000 and SQL 2000 ain't >>> compatible :( >>> I could try Access 2003 since I have one copy available. >>> Or is installing the office 2000 service pack(s) sufficiant ? >>> >>> Rob. >>> >>> <aaron.kempf[ at ]gmail.com> schreef in bericht >>> news:1141494000.312056.210000[ at ]z34g2000cwc.googlegroups.com... >>>> are you a local admin on the machine? by default you would have >>>> permissions. >>>> >>>> do you have office service packs? >>>> >>>> i reccomend anything other than Access 2000; i mean some idiot in >>>> redmond decided to make Access 2000 and SQL 2000 not compatable. >>>> >>>> -Aaron >>>> >>> >>> >> >> > >

Re: Can't change or add something to an ADP ? "aaron.kempf[ at ]gmail.com" <aaron.kempf[ at ]gmail.com> 15.03.2006 20:26:35 you really might want to consider using 2003 in development and 2000 for deployment; i can't honestly reccomend that-- but it's got to be an option you're considering. 2002/2003 are QUITE A BIT nicer than 2000; especially for dev. I prefer the table design view in 2000 though. -Aaron