Now THAT is marketable service. I wish you'd contact our corporate IT and help out the help desk system there… J
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, February 08, 2016 2:45 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Re: sql back end with access back ends
Sounds like a lot of fun, Liz. It's been ages since I worked on an Access application. I think the last one I created was an application that houses information about all the applications we have in-house (about 250), their servers, vendors, contacts such as owners, super users, server patch groups, troubleshooting, and a whole lot more. All this info used to be on spreadsheets, Word docs, in people's heads.
Now I just maintain what I've built and do my other job as a DBA. Two positions, same old pay for one.
Regards,
Bill Mosca
From: "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, February 8, 2016 1:07:36 PM
Subject: RE: [MS_AccessPros] Re: sql back end with access back ends
Bill, it looks like I could. It's just that the tables linking to other back ends are of 1. Another access database back end with its own respective front end and 2. Shared database tables with multiple front ends. I have a bit of a web here with interlinking databases. My own little kingdom I suppose. This last little database is going to do paperless work orders and only allow clock ins by authorized personnel as determined by code from a training database. Giggle. Cool thing there. J
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, February 08, 2016 1:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: sql back end with access back ends
Liz - Can't you migrate more tables once you have a converted back end? I' haven't used the MA in quite a while and I can't remember if it gives you the option to choose an existing DB or not.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Actually, never mind. In my flawed thinking I realized that I have to do additional work. If the issue is going to be several hundreds of users on at the same time, then the same would go for the links to the other back ends. Those in turn would also need to be migrated to sql server. I need to think this through better. I'm glad I have time on my side.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, February 08, 2016 10:38 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] sql back end with access back ends
Bill, you gave me a link to the SQL server migration assistant and I've downloaded it and installed it. I have this database link to more than one access back end, but I'd prefer to have one sql back end and other access back ends. Is this doable?
Thanks.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
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.
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.
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.
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>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar