Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
0answers
7 views

In Microsoft Access, can you refresh a table based on XML data?

I have an MS Access database. I have imported a table of data via XML URL. Periodically that XML data is updated and I'd like to replace all the data in the existing table with the new data. The ...
0
votes
0answers
23 views

What is the effect of a Windows 7 file not having a 'file owner'?

I am troubleshooting a difficult to solve MS Access file access problem which has so far defeated every Microsoft Access MVP. The way Access works is that when a user opens an Access db, Access ...
1
vote
0answers
21 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
1answer
25 views

Use VBA in windows to run a python method with arguments in Linux?

I'm using MS Access on a Windows 7 PC as the front end of a MySQL database back end that is stored on a SUSE Linux Enterprise server. Python is installed on the Linux server. The python script I want ...
0
votes
0answers
18 views

MS Access: Set limit on number of records that can have a particular field value

I need help building an expression that concerns four of my fields: Country Text Centr Boolean Centr limit Integer Apply Boolean The number of records that have ...
1
vote
1answer
26 views

How can I convert question marks to quotation marks for every result for a specific field in my MS Access query?

I have a table that stores all data entered into a program online. Every quotation mark, for whatever reason, is converted into a question mark in the table. Ex: "Hello" would look like: ?Hello? ...
0
votes
0answers
13 views

How can I search all tables or queries in an Access 2010 database

I have a very large, custom, built by someone else Access database system with many forms, queries, reports, and tables. I have been asked to change how part of it functions. There is no ...
5
votes
5answers
360 views

Should I use MS Excel or MS Access? [closed]

I want to store my students' information such as marks, etc. And I need a way to make calculations on this information. I also want the application to make it easy to fill students' information (in ...
0
votes
0answers
9 views

Microsoft Access ( split database) form users seeing records added by others?

Is there a way for Microsoft Access ( split database) form users seeing records added by others? Similar to the adOpenDynamic Cursor Type for ADO dataset, i.e. additions, changes, and deletions by ...
-1
votes
0answers
13 views

Access 2010: Making Hyperlinks work

I have hyperlink fields in an Access 2010 database. I imported the data from Excel. They show up on forms as hyperlinks but do nothing when clicked. Whats the problem?
0
votes
0answers
11 views

How can I create a SUM of an AVG Calculated Value in an MS-Access Report

I have an Access Report with: DEPT = Engineering Title = Systems Analyst FTEs = .8 Year = 1 I calculate the AVG[FTEs] in the group header. I need to calculate the SUM (AVG[FTEs]), but Access will ...
0
votes
0answers
8 views

Query doesn't run after I save it

I found a similar issue on another site (http://www.pcreview.co.uk/forums/query-doesnt-work-after-saving-t1167541.html) but there doesn't seem to be a solution. I have the following query: SELECT ...
0
votes
0answers
26 views

MS Access 2010 Query Linked to a SQL 2008 database do INSERT to table in MS Access file

We have about a dozen inherited Access programs written 10-12 years ago. The author is not here now. We are having to add functionality to the Access code. I have never developed in Access. I am ...
0
votes
0answers
43 views

MS Access 2003 - Disk or Network Error - NOT a Network Issue - Remote App - Win 2008

We have a Windows 2008 running terminal services, but as remote apps, not full desktops. There is a single database file, calc.mdb, that gives "Disk or Network Error". If it is accessed by a user ...
-1
votes
1answer
21 views

more instances of MS ACCESS 2003

Please, Could somebody explain to me how to run more instances of MS ACCESS 2003 on the same machine, at the same time.Possible? Thanks
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
0answers
38 views

Using VBA to change criteria on a query based on a table content (in Access)

I'm relatively new to VBA in Access and need help to automatize something. I have a query with my salespeople performance month by month. I use one criteria to filter the information by salesperson. ...
0
votes
0answers
29 views

Some images do not display on Access Report though image url is valid

I created a report in access 2010 with an image that is controlled by a text field in a table that stores the image URL (thanks to the solution here). The report has about 500 records (each with it's ...
0
votes
0answers
16 views

Can I use a custom form designed in Adobe Illustrator for Reports in Microsoft Access?

I want to create a custom form in Illustrator, but use that form as a report in Access (i.e., I want to be able to pull data from Access and place the text over my pre-existing form that I design in ...
0
votes
0answers
13 views

In Access, how can I reset the AutoNumber field as new data is deleted/appended? [duplicate]

Essentially what I have is a temporary table which logs data through an append query. This table is used to store consecutive strings of data, that will be exported to a .csv eventually. What I'm ...
0
votes
1answer
15 views

Strange behavior with keyboard shortcuts on MS Access Form

This is an odd one. On a MS Access 2007 form, I am getting intermittent copy/paste keyboard shortcut problems. I will select text, hit Ctrl+C, and my text is replaced with a letter "c". I then try to ...
0
votes
0answers
15 views

Textual representation of Access database structure

Quick question - I want to have a textual representation of the Access database that I am writing code against. A simple list of fields, field types, relationships, etc. How do I get something ...
0
votes
1answer
33 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
0
votes
1answer
36 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) ...
0
votes
1answer
25 views

Creating Image Reference upon XML Export in MS Access

I'm automating catalog creation with a MS Access database and Adobe InDesign. I would like to save the file paths to images in the database, and have them become meaningful tags in XML upon export ...
2
votes
1answer
45 views

How to import Dates from Excel into Access with text in some cells?

I am attempting to import a date column from Excel into Access. The problem is that over the years, users of the Excel spreadsheet sporadically inserted text notes into this date column a few ...
0
votes
0answers
57 views

MS Access “Object or class does not support the set of events” error when opening a 2003 mdb under 2013?

I am trying to open an Access front end to a set of SQL tables. The mdb is in 2003 format and I am opening it in Access 2013. When the main form opens there is an event triggered. I have remarked out ...
2
votes
1answer
149 views

When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...
2
votes
1answer
55 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
22 views

Access relationship - First- and last name into Artist

So here is my question. I am pretty new to relationships in Access and I am currently stuck. The thing I want to do is get First name AND Last name into Artist, right now when I try doing it I only ...
0
votes
0answers
76 views

windows 7 remoteapp: access only necessary files to run only one program

I like to set up a windows 7 desktop pc to be a remoteapp server to share the work on an ms access database (but not the desktop). I set up a test user on the server, installed ms access, and did an ...
0
votes
1answer
23 views

What ordering is used in Access 2010 XML export?

What ordering is used by Access 2010 when the Export > XML File dialog is used? I'm trying to discern the sorting but I can't see it, even though the export file is the same every time. ...
0
votes
1answer
50 views

Exporting, externally modifying then re-importing data with MS Access

I'm working with a client who has a large legacy MS Access 'application' with tens of database tables. As it stands, only 1 person can update the database at a time as it is non-distributed; ...
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
1answer
67 views

MS Access subform not allowing data entry after upgrading from 2003 to 2013

I have "upgraded" an Access application by importing all the forms and code from an Access 2003 MDB file to a 2013 ACCB file. After relinking all of the tables most of the forms work properly but I ...
0
votes
0answers
42 views

Duplicate SQL Server Database with Access Front End on Remote Machine

I used the SQL Server Migration Assistant to move an Access back end to SQL Server 2008. I tested it on my SQL Express, but actually did the migration via terminal server on my client's machine. The ...
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
208 views

Access 2010 Table appears to be locked and can't be modified? How do I unlock it?

I have rather simple Access 2010 database. I needed to add a new field to one of the tables. While in Datasheet View, I Clicked the "Click to Add" column header and defined a new field. I went to ...
0
votes
1answer
23 views

How to not have Show Table Dialog for new Access query

In Access when I go Create > Query Design it creates a new query window and automatically pops open the Show Table dialog. I don't like to use this and instinctively hit esc. I either go straight ...
0
votes
0answers
28 views

How to get Access 2010 query to number based on criteria from other columns

I have a query where it pulls the ID and Employee columns and I am trying to get Access to populate the data as shown in the 'OrderCol1' and 'OrderCol2' columns of the table below. As I'm sure you ...
1
vote
1answer
64 views

Unable to edit data on datasheet in Ms Access 2013 - Get write conflict

I have been tasked with converting an old ADP project to something that Access 2013 can handle. I've imported all the forms and VBA, relinked the tables and changed the connection to an ODBC ...
0
votes
0answers
63 views

Edit record on grid in an MS Access subform will not allow saving changes?

I am troubleshooting a form that was created in an older version of Access. There is a datasheet view on a subform of the main form. This form shows data but it will not allow me to edit the data. ...
0
votes
1answer
26 views

Where can I change the connection to a SQL db in Access 2013?

I can not seem to find the place that allows me to change the connection to linked tables in Access 2013. Mine is currently pointing to a test database and I want to change that to the production DB. ...
0
votes
0answers
12 views

Troubleshooting an Access rowsource query with a server name specified?

I have a list box rowsource query that addresses a specific MS SQL server in it: SELECT DISTINCT alistname FROM differentserver.dbo.Inventory ORDER BY alistname When I try to run this query in ...
0
votes
0answers
115 views

How to do a cross apply in MS Access?

I have a cross apply query that I wrote in the SQL Server Mangement Studio where I can't seem to figure out how to write the same query in MS Access. I know how to do a GROUP By in MS Access the ...
0
votes
0answers
13 views

Is there a way to prevent the Action Catalog from opening when a macro is opened in design view?

I'm aware I can close it after it opens, and it stays closed for further macros, but that first time it makes opening the design view irritatingly slow.
1
vote
0answers
117 views

MS Access 2010 Expression error when using Column filter - “The expression ”|“ you entered is invalid.”

This a very odd problem and I am hoping that someone here can figure it out. I get this error when working in a database and trying to FILTER a table by column and more than 1 value. “The expression ...
0
votes
0answers
79 views

Microsoft Access - how to show document location in quick access toolbar?

In Excel 2010, I am able to show the location of a workbook by adding "Document Location" to my quick access toolbar (this is found under "commands not found in the ribbon). This is shown in Excel ...
0
votes
1answer
95 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
0answers
74 views

Use subform value when saving record from main form in Access

I have a main form and a subform. When I create a new record with the main form, I need it to save the value from a subform into the main form's table. I have a text field bound to ...