Peter,

2SQL certainly sounds a very useful solution. We are currently using Access 2000, but our main database has reached the limits in terms of query and table size within Access, so I am in the process of designing a replacement in SQL Server 2005 - the original database having been designed in Lotus Approach and converted to Access 97 before updating to Access 2000, there are a number of basic design flaws that I feel need addressing by a total redesign.

Whilst table design in SQL Server 2005 is quite straightforward, I have found that forms and reports are much less simple, being used to the relatively easy approach provided by Access 2000, so my intention is to upgrade to Access 2007 and design these elements in a more familiar environment for linking (as an Access Project) to SQL Server.

However, if I encounter serious difficulties I shall certainly consider using 2SQL to migrate the original database to SQL Server.