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 |
|
guruchi_20
Starting Member
24 Posts |
 Posted - 2009-02-17 : 02:25:24
|
| hello all, i'm already done with this process, im already connect the microsoft access database to sql database using upsizing wizard,no error on connection (but i saw something different when using this upsizing wizard).this is the link for Upsizing Wizardhttp://technet.microsoft.com/en-us/library/cc917602.aspx when you delete the file on access database it is automatically deleted the sql database also, (same record on access to sql) once you add sql database add also.my question is: Is is possible when you using this wizard when the time you may change or add the access database then sql database not change the last data or do not update or erase the sql database either you may change the access database file. because this is the way when im using to replicate the access database to sql database at a real time update without using the Data Transformation Services (DTS). because when i Used DTS the minimum minute to update your file from Access to SQL is 1 minute only.Please HELP.im appreciate your help.Thanks You Very Much,Joey |
|
|
Sequin
Starting Member
25 Posts |
Posted - 2009-02-17 : 10:47:59
|
| If I understand you correctly you are asking if you change, add or delete data from the Access front end, will it always be changed, added to or deleted from the SQL database immediately? If you used the upsizing wizard, then the answer is yes. The Access database no longer contains the data, but shows the data present in the SQL database - there is no replication or synchronisation - the data is ONLY in the SQL database - the Access front end is just a window showing you the SQL data and allowing you to edit it |
 |
|
|
guruchi_20
Starting Member
24 Posts |
Posted - 2009-02-17 : 19:36:23
|
| thank for the reply Sequin.i appreciate your suggestion. there a way to replicate the access database to sql database in real timeit iether they add the data on access it will add the data to sql immediately. without using the DTSand you delete the access database sql database not deleted the record.im trying to used the upsizing wizard but once i delete the access database the sql database deleted also that's not i want to happen.please help. |
|
|
|
|
|
|
Microsoft® Access 2000 database to a Microsoft SQL