SQL Server 2000 & Access 2007 Project

#11

Dear Kinal,

Thank you for your response and letting me know the current situation.

If you have any other questions or need further assistance, please do not
hesitate to contact me. It is always my pleasure to be of assistance.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

Thread-Topic: SQL Server 2000 & Access 2007 Project
thread-index: AcfGXC16uLjKMVjURwmCmD25aAhEeg==
X-WBNR-Posting-Host: 207.46.193.207
From: =?Utf-8?B?SS4gS2luYWw=?= <ikinal (AT) myalias (DOT) postalias
References: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC (AT) microsoft (DOT) com
U8XSOXIvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl

<7A37D94D-DC74-41CE-8D5C-7C15F3252D67 (AT) microsoft (DOT) com>
<XXVeUQWvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl>
<3F8BC7C0-76DC-407D-9C5C-666BE32D227F (AT) microsoft (DOT) com>
<rE14RIfvHHA.3972 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl>
<1736DCCC-46E6-4DDA-9E89-31ED144C8B5B (AT) microsoft (DOT) com>
<Zn9zArhwHHA.1080 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl>
<z0KkElCxHHA.5204 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl>

Quote:

Subject: RE: SQL Server 2000 & Access 2007 Project
Date: Sat, 14 Jul 2007 14:16:00 -0700
Lines: 312
Message-ID: <D4D7FA2D-DE77-42FC-8769-F95435D27F20 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
Newsgroups: microsoft.public.sqlserver.clients
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clients:565
NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
X-Tomcat-NG: microsoft.public.sqlserver.clients

Hi,

I apologize for not responding sooner. The computer has been misbehaving
for
the past several days, and I have determined that I need to replace the
hard
drive. After that I will perform a clean installation of Office 2007,
which
will most likely fix the problem. If it does not, I will post back here.

Thanks,
I. Kinal

"Adams Qu [MSFT]" wrote:

Dear Kinal,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need
any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader
so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no
rights.

--------------------
| X-Tomcat-ID: 126327038
| References: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC (AT) microsoft (DOT) com
U8XSOXIvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
7A37D94D-DC74-41CE-8D5C-7C15F3252D67...soft (DOT) com
XXVeUQWvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
3F8BC7C0-76DC-407D-9C5C-666BE32D227F...soft (DOT) com
rE14RIfvHHA.3972 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
1736DCCC-46E6-4DDA-9E89-31ED144C8B5B...soft (DOT) com
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Mon, 09 Jul 2007 11:17:31 GMT
| Subject: RE: SQL Server 2000 & Access 2007 Project
| X-Tomcat-NG: microsoft.public.sqlserver.clients
| Message-ID: <Zn9zArhwHHA.1080 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.clients
| Lines: 381
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clients:546
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Kinal,
|
| Thank you for your reply.
|
| I am glad to hear that the connection works fine on a different
machine
| with Access 2007 installed.
|
| At this stage, we can narrow down the issue to the local settings of
Office
| program.
|
| I suggest we test the issue in the new user account. Please NOTE:
Most of
| the Office settings are stored in the user profile. By creating the
new
| user account, we can determine if the problem is caused by the user's
| office setting.
|
| 1. Log on the problematic machine as a newly created user account
(Windows
| account)
| 2. Create the ADP file and then make the connection again to check if
the
| connection can be successful.
|
| If the issue does not occur to the newly created account, please log
on
the
| original user account and then open Access 2007, Click Help-
Diagnose
the
| problem and then select Setup Diagnose to fix the user personal
settings'
| problem in Office.
|
| However, if the issue also occurs to the new user account, we may
consider
| backing up some important data and then clean install the Office
program.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader
so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
| --------------------
| | Thread-Topic: SQL Server 2000 & Access 2007 Project
| | thread-index: AcfAG4R0zDn3e/blQxqarlVSDVI8BA==
| | X-WBNR-Posting-Host: 207.46.19.197
| | From: =?Utf-8?B?SS4gS2luYWw=?= <ikinal (AT) myalias (DOT) postalias
| | References: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC (AT) microsoft (DOT) com
| <U8XSOXIvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| <7A37D94D-DC74-41CE-8D5C-7C15F3252D67 (AT) microsoft (DOT) com
| <XXVeUQWvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| <3F8BC7C0-76DC-407D-9C5C-666BE32D227F (AT) microsoft (DOT) com
| <rE14RIfvHHA.3972 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| | Subject: RE: SQL Server 2000 & Access 2007 Project
| | Date: Fri, 6 Jul 2007 15:18:02 -0700
| | Lines: 312
| | Message-ID: <1736DCCC-46E6-4DDA-9E89-31ED144C8B5B (AT) microsoft (DOT) com
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| | Newsgroups: microsoft.public.sqlserver.clients
| | Path: TK2MSFTNGHUB02.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clients:538
| | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| | X-Tomcat-NG: microsoft.public.sqlserver.clients
| |
| | Hi,
| |
| | OK, I tested connecting from a different machine with Access 2007
| installed,
| | and it worked fine, without this problem. So it does appear to be a
| problem
| | with the Access installation on this particular computer. What
would be
| the
| | best way to solve this?
| |
| | Thanks,
| | I. Kinal
| |
| | "Adams Qu [MSFT]" wrote:
| |
| | > Dear Kinal,
| |
| | > Thank you for posting here.
| |
| | > I understand the issue even occurs when we create a new ADP file
and
| make
| | > it point to a new database on SQL Sever.
| |
| | > With your efforts and cooperation, I think we should have
narrowed
down
| the
| | > cause of this problem. When the issue even occurs when we connect
to
a
| new
| | > database, the problem seems to be on the Access program side.
| |
| | > As you have mentioned that the Office 2007 program was upgraded
from
| Office
| | > 2003, let's test the issue on clean-installed Office 2007 (Access
2007)
| | > program on an alternative machine. NOTE: Please first also
connect
the
| ADP
| | > file to the newly created database for the troubleshooting
purpose.
| |
| | > Is our issue resolved?
| |
| | > However, if the same behavior still occurs, please download the
SQL
| Server
| | > 2005 Express Edition (Free) from the following download link and
then
| | > install it on a test machine. Please check if there is any
problem
when
| | > connecting the adp file to this newly installed SQL Server 2005
| database.
| |
|

http://www.microsoft.com/downloads/d...9b5-0b07-4448-
| | > 8848-dcc397514b41&DisplayLang=en
| |
| | > NOTE: By default, SQL Server 2005 Express Edition does not allow
the
| remote
| | > connection. Please refer to the following KB article on how to
| configure it
| | > to allow the remote connection.
| |
| | > How to configure SQL Server 2005 to allow remote connections
| | > http://support.microsoft.com/kb/914277
| |
| | > Have a nice day!
| |
| | > Best regards,
| |
| | > Adams Qu
| | > MCSE, MCDBA, MCTS
| | > Microsoft Online Support
| |
| | > Microsoft Global Technical Support Center
| |
| | > Get Secure! - www.microsoft.com/security
| | > ================================================== ===
| | > When responding to posts, please "Reply to Group" via your
newsreader
| so
| | > that others may learn and benefit from your issue.
| | > ================================================== ===
| | > This posting is provided "AS IS" with no warranties, and confers
no
| rights.
| |
| |
| |
| | > --------------------
| | > | Thread-Topic: SQL Server 2000 & Access 2007 Project
| | > | thread-index: Ace9pOthpEoBhzyERoqjEWjCeIEi1w==
| | > | X-WBNR-Posting-Host: 207.46.19.168
| | > | From: =?Utf-8?B?SS4gS2luYWw=?= <ikinal (AT) myalias (DOT) postalias
| | > | References:
A6D68A9B-C7B4-4688-8D2B-5075288EA0DC...soft (DOT) com
| | > <U8XSOXIvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| | > <7A37D94D-DC74-41CE-8D5C-7C15F3252D67 (AT) microsoft (DOT) com
| | > <XXVeUQWvHHA.2220 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| | > | Subject: RE: SQL Server 2000 & Access 2007 Project
| | > | Date: Tue, 3 Jul 2007 12:04:02 -0700
| | > | Lines: 246
| | > | Message-ID: <3F8BC7C0-76DC-407D-9C5C-666BE32D227F (AT) microsoft (DOT) com
| | > | MIME-Version: 1.0
| | > | Content-Type: text/plain;
| | > | charset="Utf-8"
| | > | Content-Transfer-Encoding: 7bit
| | > | X-Newsreader: Microsoft CDO for Windows 2000
| | > | Content-Class: urn:content-classes:message
| | > | Importance: normal
| | > | Priority: normal
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| | > | Newsgroups: microsoft.public.sqlserver.clients
| | > | Path: TK2MSFTNGHUB02.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.sqlserver.clients:529
| | > | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| | > | X-Tomcat-NG: microsoft.public.sqlserver.clients
| | > |
| | > | Hi,
| | > |
| | > | I tried creating a new ADP and connecting it to my existing
database
| -
| | > this
| | > | produced the same error. I then tried creating a new database,
and
| | > | redirecting the ADP to the new database. Then, when I tried to
create
| a
| | > new
| | > | table in the new database, I immediately got a similar error -
| Microsoft
| | > | Office Access can't find the object table1.
| | > |
| | > | I checked and I found that the function fn_listextendedproperty
does
| | > exist
| | > | in my Master database.
| | > |
| | > | Thanks,
| | > | I. Kinal
| | > |
| | > | "Adams Qu [MSFT]" wrote:
| | > |
| | > | > Dear Kinal,
| | > |
| | > | > Thank you for your reply.
| | > |
| | > | > You have indicated that the Access database is an Access
Project
| file
| | > (ADP)
| | > | > and we are able to open the table's design view without a
problem
| via
| | > | > linking a table feature in normal database (MDF). But the
following
| | > error
| | > | > occurs when we attempt to open the same table's design view
in
the
| | > Access
| | > | > project:
| | > |
| | > | > Microsoft Office Access can't find the object 'Select *,
| | > | > sql_varient_property(value, 'basetype') as type from
| | > |
|
::fn_listextendedproperty(N'ms_displayviewsonshare pointsite',N'user',N'
| | > |
| | > | > If I have misunderstood the latest information you provided,
please
| let
| | > me
| | > | > know.
| | > |
| | > | > Based on the Book Online, this function is used to get the
extend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2000 & Access 2007 Project

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

RE: SQL Server 2000 & Access 2007 Project - 07-16-2007 , 09:20 AM