473,327 Members | 1,997 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,327 software developers and data experts.

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

Seth Schrock
2,965 Expert 2GB
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 1171
Seth Schrock
2,965 Expert 2GB
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 Expert 2GB
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
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
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
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
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
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
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
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
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
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
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
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.