|
|
Access --> SQL 2000 (Read only)
I converted an Access 2003 Database to run on SQL 2000. However, it is
apparent that the database is being opened in exclusive mode by the first
user.
I know how to resolve this when the back-end is also Access 2003 but how do
I resolve this as it is on SQL 2000.
|
|
0
|
|
|
|
Reply
|
 Utf
|
11/9/2005 7:20:57 PM |
|
You've got an Access front-end talking to a SQL Server backend. Each user
should have his/her own copy of the front-end, preferably on their hard
drive.
Now, your subject mentions Read only, as opposed to exclusive. If the
problem actually is read-only, do you have primary keys defined for each of
the tables in SQL Server.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Charlo" <Charlo@discussions.microsoft.com> wrote in message
news:9537A568-58A1-4F3A-84D5-92348FA2C4EF@microsoft.com...
>I converted an Access 2003 Database to run on SQL 2000. However, it is
> apparent that the database is being opened in exclusive mode by the first
> user.
> I know how to resolve this when the back-end is also Access 2003 but how
> do
> I resolve this as it is on SQL 2000.
|
|
|
0
|
|
|
|
Reply
|
Douglas
|
11/9/2005 11:04:39 PM
|
|
In addition to Doug's suggestions, can you confirm that the permissions have
been properly set on the SQL Server back-end?
Regards
Jeff Boyce
<Office/Access MVP>
"Charlo" <Charlo@discussions.microsoft.com> wrote in message
news:9537A568-58A1-4F3A-84D5-92348FA2C4EF@microsoft.com...
>I converted an Access 2003 Database to run on SQL 2000. However, it is
> apparent that the database is being opened in exclusive mode by the first
> user.
> I know how to resolve this when the back-end is also Access 2003 but how
> do
> I resolve this as it is on SQL 2000.
|
|
|
0
|
|
|
|
Reply
|
Jeff
|
11/10/2005 12:34:54 AM
|
|
|
2 Replies
213 Views
(page loaded in 0.039 seconds)
Similiar Articles: Access --> SQL 2000 (Read only) - microsoft.public.access ...I converted an Access 2003 Database to run on SQL 2000. However, it is apparent that the database is being opened in exclusive mode by the first us... SQL Server Backend is Read Only - microsoft.public.access ...Access --> SQL 2000 (Read only) - microsoft.public.access ... You've got an Access front-end talking to a SQL Server backend. Each user should have his/her own copy of the ... How to use text filter in Access with SQL Server database ...How to use text filter in Access with SQL Server database ... Access --> SQL 2000 (Read only) - microsoft.public.access ... How to use text filter in Access with SQL ... Force "read only" in Connection String??? - microsoft ...Is it possible to force "Read Only" access (in Access 2007) when connecting to a SQL Server database? We are planning to use the Reporting facili... Access 2007 opens read only - microsoft.public.accessDatabase opens in Read Only mode - microsoft.public.access ... Access 2007 open mdb (2000) file read-only file in read-only mode, which ... SQL Server Backend is Read Only ... Datatype BIT problem with Access front-end AND SQL back-end ...Access --> SQL 2000 (Read only) - microsoft.public.access ... Access front-end and SQL Server back-end table lock - microsoft ... Access --> SQL 2000 (Read ... Problem accessing SQL server 2008 job history - microsoft.public ...Access --> SQL 2000 (Read only) - microsoft.public.access ... Datatype BIT problem with Access front-end AND SQL ... have an SQL 2000 server. I am managing it with SQL ... Shared Access DB is Locked in Exclusive Mode - microsoft.public ...Database opens in Read Only mode - microsoft.public.access ... Open DB not exclusive mode - microsoft.public.access Database opens ... the same time it is locked in read ... How to change an access database from read-only? - microsoft ...Database is read-only. SQL Server Data Access http ... MDF" because the database is read-only ... can manage to change that. The ASP.NET read only erro on publishing a sql ... Linked Tables "Read Only"? - microsoft.public.access ...... Linked Tables "Read Only"? - microsoft.public.access ... I am linking to tables in an existing database and want to safeguard ... Read Only SQL Server Tables in Access ... Read only access to a SQL Server 2000 database: sql, read, only ...We are currently using SQL server 2000 and one of our accounts guys has a script he needs to run that will access the database. He advses he only needs ... Read Only access to a SQL Database? Best way?... the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 ... Home > IT Answers > SQL Server > Read Only access to a SQL Database? Best ... Access --> SQL 2000 (Read only) - microsoft.public.access ...I converted an Access 2003 Database to run on SQL 2000. However, it is apparent that the database is being opened in exclusive mode by the first us... SQL 2000 Read only mode: sql, only, read, mode, 2000can a sql database be open in read only mode? Can users ... Keywords: SQL, 2000, Read, only, mode. Locked mode; DSN connection to an access databas SQL Server and Read-Only Databases - SQLTeam.comBy Chris Miller on 5 July 2000 | 4 Comments | Tags: Administration ... If you've got a read only database, mark it read-only in SQL Server. If you do that, then SQL Server ... 7/10/2012 7:38:13 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
5 followers. 