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

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.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/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