473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2000 ADP project

Mo
Hello all,

I'm trying to set up an access 2000 .adp project connecting to a SQL
server 2005 database. I can set up the connection ok, but once I have
completed the setup process, I get the following error messages if I try
to create any new database objects:

If I try to create a new object (a view or table etc), Access tells me
that I:

'do not have exclusive access to the database at this time. Your changes
will not be saved.'

If it's a view, I then get the following message (even though I'm using
SQL server 2005):

'The Visual Database Tools within Visual Studio 6 and Access 2000 do not
support some new features of SQL Server 2000. Because you are
manipulating an object in a SQL Server 2000 database, some operations
will be unavailable to you. In rare cases, you might not be able to save
the database object you modified. In other cases, you will be able to
save the object, but its previously existing settings for features new
to SQL Server 2000 will be lost. In most of these cases, you will be
warned if the Save operation will eliminate existing settings or
property values.

For a complete description of the interaction between SQL Server 2000
and Visual Database Tools within Visual Studio 6 or Access 2000, see
Microsoft Knowledge Base article Q266277, "Using Visual Studio 6 and
Access 2000 Visual Database Tools with SQL Server 2000." Knowledge Base
articles are available in the MSDN Library Visual Studio documentation
or at http://support.microsoft.com/support/.'

Finally, I get the following error.

'You are connected to a version of sql server newer than sql server
2000. save will be disabled'

Obviously I want to be able to create and save new objects.

Can anyone help? I've sone some searches on the MS support site, but
have not found anything that appears to be relevant.

Thanks,

Mo
Feb 16 '07 #1
5 2836
Mo <99**********@99qmul.ac.ukwrote in news:er4d6i$h3t$1@qmul:
Hello all,

I'm trying to set up an access 2000 .adp project connecting to a SQL
server 2005 database. I can set up the connection ok, but once I have
completed the setup process, I get the following error messages if I try
to create any new database objects:

If I try to create a new object (a view or table etc), Access tells me
that I:

'do not have exclusive access to the database at this time. Your changes
will not be saved.'

If it's a view, I then get the following message (even though I'm using
SQL server 2005):

'The Visual Database Tools within Visual Studio 6 and Access 2000 do not
support some new features of SQL Server 2000. Because you are
manipulating an object in a SQL Server 2000 database, some operations
will be unavailable to you. In rare cases, you might not be able to save
the database object you modified. In other cases, you will be able to
save the object, but its previously existing settings for features new
to SQL Server 2000 will be lost. In most of these cases, you will be
warned if the Save operation will eliminate existing settings or
property values.

For a complete descriptiloadon of the interaction between SQL Server 2000
and Visual Database Tools within Visual Studio 6 or Access 2000, see
Microsoft Knowledge Base article Q266277, "Using Visual Studio 6 and
Access 2000 Visual Database Tools with SQL Server 2000." Knowledge Base
articles are available in the MSDN Library Visual Studio documentation
or at http://support.microsoft.com/support/.'

Finally, I get the following error.

'You are connected to a version of sql server newer than sql server
2000. save will be disabled'

Obviously I want to be able to create and save new objects.

Can anyone help? I've sone some searches on the MS support site, but
have not found anything that appears to be relevant.

Thanks,

Mo
You could go to
http://msdn.microsoft.com/vstudio/express/sql/
and download
SQL Server Management Studio Express

TTBOMK this utility allows for the management of any recent version of SQL
Server, including 2000.

The interface is many times better than Access's.

I believe the objects you create in SSMSEE are entirely usable by Access,
but may not be visibile in the database window you expect.
Feb 16 '07 #2
Mo
You could go to
http://msdn.microsoft.com/vstudio/express/sql/
and download
SQL Server Management Studio Express

TTBOMK this utility allows for the management of any recent version of SQL
Server, including 2000.

The interface is many times better than Access's.

I believe the objects you create in SSMSEE are entirely usable by Access,
but may not be visibile in the database window you expect.
Thanks for the reply Lyle, but I'm afraid the solution has to be an
Access one.

Any other ideas?

Feb 16 '07 #3
"Mo" wrote
Thanks for the reply Lyle, but I'm afraid the
solution has to be an Access one.
Just an aside, as it always interests me when someone says "has to be" --
makes me wonder why it "has to be". I've run into very few situations
where, absent some physical reason (e.g., someone has suggested a solution
not supported by the software), a "has to be" was not an edict by some
autocratic manager who didn't know what they were about.

Of course, if that autocratic manager controls your continued employment, or
the size of your next raise, it could be unwise to argue -- but it's likely
the kind of situation that might better be dealt with by someone else, after
you have moved on to a different, better job or contract. You'll always
have a better chance at success where you are allowed to "do it right"
instead of "how the manager dictates".

So, can you tell us why " the solution has to be an Access one"? If you
can't, we will understand (and have a pretty good idea of what the situation
is, for that matter).

Larry
Feb 16 '07 #4
On Feb 16, 10:17 am, Mo <99m.a.joo...@99qmul.ac.ukwrote:
You could go to
http://msdn.microsoft.com/vstudio/express/sql/
and download
SQL Server Management Studio Express
TTBOMK this utility allows for the management of any recent version of SQL
Server, including 2000.
The interface is many times better than Access's.
I believe the objects you create in SSMSEE are entirely usable by Access,
but may not be visibile in the database window you expect.

Thanks for the reply Lyle, but I'm afraid the solution has to be an
Access one.

Any other ideas?
You might:

1. re-read my original reply;
2. create all your objects using CurrentProject.Connection, SQL
strings and VBA;
3. upgrade to Access 2003;
4. hire a professional;
5. give up.
Feb 16 '07 #5
On Fri, 16 Feb 2007 15:17:29 +0000, Mo <99**********@99qmul.ac.uk>
wrote:

You probably misunderstood Lyle, suggestion: we're not saying you
should build your solution using Sql Server 2005 Management Studio,
but you should administer your database in it, including creating the
views.
Access 2000 ADP is not forward compatible with SQL Server 2005, nor
should you expect it to.

-Tom.
<clip>
>
Thanks for the reply Lyle, but I'm afraid the solution has to be an
Access one.

Any other ideas?

Feb 17 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...
1
by: RichGolebiowski | last post by:
I have a class library (clsTestLib) that was created in VB.Net that I would like to use in Access 2000. I created a typelib for the class using regasm.exe. I am able to refernce (add a reference)...
1
by: Frank | last post by:
Aloha, I have a DB in Access 2000 consisting of about 1500 lines of code and 65 tables, 95 queries and 60 forms and want to "merge" with another persons program written in Access 2 with about the...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
35
by: deko | last post by:
Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 =...
9
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
5
by: Ecohouse | last post by:
I'm using VB and an Access 2003. The db was originally created in Access 2000, but the computer had to have things reinstalled and now has Access 2003. So I was wondering if there are any...
2
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.