It commonly uses the Jet or ACE database engine, but it is not limited to these. Microsoft Access is part of the Microsoft Office Suite.
0
votes
0answers
11 views
Microsoft Access: computer freezes when user tries to update record
A colleague and I have developed an Access 2003 database which is used throughout our department. Currently about four dozen people do data entry using one of two very similar forms.
If 47 of us use ...
0
votes
0answers
10 views
Any loss of functionality in linking tables in different MS Access databases?
I'm just learning access, and I'm not a DB person. I've always used excel to store information.
I've read that an access DB is limited to 2GB, but that you can get around that by linking to tables in ...
0
votes
0answers
12 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 ...
3
votes
0answers
63 views
Undelete records in Microsoft Access
About 600 records in a Microsoft Access File (.mdb) have been deleted. The .mdb file size hasn't changed, being around 20 MB.
AccessFIX (Demo) shows the exact number and contents of the deleted ...
0
votes
0answers
27 views
Allow user to add value to an MS Access table without handling NotInList?
I have a form in Access that queries a table to supply options to a combo box. When I enter a value into the combo box that isn't in the table, I see the following message:
Microsoft Office Access ...
0
votes
0answers
26 views
What is the easiest way to get started using databases with real data? [migrated]
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
0
votes
0answers
25 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
73 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
0answers
71 views
How to lock-down Access 2007 design?
I have an Access 2007 database (.accdb) and I want to lock down settings being changed to it, specifically under menu->Access Options->Current Database->"Display Form" etc.
I understand you ...
0
votes
1answer
87 views
How can I change the default datasheet font in MS Access 2010?
I've never liked the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2010, and for the life of me I can not find out how (via Google or otherwise) ...
0
votes
1answer
128 views
Why won't MS Access 2010 show my list of System DSNs when I attempt to link data tables from SQL Server?
Recently the company that I work for has upgraded my PC from Windows XP to Windows 7. On my new PC they've also update my version of MS Access from 2003 to 2010 and they also gave me a new domain ...
0
votes
1answer
30 views
MS Access 2010 - No way to create new database objects (table/query/etc) via shortcut or right click in navigation pane?
Minor problem I suppose, but is there no way to create new tables, queries, modules, etc in MS Access 2010 without switching to the "Create" tab?
One would expect to be able to right click in an ...
0
votes
1answer
16 views
Adding logic to a sub form in Access?
I have a sub form in Access:
The CopyNo is a combobox that lets me select from the MovieCopies table. When I select one, I want the Title field to show the correct movie title associated to that ...
0
votes
0answers
111 views
Keyboard shortcut to run a query from SQL view in Access 2010?
The title really covers it all - when manually typing a query in SQL View with Access 2010, is there a keyboard shortcut to run the query, like Ctrl + E in SQL Server Management Studio?
If not, it's ...
0
votes
1answer
68 views
Focus the property sheet in Access 2010
Is there any keyboard shortcut in Access 2010 to focus the property sheet? In Access 2000 and 2003, I could press F4 (or Alt-Enter) and then type to change the value or the selected property, or use ...
0
votes
1answer
22 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
2answers
49 views
Limit number of entries based on column value in Microsoft Access
I have a table that contains 3 columns:
ID Auto increment
Username Text
Userclass Number
I want to give every user a userclass – this could be a number from 1 to 20, but I only ...
0
votes
1answer
63 views
Access 2003: Show hidden menus
I'm wanting to investigate a problem with a former colleague's Access 2003 database/application. When I fire up the database, a default form opens; when I press F11 to look at the underlying code, the ...
1
vote
1answer
79 views
Excel 2010 on importing Access datasource: Can I just dump the data into the worksheet without maintaining a connection to the Access table?
I am able to successfully import an Access .accdb table into my Excel 2010 worksheet. However, it still seems to maintain a connection to the data. This is an inconvenience for me because I have to ...
1
vote
0answers
114 views
when creating a pivot chart in MS Access, how to prevent it from updating with every change?
I'm creating a pivot chart view of some data in MS Access 2010. I'm working with a large data set so every operation takes a long time.
My problem is that access automatically re-creates the pivot ...
0
votes
1answer
46 views
What SQL can be used to extract a first and last name from a mixture of name fields
Name field can be a mixture of formats, for example: Mr. First Last, Mr First Last, First M Last, First M. Last, First Last Snr, First M Last Snr, First Last-Last, etc.
0
votes
1answer
39 views
Sharing a Access Database on the web not using Sharepoint?
Is there any other way to have an Access Database shared on the web but not using Sharepoint? I have been looking to figure out if this is a possibility or not. Thanks for your help
1
vote
1answer
28 views
Secure deletion of MS Access data
I have tables in an Access DB (Office 2007) which have confidential/sensitive data which needs to be removed. The remainder of the database need to remain functional.
How do I securely remove/shred ...
0
votes
1answer
45 views
Where are microsoft access tables stored?
Does Access store tables and data outside of the *.mdb file ?
I have a computer which currently has a large working database on it containing some tables with confidential data. I would like to ...
-1
votes
1answer
37 views
Create a query in microsoft Access?
Create a query using all the fields from the Customers table that will show those customers who have purchased a product with the Product ID 2. Save the query as Product and close the query.
How can ...
0
votes
0answers
88 views
Hiding form elements in MS Access
Part of my assignment is to create a MS Access form for a user to easily add new customers, caravans etc to our database. In the form design, I have a ListBox control with all the available actions ...
0
votes
1answer
73 views
Recursive lookup: linking a field to the same table in MS Access
I know it's abhorrent database design, but I'm experimenting to see if I can achieve unlimited hierarchy for a custom tasks manager in MS Access.
I managed to make this by using a lookup to the same ...
0
votes
1answer
79 views
How can I add a field to a MS Access 2002 form which relates to another table?
I have a MS Access 2002 form which basically provides text boxes to manipulate records in a table called Materials. I also have another table called MaterialCosting which has a column MaterialID which ...
0
votes
1answer
66 views
In MS Access 2008, how do I search for asterisks (*)
As * is a wildcard character that matches any string, it gives me the first row, not the first row containing an asterisks.
0
votes
2answers
97 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?
0
votes
0answers
121 views
Using SQL Server Migration Assistand for Access to fi and import queries to views
Im trying to use SSMA to migrate my Access queries over to views but Im getting TONS of errors, which is racking up an estimated 66 hours of manual conversion time.
The biggest offenders are the ...
1
vote
1answer
65 views
connecting to sql server from access for multiple users
I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize ...
0
votes
0answers
36 views
Big space in a header form in Access 2007
I write a header form in Access 2007.
I have a details section and a footer form section. In the details section I have 3 rows of data.
In Design view, I put the footer form immediately after the ...
0
votes
1answer
114 views
Microsoft Access does not print all data shown in the preview
We are using Microsoft Access and HP printers.
Some reports created in Access show up all data which should be printed in the preview, but when it comes to printing, there data missing on the paper! ...
1
vote
2answers
195 views
Access 2007 - Lock users out of form design mode
Is there a way to lock users out of being able to view and edit a form in design mode in Access 2007?
0
votes
0answers
47 views
Passing a result set to a subform in access 2003?
I have a report in Access 2003 which contains a subform. This report is designed to be run over a range of dates, and is displaying the sum() of the query's fields in the group footer section of the ...
3
votes
1answer
154 views
How to automatically create Excel graphs from Access data
I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month.
Is there a ...
3
votes
2answers
472 views
SQL Server 2008 R2 (x86) and the Access Engine
All,
I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
1
vote
1answer
82 views
Creating a database of MDB extension using Outlook 2007
I have a resolute unyielding need to create an mdb database for a client of mine.
I am tearing my head over this, but I am not getting anywhere.
I have access to these tools
Microsoft Access 2007 ( ...
0
votes
0answers
120 views
MS Access ADP front end and SQL Server back end for field data collection?
I am an anthropologist. I am going to the field and will use a netbook to collect survey data. The survey forms will need to allow me to enter data into multiple tables, search tables, allow subforms, ...
0
votes
0answers
166 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
0answers
55 views
Provider error on localhost, when moving from xp to windows 7
I am a developer with xp, vista, 7, and apple air. My app works fine on xp, but on 7 gets:
"Provider cannot be found. It may not be properly installed"
with Provider=Microsoft.Jet.OLEDB.4.0 (I ...
0
votes
0answers
143 views
How to create a flowchart from an Access database switchboard
I have an Access database that a higher up created for everyone to use that has about 5 levels of submenus in the switchboard. For new people trying to find everything is there a program or a way to ...
2
votes
1answer
24 views
Updating Access 2002 in WINE?
I am looking at running Access 2002 for our company inside of WINE so we can start to break away from our older Window 2000 / XP systems and make a move to Ubuntu.
The only problem I am running into ...
0
votes
0answers
50 views
Change path for linked table in Microsoft Access 2000
I have a Microsoft Access database which is already linked with many tables in Oracle. I want to add few more tables to that from different server of Oracle.
If I connect to the server through ...
0
votes
0answers
140 views
Changing the target type of a shortcut on Windows 7
I'm having an issue with a program installed on someone else's pc with the 2007 Microsoft Access runtime. The runtime that comes with the program is Microsoft access 2007. However, once the program is ...
0
votes
1answer
64 views
How to get shortcut to point to the correct program in Windows on access install
I'm having an issue with a program installed on someone else's pc with the Microsoft Access runtime. The runtime that comes with the program is Microsoft access 2007. However, once the program is is ...
0
votes
0answers
60 views
Access 2007 runtime installed software tripped up by Office 2010
I have a shareware program that uses the Access 2007 runtime to run on installed systems. However, it is having a problem on a Windows 7 system than I believe has Microsoft Office 2010 Professional ...
2
votes
0answers
145 views
Access 2010: The Oracle client and networking components were not found
I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle":
ODAC112021Xcopy_32bit
win32_11gR1_client
But alas it will not work!
I'm on Windows 7, using Access 2010.
...
0
votes
0answers
24 views
Getting Access 2000 to output CSV with quote “only where needed”
Does anyone know how to get Access 2000 to output a comma-delimited file in this format:
Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234
NOT like this:
Bad> "Cat", "John, Doe", "32", ...
