Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 21:18:42
|
Greg writes "I built an access database which I have upsized to an SQL Server database (the SQL database is housed on a remote server). During the upsizing process copies of all my Access tables were made. All my Access Forms are still tied to these "local" Access tables. I made new Access Forms and tied them to the tables that are linked to the SQL Server database. I have two problems, one I do not yet have access to a high speed internet connection (I'm still only at 56k) so it takes a while for the Forms to show up with the SQL Server data. The second problem is, even if I used the Forms tied to the SQL Server database I still need to somehow update my local Access Tables or vice versa. What I'm trying to do is use the Local Forms to manipulate the Access Database and to perform an UPDATE to the remote SQL Server database on a per record basis. I created UPDATE Querys in Access that will Update the entire table (which at this point is upto 265 records) This still takes awhile. Is there some way I can attach some VB coded SQL statements to an event in my local Access Forms that will UPDATE just the Record or Field that is modified. I hope I don't sound as Green as I am with this stuff. I'm rather new to Databases SQL and ASP. I've only been working with all of this for about 6 months, and everything I've done I've had to learn the hard way except for the help articles I've found on your great site. Any help you can provide will be greatly appreciated.
Greg" |
|
|
|
|
|
UPDATE Using INNER JOIN w\ Local Acesss & Remote SQL Tables