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 |
|
vmahesh
Starting Member
19 Posts |
 Posted - 2001-12-19 : 09:16:48
|
| Does anybody have idea regarding synchronization between MS Access and SQL Server databases ? I have MS Access database right now. planning to create SQL Server database and establish synchronization between them. can anyone give me any suggestions & help in this regard? Thanks.regards,maheswar. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2001-12-19 : 09:18:39
|
| SQL Server 7.0 and 2000 support both snapshot, transactional and merge replication with Access subscribers.--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-19 : 09:33:09
|
| Firstly, u need not post ur question multipe times, u posted it thrice. it doesnt help.Coming to your question,u can xport ur data in sql server and have a link tables in access so any changes there will be automatically reflected back in Access, if thts what u r looking for.-------------------------"Success is when Preparedness meets Opportunity"Edited by - Nazim on 12/19/2001 09:34:04 |
|
|
|
vmahesh
Starting Member
19 Posts |
Posted - 2001-12-19 : 09:42:53
|
| How to create the link between Access and SQL Server tables? |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-19 : 09:51:47
|
| if u click on new table in access u get multiple options like Datasheet view,Design view.... there you will find a link tableclick on link table select a odbc which points to your sqlserver database(if its not already there create one). it will give u the list of tables select all of them and click ok. that should do the task of linking your tables from Sql Server to Access.if your have Access 2000 , create a new database of type Project existing database it will ask you for connection information to your Sql server database input it and u will be able to access all the tables views and stored procedures from Access of Sql server . i have never tried this one, but am sure this should help u too.-------------------------"Success is when Preparedness meets Opportunity" |
|
|
|
vmahesh
Starting Member
19 Posts |
Posted - 2001-12-19 : 10:19:16
|
| I have a VB frontend with ADO objects. Do I need to take care of any additional things ? Thanks for the help so far. It was very helpful.regards,maheswar. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-19 : 11:06:22
|
| i dont think much of your code will change , but u got to point your connection string to Sql server not Access.you can create stored procedures for any Data Manipulation Activities and call them thru Ado. to increase performance you can create indexes on fields where you use it quite often on where clause. i would suggest u to go thru any good book on Sql Server and learn to use its power. go thru BOL too.HTH-------------------------"Success is when Preparedness meets Opportunity" |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-19 : 12:14:49
|
| Why keep both an Access and SQL version? Can't you just use the SQL version? Seems a lot simpler to me. |
|
|
|
|
|
|
|
|
synchronization between MS Access and SQL Server