When linking in a table under Access 97, any long integer fields are being converted to TEXT format. This I understand is due to the version of the Access database engine.
It does not happen in Access 2000.
Anyone have any idea's of how I can force access 97 to use the jet 4 engine installed already ?
( i have abused the registry - and it didnt like it at all )
I'm formatting an Access table and need help linking 1 field to another. I need to specify that Field B will state "N/A" if and only if (back to good old geometry) Field A states "Yes." I've tried using the ValidationRule and Default Value functions but they don't let me refer back to Field A. Any thoughts would be hugely helpful.
I'm totaly new to access and outlook applications etc.. What I'm trying to do is link an access table to my calendar in outlook. I can do it but there is one problem it is not importing all the fields. But when I do an export from outlook to access database file all the fields are there.
Can someone help me with this issue?
P.S. I'm using outlook 2003 and connecting to exchange 2002.
It is a simple linking based on one Column in Both the Table.The problem is One Table has "11 Lakh Rows other 2000 Rows"..Actually I am not sure weather the computer is getting hanged or Not as I wait for 10 min still when I am not able to see any update I End the access.
How can I know if it is working or hanged ? (errors like memory overflow will not come after I wait for an hour or so)
Can I use DLOOKUP instead of linking as I want it to be one on One link ?
I'm trying to use a template to track assets-specifically this template:URL....Is there a way I can link an excel doc to my database that provides all of my data, that is thereby linked to other tables within Access?I want my data to be updated as it is manipulated within the independent excel doc when I open access.
I am trying to link an excel file (.xlsb) into Access 2013 running on Windows 8 (External Data-->Excel). It will first act like it's working, but it will just shut Access down after a couple seconds of churning and ask for a Backup to be created or it will restart (no rhyme or reason as to which you will get). I've tried a Compact and Repair. I've tried rebooting. I've tried renaming the excel file(although I have other files with the same naming convention linked), but no matter what I do, it will not accept it. I've tried doing just a straight Import....same results. This file, along with a others that are already linked in this database, are stored on a network server.
Ok...I have an issue that I don't know how to resolve. I have a table called 'orders' in the orders table there is a place for " quantity', 'colours' and per unit. The cost per unit is based on quantity and colours. For example: 12-35 shirts 1 colour are $2.85 per unit. 12-35 2 colour are $3.50 and so on. I would like to be able to put in the quantity and # of colours and the Unit price fills in a field. I don't know how I can accomplish this.
I have created an Access database application that is stand alone for each account manager/client at our business except for one table that I want shared as a source of data across all separate databases that are created.
I've investigated automatic Database Splitting and this works, except I only want the one table to be split and the others remain unique to each database.
I tried exporting the table in question to another Access database and then linking the table into each other database, this seems to work except that referential integrity can't be set up as it was. Is there any way to keep the integrity between the external database and the databases it links to?
I'm using 2 databases. The first is my working database (LiTiMA.mdb) the second database (LiTiPA.mdb) is just for the password table. There is no link between the 2 databases. But when I open a form for editing the password in LiTiMA, a connection need to be created between the 2 databases. If the form is closed the connection need to be removed.
I can create simple databases with Access but I've recently identified the need to create something a little more complex. My entire relational database revolves around a central table of contacts.
I have a list of contacts in MS Outlook (searchable by name, phone number, etc.), which should be the same. I want to avoid the risk of data redundancy so I was wondering if it is possible to link Outlook and Access databases in some way, so that, for example, if I was to add a contact in Outlook, it would update my database automatically and vice versa.
I'm sure this is far from simple but I'd love to hear any suggestions you may have.
Okay, I've heard that this isn't possible, and searching the forums for AutoText didn't yield any results for me, so I thought I would ask here.
Is there any way to link the AutoText in word to the entries in the database? I am thinking along the lines of exporting database entries to a template in the AutoText format.
Obviously a similar effect would be to use a mail merge and insert the relevant data in from the database, but I'm proposing that Word should somehow lookup the information as it does with the AutoText, which seems a more elegant solution. However, I'm not up to the job of figuring it out myself.
Anybody like to show me how very clever they are? :o
I'll try to summarize the situation as best as I can.
I have an Access 2003 FE linking to an SQL 2000 BE using a DSN-Less Connection String. Both are running on my local machine for development.
I created a LinkTables method (see below), so I can select different Connection Strings for use in different locations (ie. onsite at client, at my office for development). I have no problems getting it to work on my local machine. I even took it to another office where SQL was running on a server, and the Access FE was on a workstation. The LinkMethod worked perfect.
Onsite at the client different things happen. It links fine while on ther server. However, when I try it on a workstation, it doesn't link correctly. It says everything linked successfully, but when I try opening a table I get the error:
Connection faled : SQLstate : '28000' SQL Server Error : 18452 [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(NULL)'. Reason 'Not assoccated with a trusted SQL Server Connection'
Then it opens a Login box asking for a login. If I enter the correct Username and Password, all the tables open. Its almost as if the UID and PWD in the Connect String are being ignored.
Any idea's what the problem is?
Thanks.
Public Sub LinkTables(gLocation As String) Dim DBPath As String Dim td As TableDef Dim p, i As Integer Dim s, c, e As String
On Error GoTo Error DBPath = Left(CurrentDb.Name, InStrRev(CurrentDb.Name, ""))
On Error Resume Next If gLocation = "" Then Exit Sub c = DLookup("ConnStr", "Settings", "ID = '" & gLocation & "'") If c = "" Then Exit Sub On Error GoTo Error
' For Testing c = "ODBC;DRIVER=SQL Server;UID=audituser;PWD=audituser;SERVER=CORPMAT; DATABASE=AuditTest"
i = 0 For Each td In CurrentDb.TableDefs s = td.Connect If Left(s, 4) = "ODBC" Then ' Check for SQL Link td.Connect = c td.RefreshLink i = i + 1 End If Next Set td = Nothing If e <> "" Then MsgBox "Error Linking Tables:" & cr & e, vbExclamation Else MsgBox CStr(i) & " Tables Linked Successfully. Please re-open the database." Quit End If leave: Exit Sub Error: MsgBox "Error Linking Table! " & td.Name & cr & " Error: " & Error$, vbCritical Resume leave End Sub
Is there a way to link a ACC table to an Excel spreadsheet so that when changes are made to one it automatically changes the other?
And - How do I link (or join) two (or 3) Access tables so that the above happens - when a change is made to one it's made to the other.
Example: I have an overall big table with 7 fields. I created a query from it that has 5 fields. Or create another table that has 5 fields. Can I join/link them so that changes made to one is made to the other?
Example: An ID number changes or a wage salary changes.
Does anyone know if this is at all possible. When I wish to process a payment for a customer within my database, rather than visit paypal and entering payment information, is there a way by way of API or similar that I can automatically go to the site and have the payment amount entered for me using data from a form within my database?
It may be too much of an ask but I thought I would at least ask the question..
I have an excel spreadsheet that i have linked to an Access database. I need to append and delete records from the spreadsheet into an existing table in my Access database. I am able to append specific records from the spreadsheet into my table but then i want to delete the records from the spreadsheet. When i run the delete query i get the following message; "Deleting data in a linked table is not supported by this ISAM" Is there some way i could get this to work?
I have records in this spreadsheet that needs to get into the database but once it is appended to the database i need those records deleted from the spreadsheet. I am kinda using this spreadsheet as a temporary table so one employee who does not use access can put data into his spreadsheet and then the other employees can pull want they need from this into the database.
I have a table which is being populated with data when I click a button in a form. Now I want the data of the table to be shown in an excel file but the problem is that I want that data to be refreshed everytime I insert new data in the table.
I have an access dbase trying to link a paradox table. I have Office 2003 and BDE 5.01 was installed on my machine. When I try to link to a paradox table its giving me an error "Unexpected Error from xternal database driver (11265)". On the other hand, I have Office XP on my laptop and BDE 5.01 installed, I tried to link to a paradox table and it works. :eek: :confused: What can I do to link to a paradox table using Office 2003? :confused:
The aim of this (as part of a bigger solution) is to create an entry system where users can enter jobs in, assign a resource to the job and give the resource a cost. The conditions are that resources can be on more than 1 job, more than 1 resource can be on a job.
Obviously entering in resources manually is not a good solutioon (eg having 20 resource fields) as it is now. I want to create a relation between tables to achieve something better.
Let's say I had (for illustration sake) 2 tables, one which is a list of people and one which is a list of jobs. I want to be able to assign a person to a job for x amount of time (defined by a start date and end date in the job table) at cost y.
So we could have a field for the people table which would relate to the job id and a field for rate in the job db. However, people can be on more than 1 job (eg after doing one they do another) and there can be multiple people on a job (having one field for rate rendering it useless)
How can this be done in the most efficient way so that any job could be looked at historically and have the relevant rates etc? Would I have to create another table with rates relating to the job ID and person ID? This would allow for multiple resources per job and to have a rate assigned for each resource.
eg if person ID = 1 and job id = 1 then fetch rate etc and display in a list, and to calculate total cost simply sum all rates where job id = 1?
I have been linking text delimited file to my Access table. The text delimited file is generated by a report run by our in-house system. I've been able to do this. Now, I want to learn how to link a datawarehouse (ODBC?) cube to Access. Is there a tutorial somewhere I can perhaps start? I tried to search this form by typing "Linking datawarehouse" I only found one post.
I am pretty new to creating relationships between tables. I have a main form with subforms embedded. I tried running queries from the main form and they run just fine. I also run from the tables linked to the subforms just fine. however, when I try to run a query for a report that takes data from the main form and joins with data from the tables linked to the subforms all the data cells are blank. I have a linking table which is also blank. All the forms are linked by the same program ID number. Any ideas on how to resolve this? Thanks
Hi, I have been thinking of allowing our users to be able to link records together within our database. We have a CRM system that lists customers and their details of mortgages and other insurance related products which they have. Some entries maybe linked in some way, possibly other family members etc.
My question is, is it possible to perform this kind of action? So they can then see relationships between either related records (ID ref etc).
I'm sure I've seen this in SQL based applications, but haven't come across it within Access.
When running a query i have created an expression which is simply 2 fields joined together. JOBLOC:[JOB]&[LOCATION]. I want to link this expression with a field in a second table [SCOPE], but for the life of me can't remember how i did it. Either in query design or SQL.
Hi. I have a table with Basic Client Data including their program start date. One type of service they might, but not necessarily, get is job training. So I have a Training table.
I need a query that will show all client's names (found in Basic Client Data) with a specific start date but exclude anyone who has a specific job training service.
I just added a new field to a table but i now need to add the field into a form so the table can be update. However when i open the field list to assign/bind the control the new cloumn is not present on the field list.
How do i add a new field which i have entered in the table to the field list?
Hi, i'm trying to get a field to only allow data to be entered that is in a table e.g. i have a table which has a list of country dialling codes in it. In my form i want to only allow valid country codes to be entered-i.e. the ones which are in the table? Ive tried coming up with different validation rules but cant seem to do it Can anyone help?
I am creating a Risk Management Database at work. I have created a tab with options to choose, as to log the risk relevant.
i.e. I have a catagory, subcatagory and then Risk boxes
When saving the record it will save the risk but it will not save the catagory, and the subcatagory options choosen? I have a seperate table for this information to appear, Does anyone know how I can make this happen without stopping it from shortening the catagories down.
I hope this make sense. I am sorry I am a little rusty in Access 2003.
