Search Result

Hello -

I have an Access 2010 database that has a front end and a back end. Both are located in a shared folder on our server.

I am trying to work through the process of publishing this database to SharePoint 2010.

When I run the Web Compatibility Checker, I get the following errors:

Relationships that are not associated with a valid lookup field are incompatible with the Web.
...

Hello All,

I have a table (Commissions) in Access that has a field (ClientName) that is linked to a "ClientName " field in a "Clients" table. The relationship was made via the LookUp Wizard.

I would like to be able to import spreadhseets of data into the "Commission s" table, however I am seeing an issue every time I attempt it. The spreadsheet in excel matches the field title names for the table...

I'm attempting to merge multiple Access databases into one. They are all of the exact same format but with different datasets. Using the append tool, I can get all of the data into a single database, but the relationships are lost. Does anyone know how to append related data from multiple tables?

Hey guys, i am quite new to this database thing, instructions on the net i find confusing, i was wondering if someone could point me in the right direction

heres what im trying to do:

Create a fully related database that sorts data into seperate tables as records are created in the Primary Table and further info added to the secondary Table via the relationship

what i have:
Primary Table: Items...

Hi All!

I have just received thousands of records which were supplied to me all on one excel sheet.

So I imported the entire spreadsheet into one table of Access and added an ID field set on Auto-number to give each record an ID number. The table has company name, address, some other info about the company, who the contact is (might be more than one), and what type of company they are (to us and could be more than one)....

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF). These steps are descibed as follows:


Note:...