Can't change or add something to an ADP ?

[Rob Hofkens]

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.

 

[aaron.kempf]

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

 

[Rob Hofkens]

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.

 

[Rob Hofkens]

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.

 

[Sylvain Lafontaine]

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.

 

[Rob Hofkens]

Thank you for the info.
I hope I won't get more of these weird problems.

Rob.

 

[aaron.kempf]

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