OBDC Database I don't want to change the data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a SQL Server Database in our New York Office. I want to create a
connection to that database but I'm not sure if connecting using OBDC will
make my database live. I Don't want users to manipulate the data... The
other problem is that I don't have access to create a view in the SQL
server... what I'm doing now is using excel to bring that data and do a
copy/paste to excel. is there anyway that I can do this in excel but without
the fear that I can erase data??? Thanks.
 
Victor said:
We have a SQL Server Database in our New York Office. I want to
create a connection to that database but I'm not sure if connecting
using OBDC will make my database live. I Don't want users to
manipulate the data... The other problem is that I don't have access
to create a view in the SQL server... what I'm doing now is using
excel to bring that data and do a copy/paste to excel. is there
anyway that I can do this in excel but without the fear that I can
erase data??? Thanks.
Click to expand...

Don't give users update permissions to the table on the server. At any
rate, I don't believe that "Get External Data" in Excel ever produces a link
that is editable. You would have to do testing to confirm that though.
 
Hi Rick. That means that if I use Get External data in excel is not editable
but in Access it is??? and so, how I will put that table not editable so no
one can change the data?
 
Victor said:
Hi Rick. That means that if I use Get External data in excel is not
editable but in Access it is??? and so, how I will put that table
not editable so no one can change the data?
Click to expand...

In Access you could use a passthrough query instead of a table link.
Passthrough queries are always read-only.
 
Hi Rick...

Sorry for being ignorant, but how do I do that??? Hehehe... I'm very
good at Access but this is my first time using an external source and people
are pushing me to finish this program. Thanks in any help that you could
give me.
 
Victor said:
Hi Rick...

Sorry for being ignorant, but how do I do that??? Hehehe... I'm
very good at Access but this is my first time using an external
source and people are pushing me to finish this program. Thanks in
any help that you could give me.
Click to expand...

New query. From the Menu...

Query
SQL Specific
Pass-Through

That will switch you to SQL View (you can;t use the QBE grid for a
pass-through query).

Open the property sheet/ The second property listed for hte query will be
labelled "ODBC Connect Str". Put your cursor in that property and then
press the build [...] button that appears to the right of the box.

That will open the "Select Data Source" dialog just as you would see when
linking to an ODBC table. Select the same source you are now using for your
link.

In the SQL window enter...

SELECT * FROM TableName

....then switch to datasheet view to see if it works. If you don't need the
whole table you can make the query more efficient by adding a WHERE clause
and if you don't need all fields you can make it more efficient by replacing
the * with specific field names separated by commas.
 
Thanks Rick... I did it. but one last question... I'm still using the
database live?? if I try to change something here will it be change in the
SQL Server database?? Thanks

Rick Brandt said:
Victor said:
Hi Rick...

Sorry for being ignorant, but how do I do that??? Hehehe... I'm
very good at Access but this is my first time using an external
source and people are pushing me to finish this program. Thanks in
any help that you could give me.
Click to expand...

New query. From the Menu...

Query
SQL Specific
Pass-Through

That will switch you to SQL View (you can;t use the QBE grid for a
pass-through query).

Open the property sheet/ The second property listed for hte query will be
labelled "ODBC Connect Str". Put your cursor in that property and then
press the build [...] button that appears to the right of the box.

That will open the "Select Data Source" dialog just as you would see when
linking to an ODBC table. Select the same source you are now using for your
link.

In the SQL window enter...

SELECT * FROM TableName

....then switch to datasheet view to see if it works. If you don't need the
whole table you can make the query more efficient by adding a WHERE clause
and if you don't need all fields you can make it more efficient by replacing
the * with specific field names separated by commas.
Click to expand...
 
Victor said:
Thanks Rick... I did it. but one last question... I'm still using the
database live?? if I try to change something here will it be change
in the SQL Server database?? Thanks
Click to expand...

Try it. You won't be able to. Passthrough queries do not return editable
result sets.
 
Back
Top