Discussion Locked

Acces Front-End SQLServer 7 Back-End

0 helpful

5 replies

by slmarten Nov 15, 2002 last reply Dec 4, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to use Forms of Microsoft Access as a Front-End and Microsoft SQLServer as the Back-End Database. Can you tell me how to do this.

5 replies

The short answer is to link the tables and procs to your Access DB, then use them like they're normal Access resources.

Glen

Thank U Glen. Your answer was very helpfull to me.

1. Set up a DSN to point to the SQL Server
2. Set up LINKED tables in access to the tables on the SQL server you are using

At this point, it will function alot like an access database will function.

Mike, I'm very glad with your answer.

This question was closed by the author

This discussion is closed to new replies.