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 |
|
dand_dd
Starting Member
6 Posts |
 Posted - 2009-02-11 : 09:27:49
|
| Hello! Here in the office, we have Access 2003 and MS SQL server. My department has a large Access -DB that is important for all. For different reasons I must split the Access DB in frontend and in backend. So Frontend in MS Access will contain the user interface and the backend io have to implement into SQL Server.How to migrate all table from Access to SQL Server? How to establisch a connection between Frontend and Backend?What from entire database in Access remains in Frontend?(forms?, vba code?) Previously I worked only with MS Access, and of SQL server, I have only a few knowledge. Is there a solution to my problem? What do you advise me? Thanks!Dan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-11 : 09:38:20
|
| you can use ssis/dts export import task for this |
 |
|
|
Doron
Starting Member
6 Posts |
Posted - 2009-02-12 : 12:14:23
|
| You can run simple SELECT queries on SQL Server which will take the data directly from the Access database.Use the following example:EXEC sp_addlinkedserver @server = 'FrontDB', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet', @datasrc = 'c:\Front.mdb'GOSELECT Column1, Column2INTO NewTableFROM FrontDB...TableNameYou can also use our products for simple daily database tasks on both Access and SQL Server.Doron Saar,Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)www.nobhillsoft.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-12 : 12:16:30
|
So Basically , You are doing advertisement in every post about your products.quote:
Originally posted by Doron
You can run simple SELECT queries on SQL Server which will take the data directly from the Access database.Use the following example:EXEC sp_addlinkedserver @server = 'FrontDB', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet', @datasrc = 'c:\Front.mdb'GOSELECT Column1, Column2INTO NewTableFROM FrontDB...TableNameYou can also use our products for simple daily database tasks on both Access and SQL Server.Doron Saar,Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)www.nobhillsoft.com
|
|
|
|
|
|
|
|
|
MS ACcess as frontend SQL Server as backend