How can I replace a datasouce for an exiting form?

K

KssKumar2000

Hi,

I have fully designed (validations, formats, etc.,) a form with a
datasouce. But now I created a new datasouce with some user
restriction (ie., sql server user permissions). I dont want to design
a new from. I want to replace the datasouce of my exsing form.

How can I do this?

Thanks
 
S

SChapman

You should be able to go into Tools --> Data Connections and select your main
data source (you may have named it something other than Main Connection).
Select Modify... and when the Data Connection Wizard opens you should see a
Change Database... button at the top. If you have modified the SQL or
deselected specific columns, you will need to repeat those steps with the new
database.

HTH
SChapman
 
Top