Question about Computers & Internet

1 Answer

Problem in MS ACCESS

HI,
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)

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 329 Answers

You need to upgrade first your operating system.. the new version of office 2003, is no compatible to your windows 2k.

Posted on Apr 04, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to invoke a ms.access using parser


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. 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 field expression.
  5. 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

Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Same as above really


Hi,
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.

I hope this helps others.

Jul 18, 2009 | Microsoft Excel for PC

1 Answer

Using Microsoft Query to bring Access 2007 data into a spreadsheet


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.

May 04, 2009 | Microsoft Excel for PC

1 Answer

How to print only selected fields in ms access.


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.

hope this will help you....

Oct 22, 2008 | Microsoft Access 2002 for PC

1 Answer

Creating a table in Ms-Access


Have you tried to name the table Tiny_tots? it might make it work. Sometimes programs are funny about letting you have spaces in the name.

Oct 04, 2008 | Microsoft Office Standard for PC

1 Answer

MS Access


Use a query:

SELECT "000" & [LastName] AS NewName
FROM MyTable

And export this query to the text file on your C: drive.

Jul 11, 2008 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Ms access to excel


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.

Hope this helps.

Oct 11, 2007 | Microsoft Office Standard for PC

3 Answers

Viewing ms Sql Server database on Access


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.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...