Liz,
Thanks for the link.
Duane
On August 20, 2018, at 6:55 PM, "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
I found an answer:
https://answers.microsoft.com/en-us/office/forum/office_2007-access/access-2007-database-template-feature-add-from/8824f531-c475-e011-8dfc-68b599b31bf5
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 9:21 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: Contacts DB with multiple users
Thanks Duane, answers below.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 9:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
So the key issue is "when someone is in, they get errors saying that there is already someone in and they don't have access to do anything". Correct. They cannot make changes to the data.
Does this only happen when attempting to do "add from outlook" functionality or are there issues updating other tables? - It's a simple db with the one table.
Does your code compile? Yes.
Are there any missing references? No.
Does the code work with an ACCDB format? Yes.
Have you attempted to step through your code to see which line creates the error? It's in the managed code, so I don't have access to that.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:49 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: Contacts DB with multiple users
Thanks Duane,
I have a portal here that essentially copies the accde file out to the user's H: drive and runs the database from there. My standard is to have the split db's.
It's a non-essential piece of information, really.
The real deal is that Access with this Outlook doesn't work when I split the database. Whether I have it on a portal or not.
Sorry I confused the issue.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:8e1942ff-c863-4cbf-8649-97f91798b011]
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 8:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
Can you explain "on our portal"? Access behaves well on networks and some other environments but is worthless in others. I would not expect Access to perform well (if at all) with the back-end on OneDrive or as a file in SharePoint.
There are some possible solutions that involve SQL server in the cloud etc but my knowledge of those is Null.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Contacts DB with multiple users
Pros, I've inherited a contacts database which someone built from a template, so of course there is a lot of managed code.
I was instructed to put it out on our portal, so I split the front end from the back, and put the front end at the portal. The "add from outlook" functionality quit, so I rejoined it. The user base wants this to be multi-user, but when someone is in, they get errors saying that there is already someone in and they don't have access to do anything.
Does anyone have any experience and/or knowledge with this type of database?
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:5b053bb4-1cdb-4cef-b899-ed409477b765]
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
[http://upload.wikimedia.org/wikipedia/en/4/46/Rockwell_Collins_logo.png]<http://www.rockwellcollins.com/>
Rockwell Collins - Building trust every day<http://www.rockwellcollins.com/>
www.rockwellcollins.com<http://www.rockwellcollins.com>
At Rockwell Collins, our innovative solutions for aviation, defense, rail and critical infrastructure help us keep people safe, connected and informed. Through long-time industry leadership and an unwavering commitment to work with our customers to understand and achieve their goals, we strive to be the most trusted source of aviation and high ...
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
https://answers.microsoft.com/en-us/office/forum/office_2007-access/access-2007-database-template-feature-add-from/8824f531-c475-e011-8dfc-68b599b31bf5
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 9:21 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: Contacts DB with multiple users
Thanks Duane, answers below.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 9:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
So the key issue is "when someone is in, they get errors saying that there is already someone in and they don't have access to do anything". Correct. They cannot make changes to the data.
Does this only happen when attempting to do "add from outlook" functionality or are there issues updating other tables? - It's a simple db with the one table.
Does your code compile? Yes.
Are there any missing references? No.
Does the code work with an ACCDB format? Yes.
Have you attempted to step through your code to see which line creates the error? It's in the managed code, so I don't have access to that.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:49 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: Contacts DB with multiple users
Thanks Duane,
I have a portal here that essentially copies the accde file out to the user's H: drive and runs the database from there. My standard is to have the split db's.
It's a non-essential piece of information, really.
The real deal is that Access with this Outlook doesn't work when I split the database. Whether I have it on a portal or not.
Sorry I confused the issue.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:8e1942ff-c863-4cbf-8649-97f91798b011]
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 8:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
Can you explain "on our portal"? Access behaves well on networks and some other environments but is worthless in others. I would not expect Access to perform well (if at all) with the back-end on OneDrive or as a file in SharePoint.
There are some possible solutions that involve SQL server in the cloud etc but my knowledge of those is Null.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Contacts DB with multiple users
Pros, I've inherited a contacts database which someone built from a template, so of course there is a lot of managed code.
I was instructed to put it out on our portal, so I split the front end from the back, and put the front end at the portal. The "add from outlook" functionality quit, so I rejoined it. The user base wants this to be multi-user, but when someone is in, they get errors saying that there is already someone in and they don't have access to do anything.
Does anyone have any experience and/or knowledge with this type of database?
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:5b053bb4-1cdb-4cef-b899-ed409477b765]
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
[http://upload.wikimedia.org/wikipedia/en/4/46/Rockwell_Collins_logo.png]<http://www.rockwellcollins.com/>
Rockwell Collins - Building trust every day<http://www.rockwellcollins.com/>
www.rockwellcollins.com<http://www.rockwellcollins.com>
At Rockwell Collins, our innovative solutions for aviation, defense, rail and critical infrastructure help us keep people safe, connected and informed. Through long-time industry leadership and an unwavering commitment to work with our customers to understand and achieve their goals, we strive to be the most trusted source of aviation and high ...
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPONSORED LINKS
.
__,_._,___
![http://upload.wikimedia.org/wikipedia/en/4/46/Rockwell_Collins_logo.png]<http://www.rockwellcollins.com/](http://upload.wikimedia.org/wikipedia/en/4/46/Rockwell_Collins_logo.png]<http://www.rockwellcollins.com/){kind=link}
Tidak ada komentar:
Posting Komentar