No announcements
Found 2810681 threads
-
0 VotesSplitting backend db
I agree with Ray, but in answer to your question - you can split the backend into multiple backends.Answered | 5 Replies | 2092 Views | Created by Y a h y a - Tuesday, June 5, 2012 11:13 PM | Last reply by KCDW - Wednesday, June 6, 2012 5:23 AM
-
3 Votes
MS Access and Performance when Splitting Two Backend (Past 2GB Limitation)
Microsoft Access MVPAnswered | 4 Replies | 646 Views | Created by GOICEHOCKEY - Monday, March 9, 2020 5:28 PM | Last reply by Tom van Stiphout (MVP) - Monday, March 9, 2020 9:42 PM -
0 Votes
How to deployment MS Access frontend/backend system when not on a company intranet
It has no GUI creation like Access, only helps you with backend.Answered | 3 Replies | 934 Views | Created by PSD1953 - Tuesday, September 5, 2017 8:52 PM | Last reply by AnthonyCode - Wednesday, September 6, 2017 10:38 PM -
0 Votes
Overcome the 2GB limit by using temptables ?
However, your data size should still be within limit.Answered | 3 Replies | 1660 Views | Created by Slounch - Tuesday, May 7, 2013 4:32 PM | Last reply by Andrey Artemyev - Tuesday, May 7, 2013 6:02 PM -
0 Votes
OneDrive and MS Access Backend/Frontend Configuration
OneDrive, Dropbox, etc.) would be a good setup for a split Access database application.Answered | 1 Replies | 1055 Views | Created by PSD1953 - Tuesday, September 5, 2017 6:17 PM | Last reply by .theDBguy - Tuesday, September 5, 2017 6:29 PM -
0 Votes
Exceeding 2gb .NET limit
A x32 process on a x64 computer is still limited to the 2gb memory limitation but will Vs2008 (on a x64 computer) produce a x64 process that will have a ...Answered | 10 Replies | 3986 Views | Created by John Olbert - Friday, October 24, 2008 1:48 AM | Last reply by John Olbert - Monday, October 27, 2008 3:42 PM -
0 Votes
Opening the front end of a split database - when the backend is missing
If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.Answered | 4 Replies | 1850 Views | Created by Ulsterfry54 - Friday, March 11, 2016 6:16 PM | Last reply by Ken Sheridan - Friday, March 11, 2016 11:59 PM -
5 Votes
blob and the and/or 2GB file size limit.
More important, since this FPT file has the 2GB limit, that's a limit for all table data, not per field nor per record, it stores the values of all blob, ...Answered | 6 Replies | 6542 Views | Created by zulfiqar7299 - Sunday, December 24, 2017 5:49 PM | Last reply by Olaf Doschke - Tuesday, December 26, 2017 8:15 AM -
0 Votes
Import MS Access into MS Access - Cannot open database".
So it's quite possible that the importation of a big table with 3 to 5 million rows in a single shot make the size of the database file to exceed this limit of 2Gb ...Answered | 4 Replies | 16869 Views | Created by Don-In-CP - Thursday, January 27, 2011 3:26 AM | Last reply by Amit Khese - Thursday, February 3, 2011 6:07 AM -
2 Votes
Compacting the Front End of a Split Database Without Compacting the Backend
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)Answered | 7 Replies | 5803 Views | Created by Avan_Madisen - Friday, June 8, 2012 2:58 PM | Last reply by Douglas J Steele, MVP - Monday, June 11, 2012 2:38 PM -
0 Votes
adding a table to a backend access database 2007
Access (in the Import group - be sure to check off the 'Link to the data source by creating a linked table' and then follow the rest of the onscreen instructions)Compact the both ...Answered | 1 Replies | 1322 Views | Created by Agnemon - Monday, December 3, 2012 11:01 AM | Last reply by Daniel Pineault (MVP) - Monday, December 3, 2012 11:40 AM -
0 Votes
Storage limitations of Microsoft Access
Where people get into trouble is when they start to store media in their databases.Answered | 5 Replies | 944 Views | Created by Gordon Swan - Monday, July 3, 2017 1:27 PM | Last reply by Daniel Pineault (MVP) - Tuesday, July 4, 2017 1:51 PM -
0 Votes
Storing MS Access DB on Network with connection to backend SQL Server
Tnoy Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - ...Answered | 3 Replies | 3519 Views | Created by cschultz25 - Monday, June 20, 2011 4:58 PM | Last reply by Tony Toews 0 - Thursday, June 23, 2011 8:26 PM -
6 Votes
How to reserve 2GB of memory for a process
I may also give inefficient code or introduce some problems to discourage copy/paste coding.Answered | 8 Replies | 2556 Views | Created by ehsansad - Thursday, March 1, 2012 12:20 PM | Last reply by ehsansad - Friday, March 2, 2012 9:15 AM -
0 Votes
Access 2007.
Armen: How do you handle the case with Access 2007 or 2010 when the database isn't in a Trusted Location?Answered | 9 Replies | 23025 Views | Created by stevethewiz - Thursday, October 21, 2010 3:06 AM | Last reply by Joshuar75 - Monday, December 6, 2010 4:30 AM -
2 Votes
Remote Blob Storage - File size limitations?
Metalogix StoragePoint v4.1, our EBS/RBS/SharePoint storage optimization solution, available March 11, 2013, will add support for files over 2GB.Answered | 3 Replies | 9998 Views | Created by CedricO - Tuesday, December 21, 2010 9:29 AM | Last reply by Tom Rossi - Tuesday, February 26, 2013 5:16 PM -
7 Votes
Connecting to access backend from access 2013 frontend using VBA
Split database architectureAnswered | 6 Replies | 3616 Views | Created by Adarsh Madrecha - Thursday, August 13, 2015 9:19 AM | Last reply by Ricardobh - Wednesday, August 26, 2015 11:02 AM -
0 Votes
Access Frontend SQL backend in the cloud
Hi JoBu, You might see some performance gleeches as data is coming from server which is far away from your access front end. other than hat you ...Answered | 1 Replies | 3197 Views | Created by JoBu12249 - Thursday, September 12, 2013 1:12 PM | Last reply by Dilkush Patel - Saturday, September 14, 2013 4:02 PM -
0 Votes
Backend Linking - Relative not Static
I have split my back and front end.Answered | 2 Replies | 994 Views | Created by mbrad - Friday, June 6, 2014 8:08 PM | Last reply by mbrad - Friday, June 6, 2014 8:21 PM -
1 Votes
Access Backend Store image in table
You can perform the following steps.Answered | 12 Replies | 2232 Views | Created by NachoShaw - Saturday, January 24, 2015 8:59 PM | Last reply by Lydia Zhang - Tuesday, January 27, 2015 3:36 AM - Items 1 to 20 of 2810681 Next ›
No announcements
