This is what I need done. I have a computer (Windows XP Home) that has a database that is pretty big in size... I need certain recordsets (from diffrent tables) to be on my web server. I thought of a couple of options.
    1. Just upload the whole database to the server everytime I would have to update the database, but it takes about 10 minutes to actually upload it, so I was hoping there would be a better way of doing it.
    2. Use the Select Into statement, so I only have to upload what I really nead, and I am going to guess it will more then cut the upload time in half. And what would work perfectly. It would just add the recordsets that it need to, too diffrent tables within a database online already.
So then I ran into another problem.... I don't know how to open a database that is located on my computer (not on my web server, that is not in my state).. SO if anyone could help me with any of my problems that would be great!!!!

Thanks, Grant

Grant,

1. Can't you update the remote box also when you are inserting/updating/deleting your local db? Just a thought ... you know it better as you know the complete business logic :)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

oops i have clicked submit reply by mistake :(

2. You might want to use DTS (Data transformation services)!

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com