My name is Ranjit and i have a problem in MS access when i am running query it's consume 2GB space in my PC ....
and same query running in another PC it's taking 200MB space ....i have repaired the access but still not working and i hve a 2003 version but its showing 2000 why (OS 2k Professional....Office 2003 PROF)
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To parse a Text field that contains two words separated by a comma, follow
Open any existing database.
Create a table with the following structure:
Table: Parse2Words ------------------ Field Name: Empl Data Type: Text
View the Parse2Words table in Datasheet view and type the following
three records in the Empl field:
Create the following query based on the Parse2Words table:
Query: QueryTest ------------------------------------------------------------------ Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1) Show: True Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1) Show: True
NOTE: You can modify the QueryTest query to account for spaces between
the two parts in the Empl field. For example, if the text in the Empl
field is "Smith,John" without spaces, remove the -1 from the FirstName
Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below:
FirstName LastName -------------------- John Smith Laura Callahan Andrew Fuller
I have fixed my problem. I realised that the Microsoft Access Database DSN did not include the *.accdb driver. I deleted the existing DSN and created a new one. This allowed me to select the ODBC driver that worked for both file types.
I cameto realise that I was only having this problem on machines that have been upgraded to excel 2007 and not on machines with full virgin installations. On install both try to create the appropriate DSN but one with the same name already exists on the machines being upgraded and the creation fails.
Try using Data > From Other Sources and select From Microsoft Query. In the Excel sheet, select the cell that you want the results to start in. Your MS Query would be pulling the data from your Access database.
open your table in query, follow steps to do this...
1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.
I do this on a routine basis. In Access select the table or query that you want to convert to Excel. Then File, Export, You then will see a Dialog Box that allows you to select the format and file name.
That procedure can also be performed using Access Macros for an automated solution.
Are you familiar with "Linking" tables in Access?
In Access: File --> Get External Data --> Link Tables.
This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.