RE: SQL Server 2000 & Access 2007 Project

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@xxxxxxxxxxxxx>
<U8XSOXIvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
<7A37D94D-DC74-41CE-8D5C-7C15F3252D67@xxxxxxxxxxxxx>
<XXVeUQWvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
<3F8BC7C0-76DC-407D-9C5C-666BE32D227F@xxxxxxxxxxxxx>
<rE14RIfvHHA.3972@xxxxxxxxxxxxxxxxxxxxxx>
<1736DCCC-46E6-4DDA-9E89-31ED144C8B5B@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (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@xxxxxxxxxxxxxxxxxxxxxx>
| 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@xxxxxxxxxxxxxxxxx>
| | References: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC@xxxxxxxxxxxxx>
| <U8XSOXIvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
| <7A37D94D-DC74-41CE-8D5C-7C15F3252D67@xxxxxxxxxxxxx>
| <XXVeUQWvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
| <3F8BC7C0-76DC-407D-9C5C-666BE32D227F@xxxxxxxxxxxxx>
| <rE14RIfvHHA.3972@xxxxxxxxxxxxxxxxxxxxxx>
| | 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@xxxxxxxxxxxxx>
| | 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/details.aspx?FamilyID=220549b5-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@xxxxxxxxxxxxxxxxx>
| | > | References: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC@xxxxxxxxxxxxx>
| | > <U8XSOXIvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
| | > <7A37D94D-DC74-41CE-8D5C-7C15F3252D67@xxxxxxxxxxxxx>
| | > <XXVeUQWvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
| | > | 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@xxxxxxxxxxxxx>
| | > | 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_displayviewsonsharepointsite',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
| | > property
| | > | > of the database and this function may be called by the Access
| program
| | > when
| | > | > we open in the design view so as to get the relevant data type.
| | > | >
| | > | > However, I have conducted much test on my test machine (connect
| Access
| | > 2007
| | > | > to SQL Server 2000 database) but cannot reproduce such behavior.
| | > According
| | > | > to the error message, I suspect that the function returns the
blank
| | > value
| | > | > so that SQL server cannot get the type of the data in the design
| view.
| | > We
| | > | > can try to run this SQL statement on the SQL Server 2000 Query
| Analyzer
| | > to
| | > | > check if what result is returned or just a blank result.
| | > | >
| | > | > In addition, as you have previously attempted to link a table in
| SQL
| | > Server
| | > | > 2000 in the newly created database, I also suggest we create a
new
| ADP
| | > file
| | > | > in Access 2007 and then point it to the SQL Server 2000 to check
if
| the
| | > | > issue also occurs in that newly created ADP file.
| | > | >
| | > | > 1. If the issue does not occur to the new ADP file, we can simply
| use
| | > this
| | > | > newly created ADP file in the further. We can conclude that the
| issue
| | > is
| | > | > caused by the connection parameter and the issue is resolved
after
| we
| | > | > create a new file and rebuild the connection.
| | > | >
| | > | > 2. However, if the issue still persists in the new ADP file,
please
| try
| | > to
| | > | > modify the connection and make it connect to the other database
| such as
| | > | > Northwind or the newly created database to test if the issue is
| related
| | > to
| | > | > database specified.
| | > | >
| | > | > 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: Ace88YvnqYb7qk9cTde3IyKmkc88lQ==
| | > | > | X-WBNR-Posting-Host: 207.46.19.168
| | > | > | From: =?Utf-8?B?SS4gS2luYWw=?= <ikinal@xxxxxxxxxxxxxxxxx>
| | > | > | References:
<A6D68A9B-C7B4-4688-8D2B-5075288EA0DC@xxxxxxxxxxxxx>
| | > | > <U8XSOXIvHHA.2220@xxxxxxxxxxxxxxxxxxxxxx>
| | > | > | Subject: RE: SQL Server 2000 & Access 2007 Project
| | > | > | Date: Mon, 2 Jul 2007 14:40:02 -0700
| | > | > | Lines: 118
| | > | > | Message-ID: <7A37D94D-DC74-41CE-8D5C-7C15F3252D67@xxxxxxxxxxxxx>
| | > | > | 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:527
| | > | > | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| | > | > | X-Tomcat-NG: microsoft.public.sqlserver.clients
| | > | > |
| | > | > | Hi,
| | > | > |
| | > | > | Thank you for your response.
| | > | > |
| | > | > | The Access database in questions is an Access Project file. I
| tried
| | > your
| | > | > | suggestion of creating a new, normal database and linking a
table
| | > from
| | > | > the
| | > | > | SQL Server - I was able to open the table's design view without
a
| | > | > problem.
| | > | > |
| | > | > | Here is the beginning of the error that I get when trying 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_displayviewsonsharepointsite',N'user',N'
| | > | > |
| | > | > | Is it looking for that function? Why??
| | > | > |
| | > | > | Thanks,
| | > | > | I. Kinal
| | > | > |
| | > | > | "Adams Qu [MSFT]" wrote:
| | > | > |
| | > | > | > Dear Kinal,
| | > | > | >
| | > | > | > Thank you for posting here.
| | > | > | >
| | > | > | > From the problem description of the post you submitted, my
| | > | > understanding
| | > | > | > is: the error message "Object does not exists" will be
received
| if
| | > we
| | > | > open
| | > | > | > query or table in Design View after upgrading to Access 2007.
| If I
| | > have
| | > | > | > misunderstood about your concern, feel free to let me know.
| | > | > | >
| | > | > | > Before going further, I would like to explain that Office
| Access
| | > offers
| | > | > two
| | > | > | > ways to connect to SQL Server data: linking to SQL Server and
| | > Access
| | > | > Data
| | > | > | > Projects (ADPs). In order to ensure the current status,
please
| | > first
| | > | > | > confirm with me the way to connect to SQL Server is MDB or
ADP.
| | > | > | >
| | > | > | > Thank you for taking time to help me check above information.
| | > | > | >
| | > | > | > At the same time, to isolate the cause of the issue, it is
| | > recommended
| | > | > that
| | > | > | > we create a new Access 2007 database and then link table to
the
| SQL
| | > | > Server
| | > | > | > 2000 to check if issue still occurs in this newly created
| Access
| | > file.
| | > | > I
| | > | > | > have included the summary of the steps for you:
| | > | > | >
| | > | > | > 1. Create a new Access 2007 Database
| | > | > | > 2. Linking to SQL Server
| | > | > | > 3. Open anyone of the table in the Design Mode and then check
| if
| | > the
| | > | > issue
| | > | > | > still persists in this newly created table.
| | > | > | >
| | > | > | > Related Information
| | > | > | > ===================
| | > | > | > Migration considerations for Access 2007
| | > | > | >
| | > | >
| | >
|
http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a-8ff2-2
| | > | > | > 21769a58ba51033.mspx?mfr=true
| | > | > | >
| | > | > | > If anything is unclear in my post, please don't hesitate to
let
| me
| | > know
| | > | > and
| | > | > | > I will be glad to help. Thank you for your efforts and time.
| | > | > | >
| | > | > | > 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
| |
|
|

.

Loading