Topics Search

Access 2007 Database Properties

Access 2007 Database Properties
Views: 4
I have a split database for tracking help desk issues. The front-end exists on several desktops. The back-end resides on a shared network drive. To do some testing I wanted to move both parts to my personal network drive, then change the database properties if possible to recognize one another. Tried the obvious w/o any success.

and if so, how can I connect or relate the two ends in the new location?
Sponsored Links:

Similar posts...


How to Change Form Properties in Access 2007

How to Change Form Properties in Access 2007 Icon
Form properties in Access 2007 determine a form's characteristics. The controls and sections on a form also have properties that determine the appearance, behavior and structure of that control and the data it contains. Form properties may be set with the property sheet. The following steps will show how to accomplish this in Access 2007.

Import an Access 2.0 database into an Access 2007 file

Import an Access 2.0 database into an Access 2007 file Icon
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb).
To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format.
The following sections in this article explain how to perform each of these tasks.
What do you want to do?
* Open an Access 2.0 database in Access 2007
* Import data from an Access 2.0 database
* Convert an Access 2.0 database by using Access 2003, Access 2002, or Access 2000

Functions and properties in Access 2007 blocked by sandbox mode

Functions and properties in Access 2007 blocked by sandbox mode Icon
This article provides reference information about the functions and properties that sandbox mode allows and blocks in Microsoft Office Access 2007. Note that Office Access 2007 allows several new functions to run in sandbox mode, including MonthName and StrReverse, and it now blocks several more functions, including Assistance, ExportNavigationPane, and LoadCustomUI. As you proceed, remember that you must trust (enable the content in) the database or place the database in a trusted location for the information in this article to be of use.

Printing the properties of an object

Printing the properties of an object Icon
I am attempting to document some of the objects in my database (Access 2007) As an example, how can I print the properties of a form named frmUnpaid_Accts I have tried using HELP, but can seem to find anything - did MS change the way it works, because it looks and feels different to me.

Help secure an Access 2007 database

Help secure an Access 2007 database Icon
This article explains how to help keep your Microsoft Office Access 2007 databases more secure. It explains the concepts that you must understand before you can use the Office Access 2007 security features properly and how to use the tools that Access provides for helping to secure a database.
In this article
* What's new in Office Access 2007 security
* Use an Office Access 2007 database in a trusted location
* Package, sign, and distribute an Office Access 2007 database
* Enable disabled content when you open a database
* Use a database password to encrypt an Office Access 2007 database
* How security works with databases from earlier versions of Access opened in Office Access 2007
* Run unsafe expressions (disable sandbox mode)

Split database & Multiusers

Split database & Multiusers Icon
I've split my database to have 2-3 users access it at the same time over a network.

The properties of the FE & BE are on shared but when I want to open a second copy of the FE it says that my BE is currently being used by another. All locks are set to none.

Using Access 2007. The one person that is using it continually adds reccord. The others are mostly wanting to use the search form.

Are there any other properties that I've missed?

Access 2007 - Property Sheet

Access 2007 - Property Sheet Icon
I just got Access 2007 on my computer and for some reason, it will not allow me to view the properties for a field, much less a form or report. I have right clicked on it and selected Properties.

I have gone to the Design tab and clicked on Property Sheet. Either way I do it, nothing happens. How can I get to the properties for my form?

Custom Database Properties

Custom Database Properties Icon
Often you get the situation where you want to store a single item of data in the database, eg an Author Name, a version, a language selection. The most usual way to do this is to define a global const in a module. This has two problems, it is not updatable, and it is not easily accessible from outside the database. A better solution is to make use of database properties. Learn how to create custom properties on the objects in a Microsoft Access database.

Access 2007 form different color on different pc

Access 2007 form different color on different pc Icon
I have access 2007 database with tabbed forms. On my pc the forms appear pale/white background, the back stlye is set to normal.

When I open the database on a different pc, the back stlye is normal but it appears as dark grey. I have the same problem with command buttons - completing changing the look and feel of the forms

Both PCs have full install of Access 2007, and when I compare Access Options of current database, they both have the same settings. Also note both have "use windows themed controls on forms" enabled.

What is causing the difference in the color of my forms. Both PCs have display properties with color setting at Highest (32bit)

Access to Access 2007

Access to Access 2007 Icon
We have Access 2007 on an office PC. We have a Sales Database, that all of our salesman used to access on this computer. They all had Access 2000. We all got Office 2007 (WITHOUT ACCESS).Do I have to purchase Access on the other computers to be able to access this data, or is there a way to add and/or access this database? Maybe even by internet access?

Keep in mind I am the IT department, I am very, very green when it comes to this stuff, just lay it on me easy.