[AccessD] Database Conversion

[Stuart McLachlan]

BTW, you don't convert to "SQL".  That's a programming language used by many relational 
database management systems. (RDBMS)
You can connect an Acced front end to linked tables in several different different RDBMSs 
using appropriate ODBC drivers. 

I've used MS SQL Server, MySQL and even SQLite as Access BEs :0
 

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
>