Your full service technology partner! 
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► KBAccess Knowledge Base  Print This    All Groups  

Access FAQ Page

These FAQs are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the Access sub-topics.

Contribute a FAQ
Expand All

3 Microsoft Access FAQs

Group: Microsoft Access

Topic: General, Presales, & Installation

-Collapse +Expand Q1. Can I use an Access 2002 application in Access 2003?

Yes, you can either convert it to Access 2003 format or leave it as 2002 format and use it with Access 2003.

Posted By Mike Prestwood, Post #100920, KB Topic: General, Presales, & Installation

Topic: MDB DB & Tables

-Collapse +Expand Q2. Should I store images in my Microsoft Access MDB database our outside and just store the name?

Store the image outside of your MDB Access database. There are many benefits to storing it outside of Access including the following:

  • More easily work with all the images at once.
  • avoid the overhead of an OLE server
  • decrease the size of your MDB file
  • easily reuse images with other development tools such as a website, VB, VS.Net, etc.
  • Metadata is preserved
Posted By Mike Prestwood, Post #100911, KB Topic: MDB DB & Tables

Topic: Using Data

-Collapse +Expand Q3. My Access Application still uses DAO and I'm thinking about migrating it to ADO. Should I?

No, especially if your accessing Access tables. It is true that ADO is more widespread but if your application is working with DAO, then there's no significant reason to switch. If you're starting a new Access Application that accesses Access tables, I would use DAO. If you're accessing a SQL server such as MS SQL or Oracle, I would use ADO.

Beside DAO and ADO, developers can also use OLE DB and ODBC.

Posted By Mike Prestwood, Post #101453, KB Topic: Using Data
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2022 Prestwood IT Solutions.   [Security & Privacy]