CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008

  • Thread starter Thread starter nirmal k ramdeehul
  • Start date Start date
N

nirmal k ramdeehul

Hi everyone.I am a student doing my project. I have done an access
database(.accdb format) with the forms,report,queries,macros,even the
modules. I wanted to use the microsoft sql server as the back end for the
database and the front end to be the microsoft access database. I've tried
clicking on the upsizing wizard on microsoft access 2007 but for some reason
it says the upsizing wizard does not work with the version of the microsoft
sql server to which your access project is connected. I've even tried the
sql server migration assistant 2008 for access and it didn't work. I want to
come up with only the front end part of the access database
(forms.reports.queries etc) connected with the back end(data) to the server
and the back end. the back end should update automatically when data is fed
in the fron end
would anyone help me please
please give me some guidance so that i can finish my work.
thanks very much
nirmal
 
Back
Top