Connect to multiple databases

[Techwarrior]

I have a database stored on a server that contains a list of clients. About once a week I need to update that list with new clients. Instead of entering each one individually I would like to speed up this process by importing the new clients from a database stored locally to the one on the server. Is there any way to connect to both databases at the same time?

 

[DotNetGnat]

what kind of databases are these? SQL Server or MS Access Database??

-DNG

 

[Techwarrior]

MS Access

-Tech

 

[theniteowl]

Without using ASP code you could just link to the tables of the remote Access database from within your local version and write an update query to send over any new information.
No need to go through a web server for what you could do directly in Access.



It's hard to think outside the box when I'm trapped in a cubicle.