Hi,
does anyone know
how I can connect MS-Access to a remote SQL-Server to manage my
databases there ?
I'd be grateful for a hint where I can find a docu (couldn't find
anything in the standard docus).
Regards
Wolfgang Beck
Regards
Wolfgang Beck
Of course you will have to use TCP/IP client library, and make sure your DNS
is working, take care of firewalls etc.
Documentation should be listed under "Working with Access Projects" or
something like that
Quote:> Hi,
> does anyone know
> how I can connect MS-Access to a remote SQL-Server to manage my
> databases there ?
> I'd be grateful for a hint where I can find a docu (couldn't find
> anything in the standard docus).
> Regards
> Wolfgang Beck
Thanks very much,
seems like I didn't put the IP in the right place at the DNS-config
everything's fine now
Regards
Wolfgang
> Of course you will have to use TCP/IP client library, and make sure your DNS
> is working, take care of firewalls etc.
> Documentation should be listed under "Working with Access Projects" or
> something like that
> > Hi,
> > does anyone know
> > how I can connect MS-Access to a remote SQL-Server to manage my
> > databases there ?
> > I'd be grateful for a hint where I can find a docu (couldn't find
> > anything in the standard docus).
> > Regards
> > Wolfgang Beck
1. Help! Accessing remote MS SQL Server via Internet
I need to write a Delphi 3 program that, via a dialup Internet Does anybody know the best way to do this? Would the TRemote TIA
connection, can access an MS SQL 6.5 database and update data in local
Paradox tables and data in the SQL database.
components in he client/server version help? How about AsyncPro?
John
2. Q:How to store filereferences and access file contents through SQL-server?
3. Access front end Sql Server Backend Problem
5. Access 97 Front End Sql Server 2000 Backend
6. SQL language analyser source
7. Internet Replication of Access Front-End to SQL Server
8. Class TFloatField not found???
9. How Optimizing performance Ms access front-end and sql back-end
10. Exporting Access records to MS Word via VB6 front end app
11. linking MS-Access97 front end to SQL server7.0 backend??ASAP
12. Loadbalancing backend SQL servers from the front end web servers
13. MS Access as SQL server front end.