By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Access 2000 ADP project

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
"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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.