Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
2answers
264 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
384 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
982 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
20 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: =IF(MONTH(F2)<8,YEAR(DATE(...
-1
votes
1answer
52 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 ...
1
vote
0answers
42 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
1answer
334 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
794 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
30 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
44 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
118 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
62 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
1k 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 ...
1
vote
1answer
2k 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
386 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 ...
1
vote
0answers
44 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
28 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
1answer
43 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
1k 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
341 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 ...
1
vote
1answer
49 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? ...
4
votes
5answers
5k 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
1answer
2k 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
31 views

Run multiple instances of Access 2003

How can I run multiple instances of Microsoft Access 2003 on the same machine, at the same time?
0
votes
0answers
306 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
1answer
104 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
35 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
2answers
1k 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
95 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
190 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
2k 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
2k 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
1k 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
422 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
28 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
494 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
96 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
407 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
1answer
583 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
174 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
6k 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
104 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
70 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 ...
2
votes
1answer
322 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
1answer
299 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. ...
1
vote
0answers
439 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
1answer
350 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
1answer
1k views

Can i input duplicate values in foreign key column

A small but important question can input null and duplicate values in foreign key column connected with some another table with same column identity and values as far of my knowledge it is not ...
1
vote
0answers
674 views

Can't create a COM object in a powershell script running as a scheduled task

I have a powershell script I'm trying to run as a scheduled task. Its purpose is to perform a nightly export from an Access database, then upload the exported flat files to an SFTP destination. The ...
1
vote
0answers
7 views

Showing where infortion was imported from in ACCESS

I have imported a few excel spreadsheets into one ACCESS table but i need to add a column named "source" that will show me where the information was imported from. Any function or coding will help