CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top