Are all Access 2000 clients on at least Service Pack 1 ?
There are some issues with ADP and SQL 2000
Microsoft Access 2000 requires the installation of either Microsoft Office
2000 Service Release 1 (SR1) or Access 2000 SR1 to operate correctly with
SQL Server 2000. If running an earlier version of Access 2000, you cannot
test automatic data processing (ADP) applications against SQL Server 2000.
You cannot access database diagrams, stored procedures, table designs, or
Other issues to be addressed in a future Access Service Release:
When you run Access 2000 with SR1, you can test ADP applications. You can
also alter database diagrams, stored procedures, table designs, or view
designs, but you cannot save any changes. A future Access Service Release
will allow limited ability to save changes.
The Access 2000 Create Database Wizard cannot successfully create a SQL
Server 2000 database. You can work around this by first creating the
database using SQL Server Enterprise Manager, and then creating an ADP for
the database using the Project (Existing Database) option on the New dialog
box in Access 2000.
The Access 2000 Upsizing Wizard does not support upsizing to SQL Server
2000. You can work around this by using Data Transformation Services in the
Enterprise Manager to import your MDB database file into SQL Server. You can
then rename your MDB tables and create linked tables to the resulting SQL
Server database with the same names as your original MDB table names.
> I am having a problem creating views using an access 2000
> ADP and SQL 2000, on some systems I can create the view
> but only get a choice of all colums, and on others I get a
> permision denied. I am using the same SQL login and the
> user id has DBO rights. Any one know whats going on?
> Found a referance but it requires a membership to view.
> Thank you for your time
> -Craig W.