Microsoft Sequel Server with Access front end

[jrh1]

Our Access database is getting to be huge (300 megs).

Have tried to use Sybase to hold tables, but peformance was poor.

Has anyone tried MS Sequel Server or any other MS product that would work?

Thanks,
Jeff

 

[smedvid]

Access-XP (2002) has the feature where you can define the backend database in SQL Server and then have the Front End in Access. I think it may be called ADP (Projects). Have not used them yet, but co-workers have without any issues... htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[cmmrfrds]

The advantage of SQL Server is that Microsoft provides a different front end product in Access called a Project (ADP) and the ADP uses an ADO connection that performs much better generally than using ODBC linked tables as you probably did with Sybase. The Project is available in Access 2000 and above. You can limit the amount of data transferred to the desktop much easier in an ADP.