datagrid question

[Gogzilla]

Dear All,

I would like to retrieve data of table from SS2K and show them on the form
of MS access. But the datagrid control has not found in MS access. How can I
find out the solution? I now try to use ADO connection but it is still not
complete.
BTW, I have used the datasheet to substitute the datagrid but it is the
connection in same the database (Currentdb). I’m no idea for the case of
connection to another database.

Thank in advance
Gogzilla

 

[Dirk Goldgar]

Dear All,

I would like to retrieve data of table from SS2K and show them on the
form of MS access. But the datagrid control has not found in MS
access. How can I find out the solution? I now try to use ADO
connection but it is still not complete.
BTW, I have used the datasheet to substitute the datagrid but it is
the connection in same the database (Currentdb). I'm no idea for the
case of connection to another database.

Normally you would link to the SQL Server table, using the File -> Get
External Data -> Link Tables... dialog to create a linked table in your
database. Then you'd use a datasheet or a continuous form based on that
table as a much more powerful datagrid.

 

[Gogzilla]

First, in this case I would like to convert my access project to ADE and plan
to distribute my ADE to many clients. So I do not allow any users to access
directly to the linked table. I then use ADO connection to solve that
concerning. As I know, after converting to ADE. Users can still see or change
my table.

Thank in advance
Gogzilla

 

[Dirk Goldgar]

First, in this case I would like to convert my access project to ADE
and plan to distribute my ADE to many clients. So I do not allow any
users to access directly to the linked table. I then use ADO
connection to solve that concerning. As I know, after converting to
ADE. Users can still see or change my table.

I didn't know you were talking about an ADP. I haven't worked with ADPs
much. I suggest you post your question in the
microsoft.public.access.adp.sqlserver newsgroup, where you may find
someone with more knowledge in that area.

 

[Gogzilla]

Thanks a lot for your reply

Gogzilla

I didn't know you were talking about an ADP. I haven't worked with ADPs
much. I suggest you post your question in the
microsoft.public.access.adp.sqlserver newsgroup, where you may find
someone with more knowledge in that area.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)