Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eliza Albert
Starting Member
2 Posts |
 Posted - 2005-08-27 : 09:56:07
|
| I am working on a conversion of an existing application where we use MSAccess as both frontend and back end. We have forms and reports in Access. Since the size has grown big we are migrating the database to SQL Server 2000. We are planning to have the front end in Access itself. Can some one tell me the amount of changes required for the conversion. How do I make the forms & reports to pick data from SQL Server instead of the same access database? |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-08-28 : 22:52:34
|
| Hi ElizaDifficulty kind of depends on what you've got. In theory, you just set up a DSN for the SQL Server and relink your tables. Does your current Access application use DAO or ADO?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
MS Access Front end and MSSQL 2000 backend