HOW TO MAKE CONNECTION ON SQL SERVER USING MS ACCESS AS A PLATFORM

[mroks via AccessMonster.com]

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

 

[Norman Yuan]

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.

 

[mroks via AccessMonster.com]

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:

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 Yuan]

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,

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:

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

 

[Ana]

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:

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.