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.
|
3 Microsoft Access FAQs
Group: Microsoft Access
Topic: General, Presales, & Installation
|
Q1. Can I use an Access 2002 application in Access 2003? |
|
Answer: 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
|
Q2. Should I store images in my Microsoft Access MDB database our outside and just store the name? |
|
Answer: 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
|
Topic: Using Data
|
Q3. My Access Application still uses DAO and I'm thinking about migrating it to ADO. Should I? |
|
Answer: 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.
|
|
|