[AccessD] Database Conversion

[Randall Anthony]

Thanks for the replies everyone, looking things over now.
Stuart, see below, (BTW, I'm a SQL DBA that actually coded in Access years
ago)

Before doing that:
It is on a network or single user?
Network, but basically single user.

Is it currently a split BE/FE or is everything in the one file.
If it is one file, try splitting them first.
Totally forgot about that, will try that first (BTW, it's been 5-6 years
since actively working in Access)

If multi-user, is a a share sing file or FE or do all users have seprate
local FEs. 
No, see above.

When was the last timei the data file was compacted?
Do you regularly compact your data  (Is it configured to "compact on
close"?)
It's c/r'd before every run, down to about 800MB prior to running, to 1.89GB
after processing.

As an alternative, you may consider multiple back ends:
https://answers.microsoft.com/en-us/msoffice/forum/all/there-is-a-maximum-si
ze-of-2gb-for-
an-accdb-file/29b095ce-95b0-4291-b3e1-e4baff288ad3


On 5 Jan 2024 at 20:33, Randall R Anthony via AccessD wrote:

> Hello Group,
> Happy New Year!  I come before this august group with a question on 
> converting an Access DB to using SQL as the BE.  This is an ancient DB 
> (circa 2001, current v = 2013) that's bumping up against the 2GB wall.
>  It uses a lot of macros in the processing logic.  How/what's the best 
> way to expedite converting to SQL tables?  I've seen a few posts back 
> in the day that used a SQL?  Access?  conversion tool with mixed 
> results.  Thank you for your time.
> 
> Regards,
> R.
> 
> 
> 
> 
> 
> 
> Disclaimer:
> 
> 
> This electronic message and its contents and attachments contain 
> information from Sentara Health and is confidential or otherwise 
> protected from disclosure. The information is intended to be for the 
> addressee only.
> 
> If you are not the addressee, any disclosure, copy, distribution or 
> use of the contents of this message is prohibited. If you have 
> received this electronic message in error, please notify us 
> immediately and destroy the original message and all copies. -- 
> AccessD mailing list AccessD at databaseadvisors.com 
> https://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com
> 


--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
This email has been checked for viruses by Avast antivirus software.
www.avast.com