Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
2answers
19 views

Generate list of Microsoft Access database tables

How do I have Microsoft Access generate a list of Database tables? I came across an SQL query someone suggested on anther website however Access doesn't seem to have any interface to simply allow ...
1
vote
2answers
10 views

Error exporting Access database table to new database, can't find what should not yet exist

How do I export a Microsoft Access database table in to it's own *.accdb database? When viewing the list of tables on the left column under the "Tables" category I can right-click and export but when ...
1
vote
1answer
14 views

Export MS Access 2010 SQL

Using Microsoft Access 2010 how do I export the SQL to an SQL file? The output should be similar to how phpMyAdmin exports SQL; a phpMyAdmin SQL export file can be imported to a database via a source ...
0
votes
1answer
11 views

Expression in Access involving dates

I have written the following formular in Excel to calculate the year a person will be 18 by 1st September based on their DoB (in cell F2). It seems to work ok in Excel: ...
0
votes
0answers
4 views

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
-1
votes
1answer
15 views

MS Access 2013 Online - How to add SQL?

I have been using other versions of Access that allow for easy reporting and SQL. I am trying to use the MS Access 2013 Online Web App but I can't seem to use SQL. Where is the feature for querying ...
0
votes
0answers
6 views

MS Access Form input to text box changes to a number when form is saved

I have been asked by my employer to "fix" a database error. There is an Access form in which there are several text boxes. One of the boxes is for the Last name of the individual added to the ...
1
vote
0answers
11 views

Microsoft Access database worked before and now old records won't update

This code was working fine on Windows 2003 Server. Updated to Windows 2008 Server and now new records can be listed for update or delete but old records can only list record content, but can't be ...
0
votes
0answers
25 views

Microsoft Access Web App - Sharepoint online - user permission only for the app

I want to publish a access web app (2013) with sharepoint online to the web for costumers. I don't want that the users of the app have access to the sharepoint site behind the app, neither that they ...
0
votes
1answer
11 views

Where'd my ribbon tabs go in ms-access?

In MS access 2010, if I create a brand new project, the ribbon has a lot of options and actions. But if I open an existing project, created in MS access 2003, I can't see any of those tabs. Does ...
0
votes
1answer
13 views

Reading a web based datafile every five minutes with MS Access

I have a local webbased datafile that I would like to query every five minutes and save the data in a table. The data is a flat file that I would need to parse if it just went into a table. I am ...
0
votes
1answer
15 views

Reconcile multiple versions of an Access table [closed]

An access mdb file has bounced around between several computers, and old versions of the file have been used on some computers while the copies were being used on other computers. This has resulted in ...
0
votes
0answers
12 views

MS Access - How are reports connected to queries and how can I find out which belongs to which?

I need to understand MS Access reports. I have old MDBs with connected tables from an Oracle DB. Some queries collect data. And reports are used to present data and to send it via e-mail. (~10 queries ...
0
votes
0answers
33 views

How to combine an Excel spreadsheet with word documents using a field from the excel rows matching filename of word doc

I am trying to combine an excel spreadsheet with associated word documents. There is 1 word document per excel line. I have the Excel spreadsheet with all the rows. I have all the word docs in a ...
0
votes
1answer
33 views

Send Email's from Access 2007 with Lotus 8.5

I've this code bellow. It save the email with all receipts but it only send to the first receipt; On Lotus sent folder --> teste@hotmail.com;test@gmail.com On the Receive end --> test@hotmail.com; ...
0
votes
0answers
51 views

Windows Task Scheduler wouldn't launch Access database

I'm using Windows Server 8 and I'm having a real problem launching my Access 2010 database from Task Scheduler. As I can see the problem is not new, but I hope, if somebody found a solution, maybe ...
0
votes
0answers
34 views

Network shared access database: your network access was interrupted access to continue close the database

I have a network with several Windows XP and Windows 7 users accessing MS Access databases over shared files in a NAS Synology. One of the XP users get several times in a day the following message: ...
1
vote
1answer
30 views

I have an Access MDB, I know the password, but how do I Disable it in Access 2013

I have searched around but cannot find how to remove the password on my MDB file using Access 2013. I do know the password so I can open the MDB Ok, but I want to disable the password. One Tut ...
0
votes
1answer
29 views

MS-Access many to many relationship with subform having multiple criteria

In my database design there are 5 tables and i want my database to be able to save the course fee given by student. according to the design one student can enroll in many courses. i want to ...
0
votes
0answers
9 views

Access 2000 multi column reports

I've set, and saved, the page settings for a particular report to use 2 columns. But this save only seems to work for a while. Somehow it reverts back to the default of 1 column. Can I not set it ...
0
votes
0answers
16 views

Linking word with access with ask value at open

I have a Word document that has some fields connected with Microsoft Access and I want that when the Word document is opened, it asks for the ID of the client to filter the table. The document is ...
0
votes
0answers
75 views

Microsoft Access 2010 and 2013 not responding when trying to filter columns

In Windows 8, when we try to use the filter option in Microsoft Access 2010 and 2013 using the keyboard option (arrow keys), the application stops responding. The error occurs only if the rows are ...
1
vote
0answers
15 views

Best way to edit and share database with MS SQL and Access

What is the best way to share with my partners an online database with permissions. Lets say I have a big database and I would to share with them just only the specific rows which where I tick a box ...
1
vote
0answers
12 views

input mask behaving oddly

I am using Access 2010. I have created an input mask 0000\B?. The resultant should be 4 numbers, the letter B and an optional 2nd letter, ie 1234Bx. My problem is the ?. Any time the optional letter ...
0
votes
0answers
5 views

New Data Source to SQL Server: Server not in dropdown

I get to the "Create a New Data Source to SQL Server" in MS Access. There is a drop down to select "Which SQL Server do you want to connect to?", but my local SQL Server Express database that I have ...
0
votes
0answers
16 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
1answer
31 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
64 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
72 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
24 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
32 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
31 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
715 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
21 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
18 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
79 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
187 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
25 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
46 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
83 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
40 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
27 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
14 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
23 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
21 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
55 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
42 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
40 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
199 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
197 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 ...