Hi,
I have two, similar SQL Server 7.0 databases (in the same SQL Server
Group) that I use as the backend for two Access 2000 front end
applications - one is the live version, the other is the development
version.
The live version works fine. But the other version is read-only, i.e.
no changes can be made to the data in the tables, over the ODBC
connection.
Both systems have similar ODBC connection properties, the permission
settings on the SQL Server databases are the same - users, table
access, database access, etc. The connections use Windows
authenication and the users are set up in SQL Server security logins
with public and db_owner selected.
Has anyone seen or heard of this problem and does anyone have any
ideas on how to fix it?
I appreciate any comments or suggestions you may have.
Thanks,
Chris
3  6099 
Does the read-only version have primary keys defined for all of the tables?
They'll be read-only unless they do.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Chris" <ch***********@ yahoo.co.uk> wrote in message
news:63******** *************** **@posting.goog le.com... Hi,
I have two, similar SQL Server 7.0 databases (in the same SQL Server
Group) that I use as the backend for two Access 2000 front end
applications - one is the live version, the other is the development
version.
The live version works fine. But the other version is read-only, i.e.
no changes can be made to the data in the tables, over the ODBC
connection.
Both systems have similar ODBC connection properties, the permission
settings on the SQL Server databases are the same - users, table
access, database access, etc. The connections use Windows
authenication and the users are set up in SQL Server security logins
with public and db_owner selected.
Has anyone seen or heard of this problem and does anyone have any
ideas on how to fix it?
I appreciate any comments or suggestions you may have.
Thanks,
Chris
Thanks very much. That was the exact problem (and solution).
Chris
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message news:<1e******* *************@r ogers.com>... Does the read-only version have primary keys defined for all of the tables?
They'll be read-only unless they do.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Chris" <ch***********@ yahoo.co.uk> wrote in message
news:63******** *************** **@posting.goog le.com... Hi,
I have two, similar SQL Server 7.0 databases (in the same SQL Server
Group) that I use as the backend for two Access 2000 front end
applications - one is the live version, the other is the development
version.
The live version works fine. But the other version is read-only, i.e.
no changes can be made to the data in the tables, over the ODBC
connection.
Both systems have similar ODBC connection properties, the permission
settings on the SQL Server databases are the same - users, table
access, database access, etc. The connections use Windows
authenication and the users are set up in SQL Server security logins
with public and db_owner selected.
Has anyone seen or heard of this problem and does anyone have any
ideas on how to fix it?
I appreciate any comments or suggestions you may have.
Thanks,
Chris
Hello Douglas
Can you please elaborate about this problem? i havent encountered
this problem which eventually came to my observation only after your
reply. Is it due to design considerations of a database?
Regards
Debashish
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: tolisss |
last post by:
Hi
i have created a new database and a new linked server that points to an
AccessDB using an ODBC DSN.
Now inside that new sql db i have create i need to created a new view so
i open EM went to views and paste the following
select * from openquery (AccessLinkedServer,'select * from mytable')
i press run and i see the data ok .but when...
|
by: hipo |
last post by:
Hi:
I'm trying to read data from Navision 2.60 ERP with own database to a
SQL Server 2000 database via ODBC. All is working except just one
thing, how to filter data with a date field.
I have some big tables that have a date field and I just want to read
data from one or few days, not all the table, cos I will be doing this
every day...
|
by: Kona |
last post by:
Hello, I would like to access a UDB database on a Sun Solaris 5.8.
The client is a XP station.
When I list the default odbc drivers, I found "Microsoft ODBC Driver for DB2".
But I think it can not be used to access a UDB DB on Unix machine.
So where can I find a ODBC driver ?
Thank you
|
by: Amanda |
last post by:
From a guy in Microsoft newsgroups:
| In *comp.databases.ibm-db2* there are always IBM guys
| from the Toronto labs on line.Post with the
| -for the love of god please help-
| line and I'm sure you'll get their attention.
| Their usually very good:)
So here's my transplanted post
==========================================
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
| | |
by: Mark B |
last post by:
We have an Access app (quite big) at www.orbisoft.com/download.
We have had requests by potential users to have it converted to an SQL
version for them since there corporate policy excludes them from buying mdb
backends.
Here's the (million dollar?) questions :)
How long and how difficult a process would it be?
Which SQL platform would...
|
by: gege |
last post by:
Hi everyone,
I'm looking for a C++ ODBC class.
Could anybody give me some references ?
Thx a lot !
gg
ps:
- I'm working with MSVC
|
by: chloe.crowder |
last post by:
Hi
We're trying to use call a stored procedure to update information in a
remote Ingres database. We've linked the server, and can read
information using SELECT * FROM OPENQUERY (..........), but we can't
find a suitable syntax for executing a procedure.
Using SELECT * FROM OPENQUERY and passing the EXEC statement in a
string gives a...
|
by: xx75vulcan |
last post by:
Hi,
I have two seperate production machines that I'm trying to get to play
nicely together.
This setup has worked for years before - until recently bother
machines were reformatted, and reinstalled fresh. I know I'm missing a
simple setting here somewhere...
I have a Win 2003 IIS 6.0 box running as web server, and a Win 2003
IIS 6.0 box...
|
by: alexbf |
last post by:
Hello,
I have a stored procedure in SQL Server 2000.
When I execute it through my .NET application (OleDbCommand), I can
see (in SQL Profiler) that it takes 423 ms to complete.
If I run the same exact query in Query Analyzer, it takes 216 ms (in
SQL Profiler).
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
