Embedding SQL Server Express in the installer

Can we embed the SQL Server Express in the windows installer jsut like the XML files or the Ms access database?You are referring to the windows installer in VS 2005 I suppose ??
It is not possible in the installer of VS 2003, but I suppose it can be done with Whidbey ... I haven't tried it yet though ...|||The following information may provide clarification regarding the same;

Can I redistribute SQL Express?
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172952.aspx

Embedded Reports

hi,
do i have access to subreports '
for example: how many rows were created?
a have a tablerow with a sub report.
i want to set the visibility to hidden, if no rows were created in the
subreport...
regards
PatrickThe parent report doesn't have access to properties of the subreport.
You may want to consider setting the NoRows property on the subreport
control in the master report.
Or make the subreport control in the master report very small and then have
the subreport hide its own contents if there are no rows of data.
As a last resort, you could put a query in the master report that returns a
count of the rows of the subreport (or if you're calling the subreport
inside of a list, you would include the count as a column in your master
query) and then base the visibility on that count.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Patrick Ruhnow" <pruhnow@.dornbracht.de> wrote in message
news:uOSD0kAaEHA.556@.tk2msftngp13.phx.gbl...
> hi,
> do i have access to subreports '
> for example: how many rows were created?
> a have a tablerow with a sub report.
> i want to set the visibility to hidden, if no rows were created in the
> subreport...
>
> regards
> Patrick
>

Embedded images aren't showed

Hi,
When I access the Product Catalog of SampleReports in ReportServer
using the server name in the URL, that is,
http://MY_SERVER_NAME/ReportServer?/SampleReports/Product Catalog, I
can't see any images embedded in the report, I get a red "X" instead.
But when I access the same URL using LOCALHOST, once I'm using IE in
the server directly, I can see all images embedded.
My environment is RS SP1, IE 6.0.2900.2180 and WinXP SP2.
I don't think it's a problem with the Security or Privacy
configuration of IE because both LOCALHOST and MY_SERVER_NAME are in
Local Intranet Zone wich has Low Security. Besides, I've tried to
reduced the Privacy to "Accept All Cockies" as well, though anything
seems to help.
I'd rather keep the images embedded than put them into the database or
in a External link.
What else should I try?
Thanks in advance,
Vinicius BellinoYou might try uploading the image to the same folder in Report Server
that the report file resides in. You can then set the image's property to
'Hide in list view' so that users only see the hyperlink for the report
and not the image file as well.
GeoSynch
"Vinicius Bellino" <vbellino@.uol.com.br> wrote in message
news:93d12908.0505021244.253fd001@.posting.google.com...
> Hi,
> When I access the Product Catalog of SampleReports in ReportServer
> using the server name in the URL, that is,
> http://MY_SERVER_NAME/ReportServer?/SampleReports/Product Catalog, I
> can't see any images embedded in the report, I get a red "X" instead.
> But when I access the same URL using LOCALHOST, once I'm using IE in
> the server directly, I can see all images embedded.
> My environment is RS SP1, IE 6.0.2900.2180 and WinXP SP2.
> I don't think it's a problem with the Security or Privacy
> configuration of IE because both LOCALHOST and MY_SERVER_NAME are in
> Local Intranet Zone wich has Low Security. Besides, I've tried to
> reduced the Privacy to "Accept All Cockies" as well, though anything
> seems to help.
> I'd rather keep the images embedded than put them into the database or
> in a External link.
> What else should I try?
> Thanks in advance,
> Vinicius Bellino

Embed SQL statement in another SQL statement

Suppose I have an MS access database with query1 and query2. Query2 uses
query1 something like this:

Select table.* from (table left join query1 on field1=field2)

Now I want to make a change in query1 to change the behaviour of query2. But
this cannot be done in a live environment because I have to shut down the
application, make the change in the database and start the application
again. What I can do is make a query 3 in my application (instead of in the
database) that is initially does the same as query2 like this:

Select table.* from (table left join -->some SQL code to embed query1<-- on
field1=field2)

Once I know how to do this, I can change the "embedded" sql code to my
needs.

Question is: how do I "embed" SQL code in another statement?"John Kenickney" <spam.trap@.bigfoot.com> wrote in message news:<b0909e7389d49cec0cf4ddf5330bce77@.news.teranews.com >...
> Suppose I have an MS access database with query1 and query2. Query2 uses
> query1 something like this:
> Select table.* from (table left join query1 on field1=field2)
> Now I want to make a change in query1 to change the behaviour of query2. But
> this cannot be done in a live environment because I have to shut down the
> application, make the change in the database and start the application
> again. What I can do is make a query 3 in my application (instead of in the
> database) that is initially does the same as query2 like this:
> Select table.* from (table left join -->some SQL code to embed query1<-- on
> field1=field2)
> Once I know how to do this, I can change the "embedded" sql code to my
> needs.
> Question is: how do I "embed" SQL code in another statement?

You should probably post this in an Access forum to get a better response.

Simon

Emailing a report from a URL

Hi there,
Is it possible to email a report through the URL access method? For example,
can the URL
http://server/reportserver?reportname&rs:Format=PDF&rs:Command=Render include
a parameter such as rs:EmailTo=someone@.something.com?
Or is trying to achieve this goal a lot more involved than simply including
a parameter in a URL - such as developing a custom rendering or delivery
extension?
Many thanks
Adam AingerNo it is not possible to do this via the url. I guess in theory you could
write a rendering extension that could do this but it would be very
involved.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Adam Ainger" <AdamAinger@.discussions.microsoft.com> wrote in message
news:7EB4F8A9-CA3F-4FC9-A028-7458C3B51CFB@.microsoft.com...
> Hi there,
> Is it possible to email a report through the URL access method? For
> example,
> can the URL
> http://server/reportserver?reportname&rs:Format=PDF&rs:Command=Render
> include
> a parameter such as rs:EmailTo=someone@.something.com?
> Or is trying to achieve this goal a lot more involved than simply
> including
> a parameter in a URL - such as developing a custom rendering or delivery
> extension?
> Many thanks
> Adam Ainger|||Okay, thanks for your feedback Daniel.
"Daniel Reib (MSFT)" wrote:
> No it is not possible to do this via the url. I guess in theory you could
> write a rendering extension that could do this but it would be very
> involved.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Adam Ainger" <AdamAinger@.discussions.microsoft.com> wrote in message
> news:7EB4F8A9-CA3F-4FC9-A028-7458C3B51CFB@.microsoft.com...
> > Hi there,
> >
> > Is it possible to email a report through the URL access method? For
> > example,
> > can the URL
> > http://server/reportserver?reportname&rs:Format=PDF&rs:Command=Render
> > include
> > a parameter such as rs:EmailTo=someone@.something.com?
> >
> > Or is trying to achieve this goal a lot more involved than simply
> > including
> > a parameter in a URL - such as developing a custom rendering or delivery
> > extension?
> >
> > Many thanks
> > Adam Ainger
>
>

EM Deny Registration

How can one deny registration of a particular SQL Server
through Enterprise Manager and still be able to open a
query analyzer and access the target database of that
particular server (read only)? My problem is some users
had a green light from above to have an Enterprise
Manager installed on their server but yet have very
little experience navigating it. I am afraid if they
registered this particular server and accidentally open a
table (all rows). I can not deny them access completely
since they need to have read access from the database.Hi,
You cant restrict EM alone. If the user have access then they will be able
to register in EM.
Thanks
Hari
SQL Server MVP
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>|||LD
You can restict permissions to do any operations per database. Let me say if
the user has not permissions to operate with a database XXX ,so he will not
be able to get in vs EM.
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>

EM can't connect to server

I suddenly can't work with my Enterprise Manager.
It tells me that log in failed - Can't access user's default database.
What can I do about it?
I really need to fix it fast.
Thanks a lot
Shimon.Shimon Sim wrote:
> I suddenly can't work with my Enterprise Manager.
> It tells me that log in failed - Can't access user's default
> database.
> What can I do about it?
> I really need to fix it fast.
> Thanks a lot
> Shimon.
Connect from Query Analyzer and change the default database for the user
you are using to login from SQL EM.
sp_defaultdb 'user', 'db'
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I can't connect using QA either.
Thanks,
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
> sp_defaultdb 'user', 'db'
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Shimon Sim wrote:
> I can't connect using QA either.
> Thanks,
> Shimon.
Log in as a different user in QA... one with admin rights. Then change
the default database.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks
I connected using Visial Studio
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
> sp_defaultdb 'user', 'db'
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hi Shimon,
Thanks for your posting!
From your descriptions, I understood you are not able to connect SQL Server
via SQL Server Enterprise Manager. Have I understood you? If I have
misunderstood your concern, please feel free to point it out.
First of all, would you please help me clarify the words "I connected using
Visial Studio"? You have said you are working wiht your Enterprise Manager?
When do you meet the error message "Can't access user's default database"?
More detailed informaiton, I believe, will make us closer to the
resolution. Please help me collecting the information by answering the
questions below
What account you are using to connect this SQL Server?
The SQL Server machine is in LAN or Internet?
You may refer the Knowledge Base article below
How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/kb/827422
BTW, if this issue is urgent, I would like to recommand you opening an
incident with PSS team direcly and there will be a dedicated Support
Professional working for you. Please be advised that contacting phone
support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael
Thanks for your response.
I resolved the issue.
What happen I deleted my default database. And all the users for the SQL
Server had that database as default. So every program (EM,QA) that uses
default database in order to operate was throwing errors that they can't
login to the server.
So I decided to create database project in VS that uses specifies database
for login and not default and changed default database for all the users.
Thanks again.
Shimon.
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:NIh58$oYFHA.2476@.TK2MSFTNGXA01.phx.gbl...
> Hi Shimon,
> Thanks for your posting!
> From your descriptions, I understood you are not able to connect SQL
> Server
> via SQL Server Enterprise Manager. Have I understood you? If I have
> misunderstood your concern, please feel free to point it out.
> First of all, would you please help me clarify the words "I connected
> using
> Visial Studio"? You have said you are working wiht your Enterprise
> Manager?
> When do you meet the error message "Can't access user's default database"?
> More detailed informaiton, I believe, will make us closer to the
> resolution. Please help me collecting the information by answering the
> questions below
> What account you are using to connect this SQL Server?
> The SQL Server machine is in LAN or Internet?
> You may refer the Knowledge Base article below
> How to troubleshoot connectivity issues in SQL Server 2000
> http://support.microsoft.com/kb/827422
> BTW, if this issue is urgent, I would like to recommand you opening an
> incident with PSS team direcly and there will be a dedicated Support
> Professional working for you. Please be advised that contacting phone
> support will be a charged call.
> To obtain the phone numbers for specific technology request please take a
> look at the web site listed below.
> http://support.microsoft.com/defaul...US;PHONENUMBERS
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a w to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Shimon,
You are welcome and it's great to hear you have resolved this!
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

EM and QA access different

Users (other than sysadmin) can query tables in QA just fine, but when they
try to view the same table in EM, they get an error that says they "might no
t
have permission to perform this operation, or the object XXX might no longer
exist in the database."
Any ideas?RP
How do you query the table? by stored procedure or by querying underlying
table?
"RP" <RP@.discussions.microsoft.com> wrote in message
news:19B8A84F-3E22-455D-9792-BD4AB4F5E7AF@.microsoft.com...
> Users (other than sysadmin) can query tables in QA just fine, but when
they
> try to view the same table in EM, they get an error that says they "might
not
> have permission to perform this operation, or the object XXX might no
longer
> exist in the database."
> Any ideas?|||just a regular query of the table
"Uri Dimant" wrote:

> RP
> How do you query the table? by stored procedure or by querying underlying
> table?
>
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:19B8A84F-3E22-455D-9792-BD4AB4F5E7AF@.microsoft.com...
> they
> not
> longer
>
>

EM access error when DB name is a GUID

I am receiving a connection error when I use EM to try to
open a table is my database. I am connecting to SQL Server
as a SA user. I don't have any access errors if I use
Query Analyzer. The problem occurs trying to access tables
in a database that has a GUID for the database name
{910216B1-6186-4F13-A626-D1D4D811F3B1} The brackets are
part of the name. Any GUID name will fail. All other EM
functions work correctly. EM works correctly for all non-
GUID named databases.
The error message is "Connection failed: SQLState '08004'
SQL Server Error: 4060 Server rejected the connection;
Access to selected database has been denied.
I am running SQL Server 2000, version 8.00.818 on a
Windows 2000 server system with SP 4. The same thing
happens on a Windows XP Pro system running SQL Server 2000
Tobin Schuster wrote:
> I am receiving a connection error when I use EM to try to
> open a table is my database. I am connecting to SQL Server
> as a SA user. I don't have any access errors if I use
> Query Analyzer. The problem occurs trying to access tables
> in a database that has a GUID for the database name
> {910216B1-6186-4F13-A626-D1D4D811F3B1} The brackets are
> part of the name. Any GUID name will fail. All other EM
> functions work correctly. EM works correctly for all non-
> GUID named databases.
> The error message is "Connection failed: SQLState '08004'
> SQL Server Error: 4060 Server rejected the connection;
> Access to selected database has been denied.
> I am running SQL Server 2000, version 8.00.818 on a
> Windows 2000 server system with SP 4. The same thing
> happens on a Windows XP Pro system running SQL Server 2000
Since the name you are using contains invalid characters, it must be
delimited. I'm guessing that SQL EM is not putting brackets around the
name to get past this.
David Gugick
Imceda Software
www.imceda.com

EM - connect to correct server

Hello -
I can connect to other servers through QA with no problem, however, when I
try to access another server through Enterprise Manager, I cannot find where
I can change the server. It is defaulting to my local machine.
Can someone tell me how to do this?
Any help is greatly appreciated!
SandyIn EM, right click on your LOCAL connection. When the menu comes up you hav
e
two option "Edit SQL Server Registration properites" or "New SQL Server
Registration". Use the "New.." item to create a new item to your other
server, or if you what to change the LOCAL registration ot point to a
different server then pick the "Edit..." item.
"Sandy" wrote:

> Hello -
> I can connect to other servers through QA with no problem, however, when I
> try to access another server through Enterprise Manager, I cannot find whe
re
> I can change the server. It is defaulting to my local machine.
> Can someone tell me how to do this?
> Any help is greatly appreciated!
> --
> Sandy|||Check out in the BOL:
Administering SQL Server -> Managing Servers -> registering Servers
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||Thanks for your response, Greg!
Does this just register it on my local machine so I can access and use it?
In other words, am I changing any settings of the particular instance of Sql
Server on the server by doing this?
Also, it does not give any options for using Mixed Mode. The instance of
Sql Server I'm using is Mixed. How would you handle this situation?
Thanks again,
--
Sandy
"Greg Larsen" wrote:
> In EM, right click on your LOCAL connection. When the menu comes up you h
ave
> two option "Edit SQL Server Registration properites" or "New SQL Server
> Registration". Use the "New.." item to create a new item to your other
> server, or if you what to change the LOCAL registration ot point to a
> different server then pick the "Edit..." item.
> "Sandy" wrote:
>

Editing Table in SQL Server from Access 2002

Hi,
I am posting this message in the hope that somebody will be able to assist me.
I have a user who has the following setup:
We have a server running SQL Server 2000 SP3 (version 8.00.818) running on Windows 2000 Server SP3 and this server has a database which the user used to access and edit using his locally installed copy of Access 2002.
We have recently transfered this database to this server using the DTS wizard, which successfully moved the database. I have now configured a System DSN on the user's PC to connect to this database using SQL authentication and the user can successfully c
onnect to this database, as the DSN has demonstrated. The user has created an Access database and has links to each of the tables in the SQL database, using the 'Get External Data' component, selecting the System DSN as the connection object. The user i
s able to open the tables in Access, but he is unable to edit the data.
When this database was hosted on the previous SQL server, the user was able to edit the data in the tables. On the previous server, this user's Windows user account was a member of the local Administratos group on the server, but this database used SQL a
uthentication. To increase the security on this database, it was moved to the new SQL server, where the user's Windows account is not a member of the local Administrators group.
I have managed to replicate this on my PC, where I have an installation of Access 2003, but I have been specifiying that the database files should either be '2000' or '2002 or 2003' version. I have used SQL and Windows authentication and I in both config
urations I am unable to edit any of the tables in Access. I have given my SQL or Windows account the 'Select', 'Update', 'Delete' permissions on the table - but this has not worked at all. Does anybody have any ideas?
Many thanks in advance.
Neil
If you've verified that it's not a permissions issue, then does the
table have a primary key or unique index?
--Mary
On Thu, 8 Jul 2004 07:53:01 -0700, "NeilH"
<NeilH@.discussions.microsoft.com> wrote:

>We have a server running SQL Server 2000 SP3 (version 8.00.818) running on Windows 2000 Server SP3 and this server has a database which the user used to access and edit using his locally installed copy of Access 2002.
>We have recently transfered this database to this server using the DTS wizard, which successfully moved the database. I have now configured a System DSN on the user's PC to connect to this database using SQL authentication and the user can successfully
connect to this database, as the DSN has demonstrated. The user has created an Access database and has links to each of the tables in the SQL database, using the 'Get External Data' component, selecting the System DSN as the connection object. The user
is able to open the tables in Access, but he is unable to edit the data.
>When this database was hosted on the previous SQL server, the user was able to edit the data in the tables. On the previous server, this user's Windows user account was a member of the local Administratos group on the server, but this database used SQL
authentication. To increase the security on this database, it was moved to the new SQL server, where the user's Windows account is not a member of the local Administrators group.
>I have managed to replicate this on my PC, where I have an installation of Access 2003, but I have been specifiying that the database files should either be '2000' or '2002 or 2003' version. I have used SQL and Windows authentication and I in both confi
gurations I am unable to edit any of the tables in Access. I have given my SQL or Windows account the 'Select', 'Update', 'Delete' permissions on the table - but this has not worked at all. Does anybody have any ideas?
|||Hi Mary,
Thankyou for replying to my posting. Could I ask you to explain what terms
'Primary Key' and 'Unique Index', as I do not understand databases?
Neil
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:ietqe0dd6osr6f812l6pgo8gjtrete0uke@.4ax.com... [vbcol=seagreen]
> If you've verified that it's not a permissions issue, then does the
> table have a primary key or unique index?
> --Mary
> On Thu, 8 Jul 2004 07:53:01 -0700, "NeilH"
> <NeilH@.discussions.microsoft.com> wrote:
on Windows 2000 Server SP3 and this server has a database which the user
used to access and edit using his locally installed copy of Access 2002.[vbcol=seagreen]
wizard, which successfully moved the database. I have now configured a
System DSN on the user's PC to connect to this database using SQL
authentication and the user can successfully connect to this database, as
the DSN has demonstrated. The user has created an Access database and has
links to each of the tables in the SQL database, using the 'Get External
Data' component, selecting the System DSN as the connection object. The
user is able to open the tables in Access, but he is unable to edit the
data.[vbcol=seagreen]
able to edit the data in the tables. On the previous server, this user's
Windows user account was a member of the local Administratos group on the
server, but this database used SQL authentication. To increase the security
on this database, it was moved to the new SQL server, where the user's
Windows account is not a member of the local Administrators group.[vbcol=seagreen]
of Access 2003, but I have been specifiying that the database files should
either be '2000' or '2002 or 2003' version. I have used SQL and Windows
authentication and I in both configurations I am unable to edit any of the
tables in Access. I have given my SQL or Windows account the 'Select',
'Update', 'Delete' permissions on the table - but this has not worked at
all. Does anybody have any ideas?
>
|||I think understanding databases is going to be necessary in order for
you to succeed in your work with Access and SQL Server. I'd highly
recmmend Mike Hernandez book, Database Design for Mere Mortals, which
explains the basic concepts in an easy-to-understand way. Anyway, a
primary key or unique index uniquely identifies each row so that the
server knows which one to update. If you don't know what they are,
then you probably don't have one defined on the SQLS table. Access
will refuse to update a SQLS table that doesn't have a PK or unique
index.
--Mary
On Thu, 15 Jul 2004 09:34:39 +0100, "Neil Hobbs" <nhobbs@.sgb.co.uk>
wrote:

>Hi Mary,
>Thankyou for replying to my posting. Could I ask you to explain what terms
>'Primary Key' and 'Unique Index', as I do not understand databases?
>Neil
>
>"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
>news:ietqe0dd6osr6f812l6pgo8gjtrete0uke@.4ax.com.. .
>on Windows 2000 Server SP3 and this server has a database which the user
>used to access and edit using his locally installed copy of Access 2002.
>wizard, which successfully moved the database. I have now configured a
>System DSN on the user's PC to connect to this database using SQL
>authentication and the user can successfully connect to this database, as
>the DSN has demonstrated. The user has created an Access database and has
>links to each of the tables in the SQL database, using the 'Get External
>Data' component, selecting the System DSN as the connection object. The
>user is able to open the tables in Access, but he is unable to edit the
>data.
>able to edit the data in the tables. On the previous server, this user's
>Windows user account was a member of the local Administratos group on the
>server, but this database used SQL authentication. To increase the security
>on this database, it was moved to the new SQL server, where the user's
>Windows account is not a member of the local Administrators group.
>of Access 2003, but I have been specifiying that the database files should
>either be '2000' or '2002 or 2003' version. I have used SQL and Windows
>authentication and I in both configurations I am unable to edit any of the
>tables in Access. I have given my SQL or Windows account the 'Select',
>'Update', 'Delete' permissions on the table - but this has not worked at
>all. Does anybody have any ideas?
>