Hi: Jim
Thank you very much for your help.
After another hrs of trying, final I found problem, you are right at the beginning, I didn't set the primary key for the sql table, but I added a primary follow your suggestion immediatly.
But still not working, why? because I should go to the linked table manager and refresh the link.(I didn't realize I should do that).
Everything backs to normal, now the data...
jamest85
Last Activity: Feb 21 '08, 06:31 PM
Joined: Jan 18 '08
Location:
-
Hi: Jim
I am trying to do a simple test here: create another combo box, put the combo box Control Source = codAction!actDe csription (using expression builder), when I open the form, the combo box has values, but if i select one of them. on the bottom of the statuse bar says: "Control can't be edited, it's bound to expression "codAction!actD ecsription ".
I don't know why that happens.
Thanks....Leave a comment:
-
Hi: Jim
Thank you very much for your reply.
I checked the table in SQL, it has primary key.
I am using this connection:
strSQL = "SELECT actDecsription FROM codAction WHERE actActionID = 3"
rst.Open strSQL, strCnxn, adOpenKeyset, adLockOptimisti c
Set Me.Recordset = rst ' trying to recordset to bind the form
On the form, only has a comboBox (name is:"cobBoxDescr "),...Leave a comment:
-
Access Form Locked after linked tables are from sql
Hi:
I am experencing very strange case.
I have two identical MS access application, only difference is one backend is MS database, another is MS Sql database.
When I run the application with the sql backend, one form just doesn't allow me to edit, even I can select value from a comboBox control.
(But the application with the MS database backend works fine).
I don't know what will casuse the problem,... -
Hi: Jim
Thanks for your such detailed and professional response.
I am using window authentication, and I am using ODBC trusted connection, I have run the .mdb in each pc, and it's .mde also. Hopefully if I created a new .mde from my pc, I just copy and paste to each pc later on.
Thanks again.
jt...Leave a comment:
-
Copy mde file to each pc?
Hi:
After migrate mdb database to sql server, I have created .mde and installed in each user's pc.
My question is: if I modify .mdb file later, and re-create a new .mde from my pc, can I copy the .mde to each user (replace the old one)? The main concern is: do you think those table links (tables from sql tables) will still work?(or I have to relink them manually?).
Thank you very much.
... -
Thank you very much for your help,sierra7.
I have checked my pc (at: ODBC Data Source Administrator), from the System DSN tab only has one list:
Name: Vision (which is the name I have connected to the sql db).
Driver: SQL Native Client (which is the only item from the Drivers tab, I am not sure if I selected that before, or somebody else).
I can go through all the way, and test the connection to the sql database...Leave a comment:
-
Thanks for your post, sierra7.
How to find that the user has or hasn't installed the ODBC driver?
Thank you very much.
Jt...Leave a comment:
-
Sounds great, Megalog
One more question:
Usually I will ask each user to put a short cut to their desktop, if the .bat file called: myDataAccess.ba t,
I will put it in each user's common folder (the folder which can load my Access MDE from the server pc).
Then I just put the myDataAccess.ba t short cut to their desktop, so if the user clicks, it will run the .bat file automatically, and the new MDE will...Leave a comment:
-
permission issue connect sql server table from MS Access
Hi:
I have migrated MS Access table from .mdb to MSsql server, from my computer and my boss' pc can run the new Access application without any problem, but another user just can run this application (before the migration, she runs the .mdb without problem).
error: The Expression After update you entered as the event property setting produced the following error: ODBC-connection to "textSQLDB" failed.
... -
thanks guys, really helpful.
jtLeave a comment:
-
MDE file
Hi;
I have a basic question, after I created MDE file from MDB file, do I have to install the MDE file in each user's pc? (We are sharing the data from SQL server), or I only create a short cut for the MDE, so everybody in office will run that one which is located in a share folder?
Thank you very much.
Jt
No activity results to display
Leave a comment: