1
vote
0answers
23 views

Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...
0
votes
0answers
26 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl after restart the ...
0
votes
1answer
37 views

Access Database design when changing course fee after certain period of time

I currently have three tables: student id (pk) , name course id (pk) , course_name , course_duration , course_fee student_course student_course_id (pk) , student_id (fk) ...
2
votes
1answer
56 views

How can I sync Access databases and keep them up-to-date?

I have an Access database on my server. We split it up and use the front-end database for search data and adding new records or reports in local computer. If we update or add a new record, that writes ...
0
votes
0answers
7 views

Inline images in RTF Memo field or other methods for dealing with inline graphics in MS Access

I want to use Access to organize some testing information. I will have normal data fields, but I need some type of way of having text combined with images stored in a memo field. I have already ...
0
votes
0answers
44 views

Access database shows as read-only on one workstation (unless logging in with domain admin privileges)

We have an Access database stored on a central server on our LAN, accessed by 20 domain-joined PCs (15x Windows 7, 5x XP). For some reason, one of our XP workstations only allows users to access the ...
0
votes
1answer
144 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
0
votes
0answers
35 views

Access Database Tables

I have taken over responsibility for an access database not designed by me that I need to clean up. I have a table that I need to find out how it is calculating data. I can't find that it is based ...
0
votes
2answers
298 views

Best way to share an Access database

A company who I admin for is looking to create a database for vendors to be able to access their trackers to follow the progress of their projects. I want to build the database in access, but my ...
0
votes
0answers
9 views

Short cut to move in sub-mask in MS-Access

I have a mask with 3 different sub-masks in this layout main (level 0) submask1 (level 1) submask2 (level 1) submask3 (level 1) when I use to entry data I can move the cursor using TAB. After ...
1
vote
2answers
110 views

Problems with MS Access running slowly?

I have to use MS Access in a remote location nearly ten miles from the servers where the database is stored. Here are some of my impressions: I am under the impression that the connection between ...
0
votes
0answers
247 views

We need to open an unknown .dat file

We have an unknown .dat file By a text editor on first of file it says: Standard Jet DB I tried to open it by Microsoft Access but it says enter password. I tried to recover password by "access ...
0
votes
1answer
40 views

Linking two entries in a list

I'm a keen DOTA 2 player. It's a 5-a-side team video game where you play one from a pool of about 100 heroes with different abilities and strengths and weaknesses. I often play team captain and it's ...
0
votes
0answers
11 views

Is there any way I can access an access database I set to read only from other computers on another computer?

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this? Thanks Edit: The database is a .accdb I changed the ...
0
votes
1answer
379 views

Access: How to match/relate records to each other within the same field?

In my Access Database is a table with project information, the ID is 'projectnumber'. I want to be able to match/link/relate different projectnumbers (all stated in the same field) to each other. So ...
1
vote
1answer
75 views

Access Query for Positive Checkboxes

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc. Say for example i wanted ...
0
votes
0answers
427 views

Ms Access : “Unrecognized Database format”

thanks in advance, i have an VB6 project which use the database ms access 2000. With some electricity problem i lost the database file from project, but with the help of some recovery based tools , i ...
0
votes
1answer
304 views

Can Access display a related field on a data entry form?

Let's say I'm building an Access database to hold recipes and calculate the cost of those recipes. I need a table of recipes, a table of possible ingredients, and a table of recipe line items. Each ...
0
votes
1answer
264 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
1
vote
0answers
43 views

Restrict use of Microsoft Access? [duplicate]

Possible Duplicate: Restrict use of Microsoft Access? I'm trying to remove the ability for non-administrators to create databases in Microsoft Access. My issue is that people are creating ...
0
votes
1answer
2k views

MS Access: Force input mask characters in field

I have a mask that looks like 0\.00\.0000 which is used to force serial numbers to look like 1.20.0034. The problem I have is that the dots (.) are not put in the database field. How can I use an ...
0
votes
0answers
103 views

How can I sum up sub-datarecords in a calculated field?

I'm building a little Music Database with following tables: I would like to sum up the total count of tracks in the Table 'albums' as calculated field. I created a Query with SQL that groups to ...
1
vote
0answers
109 views

Best approach to doing automatic analysis of sets of tags in Excel/Access/or similar?

I have a large set of open-ended responses to a survey (~10,000), and each has been assigned a set of tags representing what the person has said in the response. This data is sitting in an Excel ...
0
votes
0answers
228 views

Access 2012 - Can't find object

When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
0
votes
1answer
926 views

Form no longer updates table; what'd I do?

I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
0
votes
1answer
39 views

Is there a way to see preexisting relationships in a database?

I'm using MS Access 2007 and working on cleaning up a functioning database. I want to see the relationships between the tables and queries at will, but the closest I can get is the object ...
0
votes
2answers
756 views

How to convert access database to firebird format?

Is there a way to directly convert an access database to fdb(firebird) format using microsoft access? If not what's the best way?
1
vote
2answers
3k views

Linux Mint (Ubuntu) Microsoft Access Replacement?

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...
0
votes
1answer
946 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
2answers
82 views

How do I relate these access tables without losing data?

I have an excel flat file with about ~6k records I want to put into a MS Access database. The original Excel fields are: Name Address City State Zip DOB CaseNumber DateSentenced AmountDue I saved ...
3
votes
6answers
10k views

How to port an Access database to the Mac?

I am 100% Mac now, but have an important Microsoft Access database on an old PC. Every few months I have to break it out to get into the database. What are my cheapest options for liberating myself ...
0
votes
1answer
46 views

Comparing Access Tables

I have two Access database tables containing place names. Table A contains 30,000 places and Table B contains 25,000 places. How can I end up with Table C that only contains the 5,000 places that ...
3
votes
2answers
5k views

MySQL form builder like MS Access

Are there any good tools out there (don't have to be be free) that provide functionality analogous to MS Access but for non-MS databases like MySQL? I'm looking for more than just a query builder ...
0
votes
1answer
125 views

Block identical entries on a junction table in MS Access

I have two tables, students and class, which are joined by a students_classes junction table (with the student id and class id). How can I prevent identical entries from being entered into the ...
1
vote
1answer
122 views

How to select values within defined ranges and match them against others?

I have an Access database, built from a survey of university students. Among other things, there are fields for how many hours a week the students dedicates to reading class material, and, if they ...
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 ...
1
vote
4answers
826 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
2answers
652 views

Separate tables or single table with queries?

I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
0
votes
1answer
281 views

Total an access database by quarter?

I'm looking for a way to split a large block of data in access into quarters and then total all of the data by quarter. I know how to generate a report and have it break everything off into quarters ...
0
votes
2answers
644 views

Condensing and grouping results from a database in Access or Excel

What I have to do is take the results from a database, and condense them all into one line per date. Right now, each date has numerous amounts of rows, and the data I need is spread throughout each of ...
2
votes
2answers
1k views

Is there any good way to encrypt my ms access database?

After installing my desktop application any body can see the database on their local systems. Even if I set Password security on access database its not going to work.Encryprion may be one of the good ...
4
votes
3answers
10k views

Remove the password from Microsoft Access file

I have an mdb file on my computer, but unfortunately I have forgotten my password, so I can not open it now. Is there any way to remove this password or some other way to open this file?
5
votes
4answers
5k views

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
0
votes
1answer
1k views

How can I specify rules for foreign keys in Microsoft Access using SQL?

I have to create some tables in Microsoft Access using SQL sentences, and some of the tables have foreign keys. I would like to specify the constraints and rules for foreign keys using SQL: Whether ...
1
vote
1answer
1k views

How do I get Dynamic Images to show up on each Microsoft Access 2007 database for reporting?

I'm finding it difficult to get MS reporting working to what I'd like to show. What I'm trying to do is: a) In my database store a URL file (HTTP external file), that is a .jpeg. I'd like to use ...
2
votes
0answers
238 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
2answers
5k views

How can I display images on a MS Access 2007+ form with a hyperlink source?

I am looking to improve the efficiency of an Access 2010 database by using a web server with images and only storing the hyperlink source in the table, i.e. http://www.images.com/images/image1.jpg ...
0
votes
2answers
3k views

How can I publish MS Access project (forms and all) to the web?

I'm not sure if this is even possible with Access 2007 (or 2010 Beta), but I would like information on ways to make a project with forms, macros and modules accessible via the Web. Any good links or ...
1
vote
2answers
879 views

How to swap first and last names in MS Access

I have an Access database where a column of fields contain names where the first name is first and the last name is last. Id like to be able to swap then around so they are Last name first, first name ...