Correct. Note that you cannot convert a table that has an Attachment or Multi-value field in it. You must also be careful to add a Timestamp field to tables that have any floating point values. And be aware that you must add dbSeeChanges option to any DAO recordset you open in code.
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 |
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar