Very Computer

by **Mark Coope** » Sun, 17 Feb 2002 00:04:30

If I were wanting to use Access to 7.0 to enter information into a SQL 7
server database, what kind of ODBC connection would I need? I can connect
to the database linking the tables to look at the information. However I was
looking for the type of connection to modify or enter directly from Access
into the SQL table. What type of ODBC connection is needed for this type of
interoperability?

Thanks,
Mark Cooper

by **BP Margoli** » Sun, 17 Feb 2002 09:12:54

Mark,

All you need is a standard ODBC connection, using the SQL Server ODBC
driver. For ODBC to consider tables to be updateable, however, you do need
to establish on the SQL Server tables a primary key, a unique constraint, a
unique index, or a column of data type timestamp (rowversion).

If you are having a specific problem establishing a connection from Access
to SQL Server 7.0, please post details.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> If I were wanting to use Access to 7.0 to enter information into a SQL 7
> server database, what kind of ODBC connection would I need? I can connect
> to the database linking the tables to look at the information. However I
was
> looking for the type of connection to modify or enter directly from Access
> into the SQL table. What type of ODBC connection is needed for this type
of
> interoperability?

> Thanks,
> Mark Cooper

by **Mark Coope** » Wed, 20 Feb 2002 00:15:35

Thank you, It worked fine. I was importing a database from Access 97 and
didn't select the Primary key when importing. Went through the steps again
and it worked fine the second time.

Thanks, you are all a great help.

Mark Cooper

> Mark,

> All you need is a standard ODBC connection, using the SQL Server ODBC
> driver. For ODBC to consider tables to be updateable, however, you do need
> to establish on the SQL Server tables a primary key, a unique constraint,
a
> unique index, or a column of data type timestamp (rowversion).

> If you are having a specific problem establishing a connection from Access
> to SQL Server 7.0, please post details.

> -------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.

> > If I were wanting to use Access to 7.0 to enter information into a SQL 7
> > server database, what kind of ODBC connection would I need? I can
connect
> > to the database linking the tables to look at the information. However I
> was
> > looking for the type of connection to modify or enter directly from
Access
> > into the SQL table. What type of ODBC connection is needed for this
type
> of
> > interoperability?

> > Thanks,
> > Mark Cooper

Very Computer

Creating a Frontend using Access

Creating a Frontend using Access

Creating a Frontend using Access

Creating a Frontend using Access