Senin, 10 Februari 2014

RE: [MS_AccessPros] 2 gb max / sql server

 

Thanks Gina!

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Gina Whipp
Sent: Monday, February 10, 2014 7:23 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] 2 gb max / sql server

 




Liz Ravenwood,

 

Have a look at...

 

So you’re ready to upsize

http://regina-whipp.com/blog/?p=371

 

You’ll want to make sure your tables are somewhat *clean* before moving to SQL Server.

 

 

Gina Whipp
Microsoft MVP (Access)

www.access-diva.com

Specializing in Microsoft© Access® Solutions

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Monday, February 10, 2014 8:58 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] 2 gb max / sql server

 

 

So instead of splitting in to a front end and a back end a la access, I split to a front end and upload the tables to the sql server and then only have the links in the front end, right?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, February 10, 2014 6:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] 2 gb max / sql server

 



Nope, not for the tables.  You still have a 2gb limit for the size of the front end containing your queries, forms, reports, and code.

 

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

(Paris, France)

 

 

 

On Feb 10, 2014, at 1:32 PM, Liz Ravenwood <liz_ravenwood@beaerospace.com> wrote:

 

Pros, if I link my tables to an sql server, I still have to deal with the 2 gb max, correct?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.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.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)
.

__,_._,___

Tidak ada komentar:

Posting Komentar