Is it possible to have two connections open at one time? I want to take data from one database (SQL Server) and place data into an Access db on my server. Currently, I have the tables from the SQL server as linked tables in my Access db. Should I have two connections? Is what I am tring to do impossible?