Senin, 08 Februari 2016

RE: [MS_AccessPros] Re: sql back end with access back ends

 

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:

Poskan Komentar