[AccessD] Database Conversion

[Stuart McLachlan]

Before doing that:
It is on a network or 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.

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

When was the last timei the data file was compacted?
Do you regularly compact your data  (Is it configured to "compact on close"?)

As an alternative, you may consider multiple back ends:
https://answers.microsoft.com/en-us/msoffice/forum/all/there-is-a-maximum-size-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
>