Frm based on Qry isnt working - How To Connect Multiple Users to Online SQL Server Databases Using Microsoft Access and Web ASP


	Back to Access SQL Server Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Frm based on Qry isnt working

JoAnn Brookover

3 years ago

I just finished the SQL Server class and I'm missing something with queries. I have an Entity form with subforms (ABCD). One of my subforms has a record source that is a query. It's worked fine until I put everything on the SQL Server. Now I can't add new records. There is also a subform on the subform and it works fine.

I have set the bits to not null, checked allow Additions/Deletions/Edits, and googled till I can't see straight. Can you point me to a class that will help me figure this out?

	Adam Schwanz @Reply 3 years ago
Are you getting any errors? Recordset not updateable? Does it let you add a record but then not save it?

JoAnn Brookover OP @Reply

3 years ago

No errors, can't type anything in the form, can't check boxes. I can change existing records, but not add new. It's just like in the security seminar when you lock out low level users so they can't change/add fields, I type and nothing happens. I have discovered that union queries don't work in SQL, so I think that is the problem. The record source for the form is a union query. Is there a workaround for that?

	Christopher Hankwembo @Reply 3 years ago
Golden rule: (1) Never ever base your forms on any native access object, but views (2) All calculations should never ever be done by access but views I went through that myself and I learnt a big learson

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access SQL Server Lessons.

Next Unseen

New Feature: Comment Live View