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

SQL Query the base for an Access Form

P: 82
Hi,

Access FE and SQL Server BE. I built a view using 3 tables and then created a form. I can't input any data onto it. Does anyone have any ideas on what I should do? thanks.
Jul 2 '13 #1

✓ answered by Rabbit

There are restrictions when trying to modify data through a view. You can read about those restrictions from the Microsoft documentation here: http://msdn.microsoft.com/en-us/libr...v=sql.90).aspx.

You really shouldn't be doing it that way anyways. You should edit each table separately anyways, you don't know how the joins are going to affect the data that is being updated.

Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,430
There are restrictions when trying to modify data through a view. You can read about those restrictions from the Microsoft documentation here: http://msdn.microsoft.com/en-us/libr...v=sql.90).aspx.

You really shouldn't be doing it that way anyways. You should edit each table separately anyways, you don't know how the joins are going to affect the data that is being updated.
Jul 2 '13 #2

P: 82
Thanks. I was doing it that way so one of my end users couldn't do her usual tricks. I'll rethink how to deal with her and build the form from the table. As always, you come through.
Jul 2 '13 #3

Rabbit
Expert Mod 10K+
P: 12,430
If you make a new thread about what "tricks" you want to code against, I'm sure some of us can come up with a solution for you.
Jul 2 '13 #4

ck9663
Expert 2.5K+
P: 2,878
If you can also create an updateable view. Once the user click the update, you handle all updates internally on your back-end.

Good Luck!!!


~~ CK
Jul 3 '13 #5

Post your reply

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