Thread: MS Access to SQL
11-05-05, 23:40 #1(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
Unanswered: MS Access to SQL
well I see in 2003 you can create a .adp file
I imported all my tables in SQL server the created a new Project file .adp
I have link the table to the Project file
how do you link comboboxs back to the forms
in old accress you could just put this in the
[Forms]![formName]![feildName] in the criteria of the combo box
how does one do it in a adp file or is this the wrong way of doing it
do I go back to odbc conectionhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON
11-07-05, 17:30 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
I looked at the option of creating ADP files to SQL Server and decided to go the route of writing my code in MSAccess to use unbound forms (i.e. open the recordset and populate the unbound fields on the form, and then on closing the form, opening the recordset and updating the fields if a checkbox (DataUpdated) is checked when the form is closed. The DataUpdated field is marked to true if an afterupdate event occurs on each or any of the fields.
I like this method as it seems to work very well in a client-server environment with many users using the same mde's and it also makes it easy to create new fields in SQL Server without having to look at outstanding transactions (which could take a while on large recordsets if the form is bound and open by the user).
We are experimenting with ADP projects but I'm not 100% convinced that this would be an ideal method for us and there wouldn't be some problems with updating/adding fields in SQL Server.
Thus, I really like the unbound forms method in mdb/mde's. We have functions to Write/Update/and Delete. I just wanted to give you my feedback on this and another option but I don't know your circumstances.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)
11-08-05, 08:37 #3Purveyor of Discontent
Provided Answers: 1
- Join Date
- Mar 2003
- The Bottom of The Barrel
Myle, you know better.
Give more background on what you're doing and what behavior you'd like to see.oh yeah... documentation... I have heard of that.
*** What Do You Want In The MS Access Forum? ***