how to set a candidate key in MS Access?
340795
Hi,\nyou goto the table description properties.\nThe key which you want to make it unique and candadite..\n\nYou choose Primary key, meaning ... a key which cannot have duplicates.. like an id
151888
Sorry, I don't think I can help.  I can use a 50 field table in Access and create a 50 field form using the wizard.\n\nDoes the problem occur running the wizard locally instead of through the thin client?  If it doesn't, you probably need to report the problem to Wyse.\n\nOnly other thing I can suggest (not saying it will make a difference) is see if you have the latest service pack installed for Office - maybe there was a bug???
637825
MS Access environment\n\nYou must create a field in Table Teachers that uniquely identifies each teacher. It can be an Autonumber field.\nGiven this, each time you add a teacher, the software will give this record a unique number.\n\nIn Students Table, create a field with number Long Integer data type.\n\nGo to Tools>Relationships and set a one-to-many relationship between the 2 tables using these 2 fields.\n\nCreate a query with this 2 tables using the fields in table Students and only the fields in table Teachers you want to show (not the autonumber field)\n\nMakiavel
431188
when u create table in design view,and select field. there is look up option ear general TAB.click on that tab if u have text field then u r able to change it and make combo. then u have to give reference combo to perticular table field by using query
851415
You might have a problem with stealing a key. MS has started imposing restrictions on its software that include forcing a user to register within 30 days or have product disabled. & if the key is already in use by MS's records your gonna be out of luck.\n\nYour best bet is to download & use open office. It's free.
1071667
I think u have to enter you host name, username password and the name of the database after the =>.\n\nyou can do this wich a text editor like notepad.
10271
try\nhttp://www.kdkeys.net/forums/688/ShowPost.aspx
883282
It would depend on your table structures, but it should look something like this:\n\nSelect <student info>\nFrom <table name>\nWhere <table name>.<birthdate field name> = <date of feb>
931713
I think for that u need the machine name or the IP address of the database machine.\n\nU can use this machine name or IP as the data source value in ur connection-string value provided for connection in ur code..
655708
You should be able to copy the MS Access file to your local drive and be able to modify without changing the original.  If the MS Access file has an .mde extension - you'll be restricted to what you can view & change.
72709
It's been a while since I've played with Access, but what you're asking sounds right.  As long as the query is looking for the data in the same table, it should produce the same results.  I've never tried this, but it makes sense from a theoretical point of view.  Hope it works for you!
767093
This link will tell you how.\n\nhttp://www.ehow.com/how_10070_set-shortcut-keys.html
818044
Hold ALT and Type 0134.\n\n† Like this right???  †
226102
It's not entirely clear what you're trying to do here ... but it sounds as though you want to use the MS Access Workgroup Security which modifies the system.mdw file associated with any Access database you may open / use.  I'd avoid using that strategy with a VB application.  If this is a network environment, create a table in the target database which can be used to store the network user id for anyone you want to allow access to the application and data.  Then use the Windows API to read the user id when the application is launched - then validate the user id against your user id table and permit or deny based upon the result.\n\nHere's some code snippets that may help (Good luck!):\n\nPublic strUser As String\n\nPublic Declare Function WNetGetUser Lib "mpr.dll" Alias "WNetGetUserA" _\n    (ByVal lpName As String, ByVal lpUserName As String, lpnLength As Long) _\n    As Long\n\nConst NoError = 0\n\n******************************\n\nSub GetUserInfo()\n\nConst lpnLength As Integer = 255\nDim lpName, lpUserName As String\nDim status As Integer\n\nlpUserName = Space$(lpnLength + 1)\n\nstatus = WNetGetUser(lpName, lpUserName, lpnLength)\n\nIf status = NoError Then\n    strUser = Left$(lpUserName, InStr(lpUserName, Chr(0)) - 1)\nElse\n    strUser = "Unknown"\nEnd If\n\nEnd Sub
92740
it depends on the OS u r using if it is windows 98 goto start-->Settings-->control panel double click on users to create a user
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
531740
try using microsoft access.  use the wizard to make a dat base and tjen it is clear sailing.\nthere are also some othere ones but i dont know their names because they arent in microsoft so i highly doubt that you will have them.