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

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

Post by Wolfgang Bec » Sat, 29 Apr 2000 04:00:00



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

 
 
 

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

Post by User » Sat, 29 Apr 2000 04:00:00


Make a new Access project (Access 2K) choose the existing database option.
When the data link properties come up, choose your server, database,
security options, etc.

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


 
 
 

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

Post by Wolfgang Bec » Mon, 01 May 2000 04:00:00



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

> Make a new Access project (Access 2K) choose the existing database option.
> When the data link properties come up, choose your server, database,
> security options, etc.

> 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