Access with SQL backend???????

[DaveMac]

Can Access be used as a the interface for an SQL database? What I’m thinking is can you have an Access DB with all the info coming from an SQL DB. That way you get the power of SQL 7 and the interface of Access. I have used Visual Fox in the past and now am using Access. I like it but the speed and limitations are of concern. My company has an IT dept that uses SQL but all we have in my area is Access. I would like to have forms that are based on programs or queries in SQL that reduce 4 gig files with a couple of billion records to 10 meg table with a couple of thousand.


Thanks

 

[WP]

Dave,

Access with SQL Server backend is a common practice.

You can simply link the tables via an ODBC connection but to get the full benefit you need to write server side procedures ( Stored Procedures).


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !