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

 

[culshaja]

Yes it can, you just need to set a DSN on the client machine and then link the SQL Server tables using that ODBC DSN. You can then use these linked tables like any other access tables.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[ColinM]

Or if you're using Access 2000 you can use a project type database to link to SQL (File,New,Project(Existing Database))

You can also use ADO to connect to SQL

You should probably create a view or a stored procedure in SQL, so that you are only returning a few thousand over the network rather than your 4gigs!