RE: SQL Server 2000 & Access 2007 Project

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
=====================================================
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: Ace7cIjBHI5h7+CTSvCZ5a4VviUIdA==
| X-WBNR-Posting-Host: 207.46.19.197
| From: =?Utf-8?B?SS4gS2luYWw=?= <ikinal@xxxxxxxxxxxxxxxxx>
| Subject: SQL Server 2000 & Access 2007 Project
| Date: Sat, 30 Jun 2007 16:44:00 -0700
| Lines: 14
| Message-ID: <A6D68A9B-C7B4-4688-8D2B-5075288EA0DC@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:522
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.sqlserver.clients
|
| Hi,
|
| I use an Access Project as a front end for my database, which is in SQL
| Server 2000. Everything is working fine in Access 2003. However, I just
| upgraded one machine to Access 2007, and now Access cannot open any query
or
| table in design view - I get an error saying that the object does not
exist.
| This error will either reference the query or table by name, or will
| reference a cryptic SQL Statement that mentions Sharepoint. However, I
can
| view the results of the query or contents of the table just fine. Is
there
| something that I need to do in the database for it to open in Access
2007? Or
| is the only solution an upgrade to SQL Server 2005?
|
| Thanks,
| I. Kinal
|


.

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
Loading