Question about Business & Productivity Software

1 Answer

Restriction on import of forms and tables in msaccess

Please tell me that Can i restrict the tables, forms etc to be imported in any ms access file from my file. how???
please also tell me from where i can download the ms access only free, which is a single setup file which can install only ms access. Thanks - Chetan

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert who has answered 1,000 questions.

  • Master
  • 1,554 Answers
Re: Restriction on import of forms and tables in msaccess

I could not understand the 1st question clearly.
as for the second question you can download microsoft viewers for any office product at their site. they can view files only.

Posted on Feb 03, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

7 Answers

MS Access database recovery

Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information:

If doesn't help, look here:

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

7 Answers

Undelete records from access table

ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer


this discussion could go on for days (month? a semester at least?) but data is any piece of information you want to capture and save. a name. an address. a phone number. (actually they are examples of pieces of data - and whether you capture and save them or not they are still pieces of data). data "forms" a database when you save it (in the dataabase).

the database usually has tables representing related pieces of infomation.

the CLIENT table may have the following fields:
Client Number
Client Name
Contact name
etc., etc.

the ACCOUNTS_RECEIVABLE table may have
Client Number
Invoice Number
Invoice Date
Invoice amount
etc., etc.

Notice how the CLIENTS table is "related" to the ACCOUNTS_RECEIVABLE table by the Client Number - hence the term you may have heard RELATIONAL database.

any more in depth please ask.

Mar 04, 2009 | Microsoft Business & Productivity Software

2 Answers

Steps in saving file in excel to database

severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

3 Answers

Connectivity between HTML page and Ms-Access

Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>

Nov 11, 2008 | Microsoft Office Standard for PC

1 Answer

Code for find the Ms access database size using visual basic

The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()

Nov 10, 2008 | Microsoft Office Standard for PC

1 Answer

Image import in pagemaker

open image with microsoft image editor. select copy and past in to pagemaker. this wil fix your problem.

Feb 26, 2008 | Business & Productivity Software

1 Answer

MS Office releted

This is not a simple ordeal. You can keep the Excel files and link to the data, or try to import the data into Access tables. It all depends on the specific need and that existing data.

A very thorough description of the process is available at:

Jan 23, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Ms access

before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Business & Productivity Software

1 Answer

MSACCESS Multi user APplication

Access is never good for multi-user with more than about 10 users! MS say: use SQL server. Of course, it all depends on the complexity of the app, the amount of data, transaction rate etc. You can also try putting the backend on a "real" server (15K rpm SCSI or sSCSI disc, Xeon CPU) and give it as much RAM as you can afford (at least 4GB) then you might get reasonable performance. If you can't do it any other way & a licence for MS SQL Server is out of the question, use MySQL as a backend: you can make Access clients talk to it as there is a free Access driver for it. You can even run MySQL under windows: you don't need Linux (although it will run faster under Linux). Setting it up is fairly easy and it will outperform an Access backend by at least an order of magnitude, if not 2 or 3 :)

Sep 19, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides