-2
votes
2answers
17 views

Repair Corrupt Access Database File

I am using MS Access 2010 and one of my databases on our shared network does not open for any user. Shows "Unrecognized Database Format." error message. I can't even get it to the point of opening. Is ...
2
votes
0answers
74 views

Microsoft Access 2010 - error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
1
vote
1answer
490 views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
0
votes
1answer
869 views

Access 2010 forms: direct entry of foreign key into text box

In a form I am creating for an MS Access 2010 database, one of the fields represents a foreign key. I would like this field to be displayed as a text box, rather than as a combo or list box as is ...
0
votes
4answers
4k views

Microsoft Access: How do you create fields with multiple boxes to tick?

I'm using Microsoft Access to fill in information from a questionnaire, which has been answered by 80 people. This is a questionnaire with both quantitative and qualitative answers. I've set it up so ...
5
votes
4answers
8k views

How do I synchronize multiple Access Databases together?

I'm conducting a study, where we will be collecting data using Access. Since there will be multiple persons conducting these studies using the same structured Access DB we need to figure a way to ...
1
vote
4answers
793 views

MS-Access database-upsizing error

I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one... The table that doesn't get ...
1
vote
1answer
1k views

Many to Many Data Entry - Access 2010

I have three tables. Student, Class, and StudentClassMap (many to many) that are laid out like so: Student: SID - PK Student Name Class: CID - PK Class Name StudentClassMap: SID - FK | PK CID - FK ...