Access 2002 adp project with sql server 2000

Access 2002 adp project with sql server 2000

Post by Vladim » Sat, 15 Jun 2002 00:59:19



Hi everyone.
I recently updated my notebook to Access 2002, since i wanted to
evaluate Access new capabilities with ADP projects. Now, if I try to
connect to a SQL database on a server ( with Win 2000 server ), i can
establish a connection, through the wizard, which seems to be correct.
In fact i can see and alter the tables structure, or build a form
based on a table, and can edit the data. But, if i try to open a table
i get the hourglass running, until i press ctrl alt canc and stop the
application ( table not responding ). Access hangs and i have to stop
it. On the same database, with access 2k, i am not having the same
problem.I am using win 2k professional sp2 and office xp professional
sp1.
Anyone has experienced the same problem?
Thanks in advance....
 
 
 

1. SQL Server 2000 and Access 2002 ADP Project in NT 4.0

We are evaluating the possibility of upsizing an Access mdb to an
Access 2002 adp project on SQL Server 2000. As our current platform is
Windows NT 4.0 SP 6, we are really concerned of this very quote that
I've found on the online docs of Access 2002.

/begin quote

Supported Microsoft SQL Server databases:
You can connect to one of the following SQL Server databases:

Microsoft SQL Server 2000 on Microsoft Windows 2000 and Microsoft
Windows 98 or later

Microsoft SQL Server 2000 Desktop Engine on Windows 2000 and Windows
98 or later

Microsoft SQL Server 7.0 on Microsoft Windows NT 4.0 or later (with
Microsoft Windows NT Service Pack 4 or later) and Microsoft Windows 95
or later)

Microsoft Data Engine (MSDE) on Windows NT 4.0 or later and Windows 95
or later

Microsoft SQL Server 6.5 on Windows NT 4.0 or later (with SQL Server
Service
Pack 5 or later)

end quote/

I tested an upsizing made on SQL Server 2000 Personal Edition and all
seems to work properly even in NT 4.0.

Any clarification, especially form MS guys, will be very appreciated.

Thanks in advance.

Ciao,
Imerio

2. RealityX .. problems killing large print jobs

3. Cannot open tables using Access 2002 adp to SQL Server 2000

4. reading/writing COM ports under FPW

5. Access 2002 adp frontend Sql Server 2000 backend (Reports Problem)

6. How to get messages into variable

7. Access 2002 Project with SQL Server 2000

8. ALTER TABLE question

9. Access 2000 adp project reference another A2000 adp project

10. Help: Understanding MDB vs ADP theology - Access 2002/SQL 2000

11. Access 2000 adp project reference another A2000 adp project