Issues Connecting to SQLServer

I=92m trying to use a DSN-less connection to a SQLSERVER DB and am
experiencing problems.  I can connect to all the tables I need and
most of the views.  However, one view is giving me problems.

The view in question is a summary for use on a report =96 basically
totaling up hours and dollars from a bunch of detail records =96 in an
attempt to reduce the amount of data sent over the network.  For some
unknown reason, I can=92t set an index on the view, so whenever I try to
link to it programmatically I get the =93Select Unique Record
Identifier=94 dialog box.  I don=92t want the end user to have to deal
with that.

So as a work around, I tried going to a pass-through query.  Works
great, but since it=92s a DSN-less connection I need to embed the
password in the ODBC connection string.  That=92s a non-starter.

I=92d really rather not go to a DSN connection and changing the query to
do the totaling locally instead of on the server will likely end up
slowing things down unnecessarily.

So my questions are:
=95	How do I programmatically deal with the select unique record
identifier?  If I can dismiss that programmatically, I should be good
to go.
=95	Alternately, how do I obscure the ODBC connection string on the pass-
through query?
=95	Any other ways to go about this?

Thanks
0
Tom
12/10/2009 5:31:11 PM
access 16762 articles. 2 followers. Follow

13 Replies
751 Views

Similar Articles

[PageSpeed] 27

I'm confused as to why it's okay to have the password stored in the TableDef 
object's Connect property but not in the QueryDef object's.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom" <rtmnews@swbell.net> wrote in message 
news:530cc2c5-32da-4b0d-96f6-e38f6710b029@k19g2000yqc.googlegroups.com...
I�m trying to use a DSN-less connection to a SQLSERVER DB and am
experiencing problems.  I can connect to all the tables I need and
most of the views.  However, one view is giving me problems.

The view in question is a summary for use on a report � basically
totaling up hours and dollars from a bunch of detail records � in an
attempt to reduce the amount of data sent over the network.  For some
unknown reason, I can�t set an index on the view, so whenever I try to
link to it programmatically I get the �Select Unique Record
Identifier� dialog box.  I don�t want the end user to have to deal
with that.

So as a work around, I tried going to a pass-through query.  Works
great, but since it�s a DSN-less connection I need to embed the
password in the ODBC connection string.  That�s a non-starter.

I�d really rather not go to a DSN connection and changing the query to
do the totaling locally instead of on the server will likely end up
slowing things down unnecessarily.

So my questions are:
� How do I programmatically deal with the select unique record
identifier?  If I can dismiss that programmatically, I should be good
to go.
� Alternately, how do I obscure the ODBC connection string on the pass-
through query?
� Any other ways to go about this?

Thanks 


0
Douglas
12/10/2009 5:43:55 PM
On Dec 10, 11:43=A0am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> I'm confused as to why it's okay to have the password stored in the Table=
Def
> object's Connect property but not in the QueryDef object's.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "Tom" <rtmn...@swbell.net> wrote in message
>
> news:530cc2c5-32da-4b0d-96f6-e38f6710b029@k19g2000yqc.googlegroups.com...
> I m trying to use a DSN-less connection to a SQLSERVER DB and am
> experiencing problems. =A0I can connect to all the tables I need and
> most of the views. =A0However, one view is giving me problems.
>
> The view in question is a summary for use on a report basically
> totaling up hours and dollars from a bunch of detail records in an
> attempt to reduce the amount of data sent over the network. =A0For some
> unknown reason, I can t set an index on the view, so whenever I try to
> link to it programmatically I get the Select Unique Record
> Identifier dialog box. =A0I don t want the end user to have to deal
> with that.
>
> So as a work around, I tried going to a pass-through query. =A0Works
> great, but since it s a DSN-less connection I need to embed the
> password in the ODBC connection string. =A0That s a non-starter.
>
> I d really rather not go to a DSN connection and changing the query to
> do the totaling locally instead of on the server will likely end up
> slowing things down unnecessarily.
>
> So my questions are:
> How do I programmatically deal with the select unique record
> identifier? =A0If I can dismiss that programmatically, I should be good
> to go.
> Alternately, how do I obscure the ODBC connection string on the pass-
> through query?
> Any other ways to go about this?
>
> Thanks

Maybe its trival, but with it stored in the TableDef connect property,
you need to write code to find it (yes, I know its a trival piece of
code, but its sufficent to keep out the merely curious).  With the
query, you can open the query and then open the property dialog box
and its staring you in the face.

Bascially, I just need to do enough not to tempt people...
0
Tom
12/10/2009 6:03:18 PM
hi Tom,

On 10.12.2009 18:31, Tom wrote:
> So as a work around, I tried going to a pass-through query.  Works
> great, but since it�s a DSN-less connection I need to embed the
> password in the ODBC connection string.  That�s a non-starter.
You should never store the password. How do you control whether an 
expirienced user types

   ?CurrentDb.TableDefs.Item(0).Connect

in the immediate window?

> So my questions are:
> �	How do I programmatically deal with the select unique record
> identifier?  If I can dismiss that programmatically, I should be good
> to go.
This window is normally not raise when relinking your tables by code.


mfG
--> stefan <--
0
Stefan
12/10/2009 6:14:27 PM
Open the table in Design mode (ignore the message that it's "a linked table 
with some properties that can't be modified") and then look at the 
Properties tab. The Connect string shows up in the Description property.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom" <rtmnews@swbell.net> wrote in message 
news:8eb43ef4-780e-444b-8c0a-ca379ff51fb7@j4g2000yqe.googlegroups.com...
On Dec 10, 11:43 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> I'm confused as to why it's okay to have the password stored in the 
> TableDef
> object's Connect property but not in the QueryDef object's.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "Tom" <rtmn...@swbell.net> wrote in message
>
> news:530cc2c5-32da-4b0d-96f6-e38f6710b029@k19g2000yqc.googlegroups.com...
> I m trying to use a DSN-less connection to a SQLSERVER DB and am
> experiencing problems. I can connect to all the tables I need and
> most of the views. However, one view is giving me problems.
>
> The view in question is a summary for use on a report basically
> totaling up hours and dollars from a bunch of detail records in an
> attempt to reduce the amount of data sent over the network. For some
> unknown reason, I can t set an index on the view, so whenever I try to
> link to it programmatically I get the Select Unique Record
> Identifier dialog box. I don t want the end user to have to deal
> with that.
>
> So as a work around, I tried going to a pass-through query. Works
> great, but since it s a DSN-less connection I need to embed the
> password in the ODBC connection string. That s a non-starter.
>
> I d really rather not go to a DSN connection and changing the query to
> do the totaling locally instead of on the server will likely end up
> slowing things down unnecessarily.
>
> So my questions are:
> How do I programmatically deal with the select unique record
> identifier? If I can dismiss that programmatically, I should be good
> to go.
> Alternately, how do I obscure the ODBC connection string on the pass-
> through query?
> Any other ways to go about this?
>
> Thanks

Maybe its trival, but with it stored in the TableDef connect property,
you need to write code to find it (yes, I know its a trival piece of
code, but its sufficent to keep out the merely curious).  With the
query, you can open the query and then open the property dialog box
and its staring you in the face.

Bascially, I just need to do enough not to tempt people... 


0
Douglas
12/10/2009 6:17:54 PM
On Dec 10, 12:17=A0pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> Open the table in Design mode (ignore the message that it's "a linked tab=
le
> with some properties that can't be modified") and then look at the
> Properties tab. The Connect string shows up in the Description property.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "Tom" <rtmn...@swbell.net> wrote in message
>
> news:8eb43ef4-780e-444b-8c0a-ca379ff51fb7@j4g2000yqe.googlegroups.com...
> On Dec 10, 11:43 am, "Douglas J. Steele"
>
>
>
>
>
> <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> > I'm confused as to why it's okay to have the password stored in the
> > TableDef
> > object's Connect property but not in the QueryDef object's.
>
> > --
> > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> > (no e-mails, please!)
>
> > "Tom" <rtmn...@swbell.net> wrote in message
>
> >news:530cc2c5-32da-4b0d-96f6-e38f6710b029@k19g2000yqc.googlegroups.com..=
..
> > I m trying to use a DSN-less connection to a SQLSERVER DB and am
> > experiencing problems. I can connect to all the tables I need and
> > most of the views. However, one view is giving me problems.
>
> > The view in question is a summary for use on a report basically
> > totaling up hours and dollars from a bunch of detail records in an
> > attempt to reduce the amount of data sent over the network. For some
> > unknown reason, I can t set an index on the view, so whenever I try to
> > link to it programmatically I get the Select Unique Record
> > Identifier dialog box. I don t want the end user to have to deal
> > with that.
>
> > So as a work around, I tried going to a pass-through query. Works
> > great, but since it s a DSN-less connection I need to embed the
> > password in the ODBC connection string. That s a non-starter.
>
> > I d really rather not go to a DSN connection and changing the query to
> > do the totaling locally instead of on the server will likely end up
> > slowing things down unnecessarily.
>
> > So my questions are:
> > How do I programmatically deal with the select unique record
> > identifier? If I can dismiss that programmatically, I should be good
> > to go.
> > Alternately, how do I obscure the ODBC connection string on the pass-
> > through query?
> > Any other ways to go about this?
>
> > Thanks
>
> Maybe its trival, but with it stored in the TableDef connect property,
> you need to write code to find it (yes, I know its a trival piece of
> code, but its sufficent to keep out the merely curious). =A0With the
> query, you can open the query and then open the property dialog box
> and its staring you in the face.
>
> Bascially, I just need to do enough not to tempt people...- Hide quoted t=
ext -
>
> - Show quoted text -


Doug:
The password is stripped out for the table.  Its not stripped out for
the query.  So I'm back to not wanting to put the password where it is
*easily* found.

Tom
0
Tom
12/10/2009 6:30:11 PM
Any chance of switching to Trusted Connection? No SQL Server IDs to manage 
then...

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom" <rtmnews@swbell.net> wrote in message 
news:2f8bbbff-dc08-426d-97a0-82607f8a46b1@j24g2000yqa.googlegroups.com...
On Dec 10, 12:17 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> Open the table in Design mode (ignore the message that it's "a linked 
> table
> with some properties that can't be modified") and then look at the
> Properties tab. The Connect string shows up in the Description property.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "Tom" <rtmn...@swbell.net> wrote in message
>
> news:8eb43ef4-780e-444b-8c0a-ca379ff51fb7@j4g2000yqe.googlegroups.com...
> On Dec 10, 11:43 am, "Douglas J. Steele"
>
>
>
>
>
> <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> > I'm confused as to why it's okay to have the password stored in the
> > TableDef
> > object's Connect property but not in the QueryDef object's.
>
> > --
> > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> > (no e-mails, please!)
>
> > "Tom" <rtmn...@swbell.net> wrote in message
>
> >news:530cc2c5-32da-4b0d-96f6-e38f6710b029@k19g2000yqc.googlegroups.com...
> > I m trying to use a DSN-less connection to a SQLSERVER DB and am
> > experiencing problems. I can connect to all the tables I need and
> > most of the views. However, one view is giving me problems.
>
> > The view in question is a summary for use on a report basically
> > totaling up hours and dollars from a bunch of detail records in an
> > attempt to reduce the amount of data sent over the network. For some
> > unknown reason, I can t set an index on the view, so whenever I try to
> > link to it programmatically I get the Select Unique Record
> > Identifier dialog box. I don t want the end user to have to deal
> > with that.
>
> > So as a work around, I tried going to a pass-through query. Works
> > great, but since it s a DSN-less connection I need to embed the
> > password in the ODBC connection string. That s a non-starter.
>
> > I d really rather not go to a DSN connection and changing the query to
> > do the totaling locally instead of on the server will likely end up
> > slowing things down unnecessarily.
>
> > So my questions are:
> > How do I programmatically deal with the select unique record
> > identifier? If I can dismiss that programmatically, I should be good
> > to go.
> > Alternately, how do I obscure the ODBC connection string on the pass-
> > through query?
> > Any other ways to go about this?
>
> > Thanks
>
> Maybe its trival, but with it stored in the TableDef connect property,
> you need to write code to find it (yes, I know its a trival piece of
> code, but its sufficent to keep out the merely curious). With the
> query, you can open the query and then open the property dialog box
> and its staring you in the face.
>
> Bascially, I just need to do enough not to tempt people...- Hide quoted 
> text -
>
> - Show quoted text -


Doug:
The password is stripped out for the table.  Its not stripped out for
the query.  So I'm back to not wanting to put the password where it is
*easily* found.

Tom 


0
Douglas
12/10/2009 6:37:35 PM
On Dec 10, 12:14=A0pm, Stefan Hoffmann <ste...@ste5an.de> wrote:
> hi Tom,
>
> On 10.12.2009 18:31, Tom wrote:> So as a work around, I tried going to a =
pass-through query. =A0Works
> > great, but since it=92s a DSN-less connection I need to embed the
> > password in the ODBC connection string. =A0That=92s a non-starter.
>
> You should never store the password. How do you control whether an
> expirienced user types
>
> =A0 =A0?CurrentDb.TableDefs.Item(0).Connect
>
> in the immediate window?
>
> > So my questions are:
> > =95 =A0 =A0 =A0 =A0How do I programmatically deal with the select uniqu=
e record
> > identifier? =A0If I can dismiss that programmatically, I should be good
> > to go.
>
> This window is normally not raise when relinking your tables by code.
>
> mfG
> --> stefan <--

Stefan:

See below:

> How do you control whether an expirienced user types?CurrentDb.TableDefs.=
Item(0).Connect

I can't - but I'm not really trying to.  All I'm really trying to do
is prevent the password from being displayed to the merely curious.

> This window is normally not raise when relinking your tables by code.

I'm using the code below to relink and I see it every time it hits the
view in question...

Code:

Set rst =3D CurrentDb.OpenRecordset("Select * from tblTableName",
dbOpenSnapshot)  'tblTableName is a list of all tables/views to
connect too

Do Until rst.EOF
   strdboName =3D "dbo_" & rst!TableName
   On Error Resume Next  'ignore error if the table doesn't exist to
delete
   CurrentDb.TableDefs.Delete (strdboName)
   On Error GoTo ErrHandler
   strodbc =3D "ODBC;Driver=3D{SQL Server};Server=3DZZZ;Database=3DAAA;WSID=
=3D"
& Environ("UserName") & ";uid=3DXXX;pwd=3DYYY"
   DoCmd.TransferDatabase acLink, "ODBC Database", strodbc, acTable,
rst!TableName, strdboName, , True
   rst.MoveNext
Loop


The DB is converted to an MDE and stored on the server.  A shortcut
points to a .BAT file to download the MDE to the user's HD and execute
it.  The above code is called from the slash screen to update the
links.

Per the setup the DBA has given me, everybody that executes the MDE is
logging in using a common UID and PWD (that none of the users know).

So while this is obviously not a highly secure set up, its the hand I
have been dealt.  My goal is simply not to have the PWD where it is
easily found.  Given the user population, anything that requires code
to access is not easily found.
0
Tom
12/10/2009 6:46:41 PM
On Dec 10, 12:37=A0pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> Any chance of switching to Trusted Connection? No SQL Server IDs to manag=
e
> then...
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>

Doug

If I understand trusted connections correctly (and I'm a SQLSERVER
novice, so I might not), while I could use a trusted connection, I
would have to have the DBA make sure all the users were mapped to the
right UID with the proper permissions in the DB.  Unfortunately, there
is virtually no chance that I would be successful in getting the DBA
to change the way he does things.



Tom
0
Tom
12/10/2009 7:13:23 PM
It's been a while since I've done any SQL Server DBA-type work, but that's 
not my recollection of how it needs to work.

You can grant permissions to global groups, and just make sure that all 
users are in the appropriate groups.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom" <rtmnews@swbell.net> wrote in message 
news:7e83ed6c-626d-4cbb-9fe2-6df8cca88205@b2g2000yqi.googlegroups.com...
On Dec 10, 12:37 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> Any chance of switching to Trusted Connection? No SQL Server IDs to manage
> then...
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>

Doug

If I understand trusted connections correctly (and I'm a SQLSERVER
novice, so I might not), while I could use a trusted connection, I
would have to have the DBA make sure all the users were mapped to the
right UID with the proper permissions in the DB.  Unfortunately, there
is virtually no chance that I would be successful in getting the DBA
to change the way he does things.



Tom 


0
Douglas
12/10/2009 7:20:44 PM
On Dec 10, 1:20=A0pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> It's been a while since I've done any SQL Server DBA-type work, but that'=
s
> not my recollection of how it needs to work.
>
> You can grant permissions to global groups, and just make sure that all
> users are in the appropriate groups.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)

Doug:
Hmm - I'll go back to the DBA so he can educate me so more, but I
think the crux of the problem is making sure all users are in the
appropriate group.  He doesn't want to deal with that issue.  He's
issued me a single UID and PWD that have read/write permissions to the
DB and expects all my users to make use of them.

Perhaps I should just change to a DSN connection and move on?

Thanks

Tom

0
Tom
12/10/2009 7:39:24 PM
Just to be clear, the DBA wouldn't be managing the group membership. These 
are groups in Active Directory, not something in SQL Server.


-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom" <rtmnews@swbell.net> wrote in message 
news:e64c052a-cf3e-4326-94d2-2a3786eb7d79@k19g2000yqc.googlegroups.com...
On Dec 10, 1:20 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> It's been a while since I've done any SQL Server DBA-type work, but that's
> not my recollection of how it needs to work.
>
> You can grant permissions to global groups, and just make sure that all
> users are in the appropriate groups.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)

Doug:
Hmm - I'll go back to the DBA so he can educate me so more, but I
think the crux of the problem is making sure all users are in the
appropriate group.  He doesn't want to deal with that issue.  He's
issued me a single UID and PWD that have read/write permissions to the
DB and expects all my users to make use of them.

Perhaps I should just change to a DSN connection and move on?

Thanks

Tom


0
Douglas
12/10/2009 8:38:10 PM
hi Tom,

On 10.12.2009 19:46, Tom wrote:
> On Dec 10, 12:14 pm, Stefan Hoffmann<ste...@ste5an.de>  wrote:
> I'm using the code below to relink and I see it every time it hits the
> view in question...
You should have posted this the first time...

> Code:
>     DoCmd.TransferDatabase acLink, "ODBC Database", strodbc, acTable,
> rst!TableName, strdboName, , True
This is the problems origin. You should use the TableDefs collection 
instead:


Public Function TableLinkODBC(ASourceName As String, _
                          Optional ADestinationName As String = "", _
                          Optional APrimaryKey As String = "") _
                          As Boolean

   On Local Error GoTo LocalError

   Dim CONNECTION_ODBC As String

   TableLinkODBC = False

   ' You must build your connection string somewhere...
   CONNECTION_ODBC = "ODBC;" & _
     "DRIVER={SQL Server};" & _
     "SERVER=(local)\SQLEXPRESS;" & _
     "DATABASE=Doh;"

   ASourceName = UCase(ASourceName)
   If ADestinationName = "" Then
      ADestinationName = ASourceName
   End If

   If TableExists(ADestinationName) Then
      Debug.Print "-";
      CurrentDbC.TableDefs.Delete ADestinationName
   End If

   Debug.Print "+"; ASourceName; "="; ADestinationName
   CurrentDbC.TableDefs.Append _
     CurrentDbC.CreateTableDef( _
       ADestinationName, 0, ASourceName, CONNECTION_ODBC)
   CurrentDbC.TableDefs.Refresh

   If APrimaryKey <> "" Then
      SQLExecute "CREATE INDEX pk_" & ADestinationName & " ON " & _
        ADestinationName & "(" & APrimaryKey & ") WITH PRIMARY;"
   End If

   TableLinkODBC = True
   Exit Function

LocalError:
   MsgBox "Do'H!"

End Function

mfG
--> stefan <--
0
Stefan
12/11/2009 8:30:09 AM
Awesome - Thanks for the better method.  It seems to work great, even
with the stubborn View

Tom
0
Tom
12/11/2009 2:38:52 PM
Reply:

Similar Artilces:

Format issues
I have created a template in word which I call through a VB script from excel. The excel data is populated in the word every time I run this script. Everything works fine and the data get populated. I have a header in the template which is represents one of the fields in the excel sheet. The header shows the correct linked value for the first 10 pages but then on shows the variable name instead of the value. I have no idea why it does that? can someone help The code is as follows: For iCurrentRow = 1 To iLastRow If ActiveSheet.Range("B" & iCurrentRow...

Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange 2003 on a new domain. This was performed with the exmerge utility in a 2 step process. Now there are 2 issues with Oulook: 1) When a user types a recipient name into the address field, the name autocompletes as normal. But when the mail is sent, a message returns saying it is undeliverable. However, if the user goes into the Contacts folder and from there selects the same user to send a message to, it is successful. 2) If a user shares a calendar, specifying the user with whom to share and the level of permissions, all users in ...

Taskbar issue
Hello All I'm hoping someone can help me with this long-standing problem with both XP and Vista on separate laptops and every computer I've had (except I think Win98). I'm thinking there may be no solution, but what it's worth a try. With both of my machines, I have the taskbar (as well as other toolbars) set out to maximum size - typically half the screen - and to auto hide. (This makes a great program and file launcher) The issue is that the operating system decides it wants open the taskbar on its own from time to time on its own. Various things prompt this, ma...

DST issue
I entered the catalog item: <Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" /> and confirmed that the device has the registry key: HKLM\Software\Microsoft\Clock\AutoDST = 1 But the device still does not automatically adjust for DST. I set the timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one minute...and the time changed to 2:00AM instead of 3:00AM. What am I missing? Thanks. which OS version are you using? have you updated it with the relevant qfes which deal with the changing in DST starting day? -...

ADO connect mysql
Dear Sirs, I want to use mysql as database,and work on the datas through ADO in the excel. so I get exchange the datas with Excel and mysql. This is best way for my works I can imagine this moment. Please help me to provide me code how to establish connection from Excel to mysql. thanks advancely. Best regards http://forums.mysql.com/read.php?10,100302 Tim "Li Jianyong" <LiJianyong@discussions.microsoft.com> wrote in message news:56BC5ABE-CBB6-4F76-B956-32153ECDB5AD@microsoft.com... > Dear Sirs, > > I want to use mysql as database,and wo...

Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can recieve it using Outlook. There error says that Outlook was unable to access the SMTP server. I cannot access my email at HOME through the web email. What I can do is send/recieve email using Outlook Express AND I can access my email through my web email client outside my home. My ISP (SBC) says its not them and I'm somewhat inclined to agree with them? They say I could have a corrupted kernel32.dll file. I have turned off my Norton, deleted my account and set up a new one and re-installed XP professiona...

Extender Install Issues
GP 8.0 Extender install - I'm encountering the following: *Login to GP brings up screen: "Great Plains Extender needs to finish installing. This may take a few minutes". It has an OK button and clicking on this gets you into GP but it comes up everytime. How can we stop this from popping up all the time. *When creating a new Extender Window and I get select the Form, I get the following error: "A remove range operation on table 'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or function zDP_EXT40101L_1 has too many arguments spec...

Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to be able to use some of the tables and subtables as a sort of checklist for the audits. The table/subtable structure is as follows: Topic -->Subtopic -->ProgramArea -->ProgramRequirement I decided to create a report that will output that data. However, the report is only outputting information if there are ProgramRequirements already entered for a given ProgramArea. Is there a way to get it to output the ProgramArea and ProgramRequirement even if blank? Or am I going about th...

Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are unable to send documents to PDF from GP - the PDF option remains grayed out. We have folowed the KB articles that are available, no success. Do we need to install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe 9? Thank you for any assistance.. Hi Susan, I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0 It is working succesfully. -- Geoff James "Susan" wrote: > We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...

Issue with formula is Pivot table
I have the following formula in a pivot table: =IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) First to the issues that I am experiencing. First, the formula wa originally added as the one below but then updated to the formula abov to correctly reflect what I was trying to accomplish. =IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) This issue is the original formula appears in the very first cell o the pivot table and then periodically through out the column. So, yo see ...

Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a webpage it returns an error stating that the the "item could not be created". Outlook 2000/Windows 2000 ...

Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users, Starting over the last two weeks (possibly after an update on the Exchange server), all of my users are starting to encounter the same issue when using Outlook Web Access (using IE6 on XP Pro systems). We have images in our signature block, and now when someone replies using Webmail to an e-mail originally sent via Outlook 2003, a login prompt appears for each image in the e-mail. Every time you cancel the login box, a red x image box appears, until all of the images that should be there are represented by the red x boxes. For the record, this has w...

Update Issues
Has anyone experienced any problems with XP Pro updates sent in Feb.? My Lenovo T61p has performed flawlessly for 2+years but suddenly started turning off and now stays on but freezes-up. I can’t detect a virus and seems like the Feb. updates are all that has changed. I plan to uninstall them….between freeze-ups, unless someone has a better thought. Thanks >Has anyone experienced any problems with XP Pro updates sent in Feb.? My >Lenovo T61p has performed flawlessly for 2+years but suddenly started turning >off and now stays on but freezes-up. I can�t detect a ...

Shared file keeps losing connection
I have a shared workbook, and sometimes when I work on it, it seems to lose connection with the shared file. (as it happens, its a 2003 file operating on both 2003 and 2007, but I don't think that's related to the problem) The workbook has VBA modules in, nothing very complicated though. and I get the following message: 'You are no longer connected to this file. Another user may have removed you, or saved over it.' The file is always still there, and we haven't been removed. It is infuriating for everyone involved. Is there a way of getting it to automa...

~ issue
I am currently using Outlook Express 6 and have noticed that for the second time (did a format the first time thinking I had a virus!) that when I have downloaded the 330994 April 2003, Security update for Outlook Express 6 SP1 that anytime I make a change to my address book and reboot I get an icon on my desktop that is named "~" and it basically is my entire address book. Has anyone else experienced this problem and how do I remedy it? Thank you for any help! Sue In reviewing the Outlook Express newsgroups, this is reported as a known issue w/ no fix from Microsoft (report...

Multiple Outlook Mailboxes issues with 3.0
I have a large number of users who have more than one outlook mailboxes, When I open an email from one of the addtional mailboxes, I get an error message that tells me "Only Items in the default Outlook store can be promoted to Microsoft CRM." Does anyone know if this can be worked around?? ...

chkdsk issue
Whenever I run chkdsk /r, it finds quite a few errors and corrects them. An example is a lot of orphaned files. Then, if I run it again right away, it does the same thing and finds the sa,e orphaned files. What causes this and how can I correct it? Thank you. On 14 May 2010, five256@NOwhere.com wrote in microsoft.public.windows.vista.general: > Whenever I run chkdsk /r, it finds quite a few errors and corrects > them. An example is a lot of orphaned files. Then, if I run it > again right away, it does the same thing and finds the sa,e > orphaned files. What causes...

RSS Sync issue
Hi, I discovered that Outlook is not syncing all my RSS-Feeds. When i tried to export into an OPML list, the same issue which are not synced are not exported as well. Anyone idea ? Thanks Hans ...

Public Folder Replication issue #3
I have a single domain which is linked across a VPN to two sites. At both sites I have a DC and an Exchange box. The issue I am having is on Server A, I can see and access all public folders, on Server B I cannot see one folder and two other folders have no data. I have checked to ensure they are set up for replication and even in ESM it shows they are "In Sync" or "Local Modified". Any suggestions on how to resolve this would be greatly appreciated. Douglas Hiser In each public folder's properties do you have both servers showing as having replicas? Do yo...

Domain name issue migrating 5.5 to Exchange 2003
We are prepairing to migrate Echange 5.5 to Exchange 2003. This has come up as an issue: Our domain is cornerstone instead of cornerstone.com Our email address is "firstname.lastname@cornerstonegrp.com" instead of: "firstname.lastname@cornerstone.com" ...

Laptop Client Issues
I've got 2 issues with Laptop client: 1. When I open outlook, crm add-in works fine. I close outlook and reopen and I get the cannot load crm functinality error. I open again and it works. If I am in a state where there is an error, I can go to the add-in manager and uncheck crm addin, hit ok, the recheck crm addin and it will connect. This happens when I am online or offline. 2. Outlook hangs synching with exchange server. Sometimes the send/receive finishes and then seems to just hang. If I turn off crm addin, it always works correctly. Anyone else experiencing these iss...

Outlook Express Issue
Greetings I have inadvertently deleted a folder. The associated DBX file still exists. Any ideas as to how I might get it to reappear in my folders list in Outlook Express? TIA Maurice You can use import for this. For additional support ask in an Outlook Express forum. This is an Microsoft Office Outlook forum. Outlook Express is family of Internet Explorer and Outlook of the Office family. Here is the link for the right forum http://communities.microsoft.com/newsgroups/default.asp?icp=InternetExplorer Good Luck! -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of th...

CRM 4.0
Hi, I'm a relatively new CRM developer. I just attended the CRM conference in Toronto a week ago and I'm pretty excited about coming in on a fresh release. One of the options that seem very useful of course are "many to many" relationships. I've tried to customize the products entity to create my own relationship. Basically the situation I have is that I'm creating course packages (products) with sub-products (courses). So I'm going into the products table and creating a many-to-many relationship with itself. So far so good. Indeed, all the "...

Trouble connecting to Microsoft Exchange Server with Outlook 2002
I have Outlook 2002 and my college uses Microsoft Exchange 2003. During the year, when I was on the campus network, I had no problem connecting to the exchange server through Outlook. But now that I am home for the summer, when I open Outlook, it tells me that I cannot access the Microsoft Exchange Server. My home internet connection is a cable-modem running through a NetGear rp614 Router. I thought that possibly my problem was a problem with port forwarding on the router but when I bypassed the router and hooked my computer directly to the cable modem I still had the same proble...

SBS 2003 RRAS/VPN issue
I've got a SBS 2k3 box, SP2. I believe it's Prem since I see SQL 2k5, but ISA isn't installed. The firewall in place is the NAT/firewall in RRAS for the internet interface. The internal server IP is 192.168.16.1. I can successfully establish a VPN connection remotely from an XP machine, and get an IP address. It looks to be from the DHCP range from the internal server (16.37 for example), dhcp enabled says no. It's PPTP. From there, I can't get on the internet, nor can I ping or access the server in any way shape or form. I am unsure if this used to w...