JET Transfers Entire Table?
I read somewhere that the main difference between JET AND SQL server is that a query rn through JET transfers the whole table across the network to the client machine and then processes it. Whereas, SQL server just transfers the particular record, say if you use a stored procedure.
Is this actually true?
What about if it's usng a SQL back end?
Any links on this subject?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Excluding An Entire Table?
I have one table that will consists of about 1,000 rows. I have another table that consists of product codes that we want to exclude from the report. I know how to include the two tables by joining, but I want to EXCLUDE the 2nd table of product codes. Basically, if any of the product codes listed on table 2 are on table 1, I don't want them to appear. So how can I do an exclude function in a query?
View Replies !
View Related
Import Records But Not Entire Table
Is there a way to import the records from another database table? I have an inventory database, blank, only the backend data is there. So everyone goes out on their own and gets inventory. At the end of the day, I would like to get flie 1, file 2, file 3, and only open file one, and only import the record from the other two inventory tables. All these files will be exactly the same(Tables, queries,forms, everything). The only thing that will be different will be the data in the inventory table. Thanks for you help!
View Replies !
View Related
Search Entire Table And All Fields
I have a table that has the following: Joint Account, Employer, Employer1...Employer20, subemployer1, subemployer2... subemployer5, addemployer1, addemployer2... addemployer5, removeemployer1, removeemployer2....removeemployer5. It might be possible that any of the columns with the word "employer" in them have the same number in them. The Joint Account column might have the repeating number in it as well. I want to be able to push a button on a form open a input box and enter a 7 digit employer number and search through the whole table and return all the rows where that number particular number is. I have tried building a query using "like" in the criteria but you can only use that 8 times. I have searched through this forum, but I am unable to find something that I could use. As I m not a seasoned access user, I do not quite know what to do with some of the other "search" questions I have seen. Thank you in advance for any help that could be given or pointing in the right direction. John
View Replies !
View Related
Inserting AND Updating Entire Table
Hello, I am currently working with a database that has a table called "Students." I need to import records from a textfile that has a bunch of records, some new, some existing records but updated. I got them to import into a table used for imports (called "Import Table") and I was able to run a query to append the records if they were not already existing, but how do I get a Query to do both new inserts and updating existing records with new info from the imported data? i.e. Bob is in the database already, but needs to update his records. His updated record is in a textfile which is now in the "Import Table". But in that same textfile/table, there are some new people that need to be added. Thanks!!!
View Replies !
View Related
Converting An Entire Table To Proper Case
I am trying to change all the fields of a table from All Caps to Propercase. I have used strconv propercase before, however only on a field by field basis. I have about 5 or tables that I have to do this to and am trying to save the typing. I know I can do this with a recordset (easily in asp), but am not familar enough to do this in vba. Can you do a for each fld, like in asp, or am I going at this the totally wrong way. I tried using an update query with the *, but access doesn't like that too much. Any help is greatly appreciated. Thanks, Josh
View Replies !
View Related
Delete Entire Column From Existing Table
Please help.... I have combined 2 Tables using a select * query. I have to do it this way as the data changes. The issue I have is that in both tables there is a common field called "Amps" Hence my resultant table has 2 columns, Table1.Amps and Table2.Amps. Every time this occurs I want to delete Table2 column entirely as I use this table to plot a graph. In short- I need to know the code to delete a column from an existing Table. Please help.. Pipes
View Replies !
View Related
Newbie Question Link Row To Entire Table
I'm a relative newbie and I'm trying to figure out if I can link individual rows in one table to entire whole tables. Example: I have a table with the following fields: Ticker Quote Volume MSFT $25.00 3000000 IBM $30.00 1093837 SNDK $20.00 5959483 Now each of these Tickers has a whole table of options associated with each particular ticker and the EASIEST way for me to proceed would be to simply link row MSFT with an ENTIRE table of MSFT_OPTIONS then link IBM with the table IBM_OPTIONS. Keep in mind that I don't have a field called TICKER in the options table and MSFT does not appear anywhere in the options table. I know I can go and add the TICKER field to the OPTIONS_TABLE and then assign a primary key and then link them both but this would involve a great deal more work since I have hundreds of stocks with options tables to link. The data I get is in a specific format and I don't want to have to massage the data too much. I appreciate your help, Mr. Opine.
View Replies !
View Related
Convert An Entire Table To Lower Case?
I need to convert an entire table to lower case.. The table happens to only have one column in it, so each record only has one field.. How do I convert the entire thing to lower case? I can not just convert the display info to lower case, this table is used as a cross-reference data table and I need to physically convert all the data in the entire table to lower case. Oh, and I need this to be a macro of some sort, since the data is re-imported on a regular basis, and will re-convert to upper case on the import. Thanks, Bill
View Replies !
View Related
Backing Up Entire Database
Hi :rolleyes: I would like when I click a button for the system to automatically create a copy of the whole database and place it into a separate folder. How would I do this??? :confused: Cheers bikeboardsurf
View Replies !
View Related
##### Errors Across An Entire Record
We have a database that was being used by two different people to edit the same record at the same time. They both got error messages and now there is one record on the table that is now filled with ######. The table will no longer allow any queries to be ran against it. We figured that that table is somehow corrupt. We tried to compact and repair and that didn't work. It won't allow us to copy nor export any data from it. Are there anythoughts as to what we can do?
View Replies !
View Related
Save Entire Record At Once
Hi Guys I have a main table, which I then query specifying 'XXX' in multiple fields to bring back no records. Then I set up a form based on that query so I always have a blank form to enter details to the table. Access is saving the record every time I amend a field. I'm now stipulating that many of the fields must have data in and am repeatedly getting the 'field name must not be zero' error message even when I'm nowhere near that field. I need to disable autosave and then put the docmd.acsave etc once all fields are complete. Any ideas how best to do this?
View Replies !
View Related
Select Entire Field Automatically
Hi, I want to have the entire field in a textbox selected, automatically, everytime the control is entered--- so the user can just begin typing and automatically type over the existing data in the textbox. How do I do this? I thought it would be as simple as adding something like the following to the textbox's on_enter event: Sendkeys "doubleclick" The textbox will always contain just a single "word", so this idea should work....but I can't find anything like a "doubleclick" that can be used with SendKeys. THanks for any ideas.
View Replies !
View Related
Rename/Save As Function For Entire Database
Hi, I am running an autocompact module in Access97 which will created a 'compacted version' of my database. I then want to rename this compacted version to the name of the original database I compacted. I cannot however find a way of doing this in code. Basically the idea is to compact every 45 minutes or so, but what my autocompact is doing is creating a compacted version under a different name, and so compacting a copy of the database, I then want to change this compacted database name to the original name and re compact every 45 mins Can anyone help?
View Replies !
View Related
Not Getting Entire Data From Memo Field On Query
Hi all, I had table with following data Table f1 f2 f3 1 10 aa...... 1 11 aaa... 2 10 bb... 2 11 bb....... f3 is memo field I had to retrieve data by grouping records based on f1 value so i gave groupby in totals section to f3 field also. I am getting the values correctly, but memo field is truncating. Its only displaying first half arround 236 charecters only. If i query directly without performing any group by then i am getting entire data for the memo field. please any one give the solution. waiting for your help. Thanks
View Replies !
View Related
Change An Entire SubForm Within A Tab Based On Combo
I have a Form with some combo box's in header and a TabControl with 5 tabs in Body. In each Tab I have a subform. All is working as should.. each form is requerying perfectly based on user combo choices. What I would now like to do is swap one subform in one tab for another subform, depending on what choice is made in combo box. That is... Combo choice 1 ... requires Subform's 1, 2, 3, 4, & 5 in Tab's 1, 2, 3, 4 & 5 .. Combo choice 2 though... requires Subforms's 1, 2, 6, 7, & 8 in same Tabs. .. Tab's are umbrella's for multitude of subform possibilities. I really need some guidence here. Thanks.
View Replies !
View Related
Viewing Entire Contents Of A Text Field
I am trying to view the contents of a text field in a form. The field can only be a limited size in the form, but I want to store a lot of text in the field and have it visible without having to enter the field and use the arrow keys to view the contents. Is it possible to programme a function that shows the contents of a field when I roll the mouse over it or something like that? The "Control Tip Text" is the principal of what I am trying to do except this gives a fixed value. When used in web page development I think this function is refered to as "Alt tag"
View Replies !
View Related
Entire Report Blank When No Detail Data Exists
I have a report that prints invoices, and in the page header area it contains most of the invoice information such as labor cost, customer info, etc. In the detail section of the report i have the line items, and a line contains a part, vehicle charge, etc. Some invoices dont have any line items though, and it seems that when there are no lines(ie. nothing in the 'detail' section), the header information will not appear either. Any ideas on how i can fix this?
View Replies !
View Related
|
TRACKER
