X xsman New member Local time Today, 12:28 Joined Mar 21, 2008 Messages 1 Mar 22, 2008 #1 hi, im trying to develop a system with access as forntend with mssql server as a backend database. Can anyone point me towards a good tutorial on this topic? Thanks
hi, im trying to develop a system with access as forntend with mssql server as a backend database. Can anyone point me towards a good tutorial on this topic? Thanks
P PeterOC Registered User. Local time Tomorrow, 04:28 Joined Nov 22, 2007 Messages 80 Mar 23, 2008 #2 I would recommend that you stick to using a MDB rather than and ADP. You can use the upsizing wizard to move your tables to SQL Server. Some articles I found useful (though they are not tutorials as such) were: http://www.granite.ab.ca/Access/sqlserverupsizing.htm http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html http://www.sqlservercentral.com/art...ding/accesstosqlservertheupsizingwizard/1721/ (though it's a bit old) Essentially you can move your tables Sql Server and then add them as linked tables. You do need to know a bit about SQL Server though. HTH P
I would recommend that you stick to using a MDB rather than and ADP. You can use the upsizing wizard to move your tables to SQL Server. Some articles I found useful (though they are not tutorials as such) were: http://www.granite.ab.ca/Access/sqlserverupsizing.htm http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html http://www.sqlservercentral.com/art...ding/accesstosqlservertheupsizingwizard/1721/ (though it's a bit old) Essentially you can move your tables Sql Server and then add them as linked tables. You do need to know a bit about SQL Server though. HTH P
