Sorry for the delay in answering – I was out of town for a few days.
Brian,
I think your question is the 64,000 dollar one.
Bill,
I don’t understand why you need the “make table” SQL statement. I am joining tables not creating a new one from the tables
Marybeth
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 21, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Digest Number 9100
5 Messages
Digest #9100
Re: Problem with SQL backend access frontend using table source as v by "Brian Battles" brianbattlesws1o
1b
Re: Problem with SQL backend access frontend using table source as v by "Marybeth S Tomka" mstomka
1c
Re: Problem with SQL backend access frontend using table source as v by wrmosca
2a
Messages
1a
Re: Problem with SQL backend access frontend using table source as v
Wed Jun 20, 2018 7:05 am (PDT) . Posted by:
"Brian Battles" brianbattlesws1o
Have you got the proper primary keys and indexes defined in your new back-end SQL Server tables?
Brian Battles WS1O
954 High Path Rd
Windsor, CT 06095 USA
860-707-7021
Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^
1b
Re: Problem with SQL backend access frontend using table source as v
Wed Jun 20, 2018 7:38 am (PDT) . Posted by:
"Marybeth S Tomka" mstomka
Morning,
Follow up on my posting from yesterday. I create a unique constraint on the field that I am trying to link the tables with and now I get a message about foreign key violates "alter table" functions. Really could use some help here.
Marybeth
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, June 20, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Digest Number 9099
[Yahoo! Groups]<https://groups..yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5>
MS Access Professionals Group <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJkY3QyNnNtBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNoZHIEc2xrA2hwaARzdGltZQMxNTI5NDg3MDk5>
1 Message
Digest #9099
1
Problem with SQL backend access frontend using table source as value by "Marybeth S Tomka" mstomka
Message
1
Problem with SQL backend access frontend using table source as value <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/117651;_ylc=X3oDMTJzZmw2ajdnBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxNTI5NDg3MDk5>
Tue Jun 19, 2018 11:15 am (PDT) . Posted by:
"Marybeth S Tomka" mstomka <mailto:marybeth.tomka@austin.utexas.edu?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value>
Good afternoon, I really hope you all can help me resolve an issue I am having. I recently migrated an access database to a SQL backend and an access front end. In the original access database I had a form with a subform that calculates the costing for a service. Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table. Now I can't add records through the subform or the main form with the subform activated. I think it must have something to do with the relationship between the tables, but I can't get them to be a one-to-many and I have tried all the usual suspects for error trapping. What is a not so obvious reason for not linking correctly?
Marybeth
Reply to sender <mailto:marybeth.tomka@austin.utexas.edu?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value> . Reply to group <mailto:MS_Access_Professionals@yahoogroups.com?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value> . Reply via Web Post <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/messages/117651;_ylc=X3oDMTJzNjJsbWp1BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxNTI5NDg3MDk5?act=reply&messageNum=117651> . All Messages (1) <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/117651;_ylc=X3oDMTM5b3EwYmRvBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxNTI5NDg3MDk5BHRwY0lkAzExNzY1MQ--> . Top ^
Visit Your Group<https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJlbWZsbzJsBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTUyOTQ4NzA5OQ-->
[Yahoo! Groups]<https://groups.yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5>
* Privacy<https://info.yahoo.com/privacy/us/yahoo/groups/details.html> * Unsubscribe<mailto:MS_Access_Professionals-unsubscribe@yahoogroups.com?subject=Unsubscribe> * Terms of Use<https://info.yahoo.com/legal/us/yahoo/utos/terms/>
Marybeth
Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^
1c
Re: Problem with SQL backend access frontend using table source as v
Wed Jun 20, 2018 11:34 am (PDT) . Posted by:
wrmosca
Using the SQL Server management studio, right-click on the table and select Script>Create Table>New query window. Copy and paste the "Make Table" SQL here so we can see what the script is doing to make the table.
FYI - You might want to remove all your contact info in your email signature to prevent spammers from getting it.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
http://wrmosca.wordpress.com http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <marybeth.tomka@austin.utexas.edu> wrote :
Morning,
Follow up on my posting from yesterday. I create a unique constraint on the field that I am trying to link the tables with and now I get a message about foreign key violates “alter table” functions. Really could use some help here.
Marybeth
Marybeth S. F. Tomka, M.A., PS Cert CM
State Certified Repository
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, June 20, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com mailto:MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Digest Number 9099
https://groups.yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5
MS Access Professionals Group
1 Message Digest #9099
1
Problem with SQL backend access frontend using table source as value by "Marybeth S Tomka" mstomka
Message 1 Problem with SQL backend access frontend using table source as value Tue Jun 19, 2018 11:15 am (PDT) . Posted by: "Marybeth S Tomka" mstomka Good afternoon, I really hope you all can help me resolve an issue I am having. I recently migrated an access database to a SQL backend and an access front end. In the original access database I had a form with a subform that calculates the costing for a service. Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table. Now I can't add records through the subform or the main form with the subform activated. I think it must have something to do with the relationship between the tables, but I can't get them to be a one-to-many and I have tried all the usual suspects for error trapping. What is a not so obvious reason for not linking correctly?
Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar