Senin, 08 Februari 2016

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.

__._,_.___

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 (4)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar