Connecting MS Access Client to SQL Server 2k via Internet

Connecting MS Access Client to SQL Server 2k via Internet

Post by Marti » Fri, 18 May 2001 23:25:24

I have built a client in MS Access 2000 (an Access project .adp-file) that I use
to access an SQL Server 2000 database. Works perfectly!

Now I want to place the database on a co-located server and access it over the
internet. In Enterprise Manager it works out great! In my MS Access client
reading data works, but I can't edit any data!




1. Connecting to MS SQL Server 6.5 via MS Access 97 and ODBC


to describe the environment briefly, we have MS Access 97 (Service Release 2)
which accesses the MS SQL Server 6.5 (Service Pack 5). Both, Server and Client
are installed on a Windows NT Workstation 4.0 (Service Pack 6). The computer is a
Pentium II 450Mhz CPU with 96Mb RAM.

The SQL ODBC driver was tested in an old as well as the current version.

Any assignments by program code (VBA) which expect an answer of the SQL server,
such as a .OpenRecordset or similar fail.
It seems as if the SQL server wouldn't follow with sending the data.
If one passes through these calls in the debugger mode, then these usually work
straight off. One experiences the same effect, if one after a call is failed in
the code, passes through it directly in the debugger mode once more.

If one changes the environment so that one evacuates the SQL server on a Windows
NT Server, then the same application works without Problems.

Can you help me?

Thanks in advance,

Sven Worm

2. create a standby db on the same host (IPC)

3. Newbie connecting to MS SQL Server using MS Access as client

4. indexes and how they work...

5. Connect MS SQL Server vai Internet using TCP/IP in the client side

6. DINHEIRO Já $$$$$$$$$$$$$$$$$$$

7. No Current Record

8. MS-Access as front-end for remote (via internet) SQL-Server backend

9. Help! Accessing remote MS SQL Server via Internet

10. Connect MS Word To SQL 2K via ODBC

11. Access 2K to SQL 2K client/server sync

12. Connecting Access 2k to sql server 2k