EQL vs. MSSQL linked tables

Updated 2009-09-24 | Filed under Geosync | PDF

Question

How is EQL different from MS SQL linked tables?

Answer

EQL is actually a separate question from linked tables. If your database contains linked tables, it can still work with Geosync. You don't need to use an MS SQL server, but we still suggest you split your database into frontend and backend .mdb, which is standard practice.

Geosync replicates the data (makes copies) rather than relocates the data to an external database, like you would do with MS SQL.

By not linking your tables to an external database engine, EQL keeps several advantages:

  • With EQL, you can keep using all the table design views and wizards that make Access great.
  • You never have to learn or code any SQL (such as CREATE TABLE) commands.
  • The database "backend" and "frontend" are never out of sync.
  • You can keep the whole database in a single file, and that file will work on any computer, even when you're not on the Internet.

Related Articles

Unrelated Articles