May 12, 2011 at 7:11 am
Hello All,
I have an Access application in the fron end and access database in the backend. Recently I migrated the access database to sql server keeping the access application in the front end as it is. I created the ODBC connection in the application and configured to the sql server database.
My question is how the access forms are accesable from the front end application. Do I need to create a view for each access form in the sql database to populate the data into the front end or it can be accessed thru Linked connections that esatblish thru ODBC drivers.
Thanks in Advance
May 12, 2011 at 7:14 am
The access form would still be the front end. You would change the forms to use sql server instead of access as the db.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 12, 2011 at 7:21 am
In access you have to create the linked table connections. Something of note is that whenever you make a change to table structure in SQL you will have to refresh the linked table through Linked table manager or the change will not be reflected.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply