The items involved are:
tblClass_Writing ==>Table that stores the data from sfrmClass_Writing
sfrmClass_Writing ==>SubForm that displays and allows users to add grades
frmClass_Writing ==> Form that contains sfrmClass_Writing
I am having trouble between the subform and the table. WhenI enter a selection in the subform, it displays correctly in the sub form (for example, "Applies spelling skills in daily work". However, when I look at the table (tblClass_Writing), it is displayed as the ID number for that subcategory.
On the reverse however, when you are in a new record in the table and click on the combo arrow for the field and choose an entry like "Applies spelling skills in daily work", it displays the text "Applies spelling skills in daily work" in the feild. Then when you go to the form, frmClass_Writing, and look at the subform, sfrmClass_Writing, an empty row of data is displayed in the form.
Any help in this confusing predicament would surely help - Thanks!
Although there are few records in my database, the auto-numbering started at 45. So I deleted all the records so I could start from zero but it still happens. I checked all the properties of that field both in the form and the table itself and I can't find the problem. Any ideas would be most appreciated. :confused:
I was entering records using a form and all was well until suddenly the autonumbering went from 7 to 14! I went into the table and deleted #14 and tried it again - same thing happened.
I notice when you hover the mouse over a linked table in the Database window, that a tool tip appears displaying the connection string for that table. Where is this connection string stored and how may it be recovered by other means ( VBA )?
I have a inserted a linked table to my Access2007 DB. I want to manage disconnecting from this table, with the use of a button on a form, Then, with the use of another button, connect again. :eek: Is it possible? How???:confused:
I have an access 2002 front end and I am linked to a sql server express 2005 backend and in one of my tables I am getting this error when I add a record to a work order table. The error is ODBC connection on INSERT failed on linked table.
A few strange rhings happen. It only involves customers with over (approx.) 140 work orders (there is a one to many with customer to work order). All other customers seem to be immune to this.
Also, if you go to the tables directly from a access database window, you can still add/edit or delete records, but in the form view, it gives you an error.
I have tried several things including changing code (the orgional code was set dbs= currentDB and dbs.execute("INSERT.......)
I have found similiar posting but no real direct causes. does anyone have any ideas on how to resolve this?
I would like to use code to change the connection string for linked tables in my front end database. I have tried using the connection property of the TableDefs collection, this seems to work while I step through the code but does not change the existing connection property. Any suggestions?
I am a novice Access user. The idea is to build a visit tracking database. We are currently using excel to input appointments and outlook for statistics and patient data (as contacts). I am basically doing double the work.
The excel sheet is one week (Mon-Sun), the dates are in the top row; the names of patients are in t/he left-most column. The visit is marked by the name of the therapist. So, if John Doe has a visit from Linda on 08/25/12, there would be a "L" in the cell corresponding to the date and patient. There are also initial visits by the head therapist and there is a letter "IV" in the cell to indicate that.
I know that I can import the contact list from outlook and create a table and I know there's a calendar function.
Is there a way to 1. Create a form that will act as a weekly calendar (with each cell in a column having the same date, indicated in the top row) with connection/sync with outlook? 2. Be able to customize this form: add and delete patients in the left column. 3. Have the form count number of visits (# of total visits, # of total visits after the initial visit). In other words keep statistics of various sorts.
Right Ok i hope i can get some help cause im absolutely stumped.. i cant get my login page to work since moving it from my PWS(iis on xp) DSN connection to a 24/7 server on the net with DSNless connection here is the code for the include file "conntopwd.asp" http://www.pritchardwebdesign.pwp.blueyonder.co.uk/conntopwd.txt the username and path has been changed slightly for security purposes, and the code for the login page which attempts to access the database is here http://www.pritchardwebdesign.pwp.blueyonder.co.uk/login.txt the connection has been tested by one of the tech support guys at brinkster and he told me it was ok, the problem was the way that the data is called from the data base is wrong .. The tech support guy said that it was this line that was causing the problem.. MM_rsUser.ActiveConnection = MM_conntopwd_STRING Any help would be much appreciated as im stuck for now..
I have a data base that I use ADO primarly to connect to the backend access database. Each time I query a table I create a new connection and then kill the connection after I'm done with it. Should I be creating a global connection and leave open the entire time the program is open, or should I be killing the connection each time?
I simply want to create a connection to an Access db, and run an execute an SQL statement. I have only used RecordSets in the past, so this ADO.NET is completely new to me.
Can someone give me a sample code to execute an SQL statement, and take the result and assign it to a string variable?
I can bind my results to a DataGrid, but if I need it in a string, what good does that do me???
Also, I am only familiar with VB, but if someone has to post it in C#, I'm sure I can figure it out! I appreciate any help.
hi everyone; I'm trying to make an ADO connection to my local database named "dbTest.mdb". Here is the code I'm writing in my editor:
Code: <body> <% Set CN =server.CreateObject("ADODB.Connection") CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:InetpubwwwrootNew FolderdatadbTest.mdb;Persist Security Info=False" Set RS =server.CreateObject("ADODB.Recordset") Set RS.ActiveConnection = CN RS.Source = "select * from tblTest" RS.CursorLocation = adUseServer RS.CursorType = adOpenKeyset RS.LockType = adLockOptimistic RS.Open response.Write(RS.fields(0)) RS.close Set RS=Nothing %> </body>
and this error comes up in my browser:
Code: Error Type: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. whats the problem with my code???!!
Rookie Alert ! I am trying to incorporate simple Access database to web page. In page one, I use Database Results Wizard to display records in database. I pass parameter (last name) via hyperlink to second web page to view complete record. I always get no records found. When I asked tech support, they sent me this:
We do not have registered DSN's on the host server. You will need to use a DSN-less connection string using an absolute path to the file. The path to your account is c:accountsusername and from there you would add the path to the db within your home directory, I.E. -
I have seen other references to this and I have tried what they said with no luck. Where in the page code would I put this? I am using Frontpage 2003. Any suggestions would be helpful or a working example would be nice.
I will create an Access application as a Front end application. The matter is that the users will need to update some data from Internet where there is a MySql server. I thought in creating a local DSN to connect to that MySql server. Is it right ? I already created it but... I dont know the code to connect it from Access. Could you please help me with the code to write in Access ? Im a new with it. sorry. Or you can send me an example of it in an Access database to: osvaldo@ord.com.ar
I am creating an Access database that will be used by multiple users. This database will be on the network and will be the front end of an oracle database connected to it via ODBC. Do I have to set up the ODBC to oracle only on the machine that hold the database on the network or do I have to set up an ODBC on each user's machine?
i'm create a aplication in ms access 2000 developer edition. this app comunicate with sql 2000.
we have problem with slow connection provided by access. in headquater wher people use access app it working quickly. sql 2000 is localted at headquarter too. but if i run app in warehouse it working very slowly.
VPN connection doesn't slow. but access can't use all vpn connection capacity but only 1/5 from this capacity?
how can i do something that acces can use all capacity that i have?
example: link is 512 kbps but access use only 100kbps and work very slowly.
I have a small access database that my users keep open all day long. Access 2000.
I have one primary version of the DB on the network. No one uses it. I have another file on the network that has linked tables to the primary db. I copy a version of this DB to each workstation.
So each user has a full blown DB on their desktop with linked tables back to the main DB. Is this a good set up or are there any issues doing this? What is the best set up for multiple users across the network? Thanks.
one another database have started showing a new error "the database has been placed in state by user 'Admin' on machine 'XXXXXX' that prevents it from being opened."
I read some of the articles on google and find out tht database splitting is solution for this. Now my question is if after splitting i keep the front end and back end at the same location does it gonna effct some how? i mean even after spliting if users use the same copy of database as fromt end. Does it make some sense.
Hi i would like to make a question about ODBC i have created an access database that connects via ODBC to an SQL server database, with the help of someone else i have created this code that works well for the link of 1 table that i choose to link the problem is that i want to link all tables from database and not doing it 1 by 1.
Is there a way to link all tables from database ???
The code i'm using is :
Dim strConnect As String Dim strDatabase As String Dim strTableName As String
'Checks to see if table exists. If it does, delete it. If TableExists(strTableName) Then DoCmd.DeleteObject acTable, strTableName
'And then use the trusty old TransferDatabase method to re-link the table declared in strTableName from the SQL Server DoCmd.TransferDatabase acLink, "ODBC Database", strConnect, acTable, strTableName, "dbo_Tbl_A_Yles"
I want a linked table in my current database. The server where the other access database is already has a ODBC connection created. How to I create a linked table to that other Database through the odbc? I know this is very unspecific, but I do not know what to do on either end. Thanks
I am working on an MS Access database that will connect to an MS SQL db back-end through ADO code only (no constant connection), so I am using connection strings when it is needed to pull back data, other wise it is not connect to the back-end database.
I am trying to get the code correct, and I believe I am close but missing one piece. Here is an example of what I have so far:
-------------------------------------------------------- Dim cat As New ADODB.Connection Dim cmd As ADODB.Command Dim rs As ADODB.Recordset
I want the cmd to use the connection string. But all the help I find is just the code "CurrentProject.Connection" which only connects me to the MS Access database itself.
Does anyone know what I need to place here so that the cmd is using the correct connection string to the SQL back-end?
