I've just split my db and am using Access as my front end. Are there
any advantages / additional functionalities of having SQL Server as my
back end that I can take advantage of?

Hi,

Yes a lot in terms of :-

1. Hardware usage
2. database sizing
3. Security
4. Locking
5. Concurrent access
6. Backup methodologies to have point in time recovery
7. Online replication, mirroring and logshipping to have DR servers and
high-availability
8. Online Indexing

the list goes on and on. SQL Server is one of the top RDBMS in market and
access can be used for a stand alone application.
You will not see any advantage as a database when you compare Access with
SQL Server.

Thanks
Hari
SQL Server MVP




[quoted text, click to view]

Perhaps these references will help:

Advantages of SQL Server over Access
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/managesql.mspx
http://www.expresstechnology.com/TechBulletins/SQLCompare.htm
http://www.ssw.com.au/SSW/kb/KB.aspx?KBID=Q169882


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]

MDB linked tables is a stupid architecture.

spit on anyone that still uses it.

Access Data Projects are a vastly superior solution

-Aaron


[quoted text, click to view]