 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / January 2008HOW TO MAKE CONNECTION ON SQL SERVER USING MS ACCESS AS A PLATFORM
HELLO GUYS, anyone could help me on how to connect my MS access program to sql server for storage of data. i'll be using sql database instead of built in MS Access database. i have separate workstation for sql server and separate workstation for access program. please teach me the step by step procedure on how to do that. your help is very much appreciated. thanks There are two ways to connect MS Access frontend to SQL Server backend: 1. Use MS Access ADP project. This type of Access format was available since Access2000 and was recommended then, but now it is on its way out (but still available with MS Access2007). I'd not choose it for new/big development. 2. Use ODBC with *.mdb format, linking tables in SQL Server database. This is recommended way. So, you need to decide which method you are to use first. BTW, this NG is for method1. If you choose method2, you need to go to other NG, such as microsoft.public access, or other microsoft.public.access.**** NGs. > HELLO GUYS, > [quoted text clipped - 10 lines] > > thanks Norman, Thank You, BTW, i tried the ADP Project and i have done it successfully, i can able to connect with the server and i had view the data encoded on sql server using the Form in access and the test connection is successful. but my problem is, i can't edit/add record on Access. your thoughts is highly appreciated. thanks. >There are two ways to connect MS Access frontend to SQL Server backend: > [quoted text clipped - 17 lines] >> >> thanks The tables you want to editadd record with Access must have a indexed column (usually a PK column). If the table is imported from an Access database, it is likely there isn't a PK column. > Norman, > [quoted text clipped - 32 lines] >>> >>> thanks Norman, How would you suggest to move from adp to mdb and distribuite the project to office end users blocking them from accessing the tables/queries? Thanks, Ana old 2003 user lost 2007 user > There are two ways to connect MS Access frontend to SQL Server backend: > [quoted text clipped - 26 lines] >> >> thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.