473,499 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2010 linked to SQL Server View won't allow additions

Seth Schrock
2,965 Recognized Expert Specialist
I have a database that I have created the FE in Access and the BE in SQL Server. All of my tables in SQL server are working fine. However, I have also linked to some Views SQL server and those don't allow me to add new records. Is there something in the connection between Access and SQL Server that blocks new records be written to Views? I can run an INSERT query in SSMS just fine to the view. I'm using a DSN-Less connection, if that makes any difference.
Jul 21 '14 #1
2 1175
Seth Schrock
2,965 Recognized Expert Specialist
Evidently, the DSN-Less connection has something to do with it. I just created a system DSN and linked to the view and I can add records to that "table". Is there something that I need to put into my connection string or a property of the table that I need to set to allow my DSN-Less connection to work for views?
Jul 21 '14 #2
Seth Schrock
2,965 Recognized Expert Specialist
It was the index that I needed to create. Once I created a unique index on the table's PK field, I was able to add new records.
Jul 21 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
4493
by: Sudhesh Nayak | last post by:
Hi, I have an Oracle (8.1) & a SQL Server 2000 database with Production data. There are situations when I need data from both the databases. My first choice was to link Oracle to SQL and run DTS...
1
4291
by: simonfunston | last post by:
Hi there, I'm pretty new to SQL and am having some porblems with a linked server. I have a table on a SQL server which stores employee information. I also have a view on a linked server which...
1
1709
by: js | last post by:
I am using SQL Server 2000. I am getting the following error when executing the following query. The query joins a view .dbx.dbo.vwreports that resides on a linked server. I can sort on fields...
3
1967
by: J. Thompson | last post by:
I have an Access application linked to a SQL Server 2000 database using ODBC. Call this database/server pair DB1 Part of the app needs to link to another local 2000 server to get data from...
6
3170
by: Cro | last post by:
Dear Access Developers, The 'Allow Additions' property of my form is causing unexpected results. I am developing a form that has its 'Default View' property set to 'Continuous Forms' and am...
0
1021
by: Joep | last post by:
Hi all, In an Access 2003 db I have a linked table to a SQL Server view. This view is based on a SQL Server table with a column defined as NUMERIC(4,2). When I create an Access linked table...
1
1606
by: Danny | last post by:
Is there a certain way of adding users to access a linked server? I linked to an Oracle server but somehow, I'm unable to add any users, even after trying in EM. It'll allow me to select the local...
1
3663
by: BillCo | last post by:
There seems to be a lot of confusion around the groups about linking to an Access mdb with the SQL Server Jet OLE DB provider and I havent been able to find a straight forward solution. Basically,...
0
1131
by: dordali | last post by:
Have a question. I have a table e.g. "Table1" on DB1 that is going to be archived once a month to "ArchiveTable1" on DB2, both on the one server. Will have to change SPs that were accessing...
4
31360
by: jbrumbau | last post by:
Hello, In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolbar "Ribbon", acToolbarNo) or even the...
0
7134
marktang
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,...
0
7012
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...
0
7225
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6901
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...
0
7392
tracyyun
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...
0
3105
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3101
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1429
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 ...
0
307
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.