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 |
|
Diya
Starting Member
11 Posts |
 Posted - 2009-04-28 : 02:12:25
|
| My access database is based on Access 2003. I want to split the database into back-end and front-end. I want to keep tables and queries at the back-end database, which is to be migrated at sql server 2005. The front-end part will contain only the forms, macros, modules, reports. The reason is to overcome some limitations of ms access regarding storage space an jet database engin. Is it possible? If so, what is to be done? Anyone can help me anyway?With best regards,diya |
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-04-28 : 11:04:48
|
| Split the database (Tools > Database Utilities > Database Splitter) and then use the upsizing wizard (Tools > Database Utilities > Upsizing Wizard) on the backend to use the SQL server DB. |
 |
|
|
|
|
|
Use of sql server with ms access