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
19 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
60 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
1answer
17 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
22 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
24 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
16 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
73 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
57 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
12 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
63 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
1answer
127 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
22 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
33 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
46 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
34 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
46 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
19 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
19 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
75 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
24 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
17 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
57 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
15 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", ...
1
vote
1answer
418 views
“MSCAL.OCX” error when moving from Access 2007 to 2010: I don't have a calendar
I have a database created in Access 2007. When opening it in Access 2010 I get the following error:
"Your Microsoft Office Access database or project contains a missing
or broken reference to ...
0
votes
0answers
50 views
Importing multiple VBA classes/modules automatically or from a single file
I have a schema modelled in DeZign for Databases which can generate a new Access database, however there does not appear to be any support for storing VBA classes & modules in the model.
When the ...
0
votes
0answers
38 views
How to install a DSN for MS Access in Windows 7 32 bit?
How do I install a DSN for Microsoft Access in Windows 7 32 bit?
I have installed Windows 7 on my MacBook Pro using Boot Camp. I have installed Microsoft Access 2007 on Windows 7, and it works fine. ...
0
votes
0answers
72 views
Resetting the permissions on an Access 2007 mdb file
Background story : I need to modify the structure of an access database (add some columns, modify some).
Problem : Someone belonging to the Admins group thought it would be a good idea to remove the ...
1
vote
1answer
35 views
Is it possible to create groups of objects in Access 2010 forms?
I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled ...
1
vote
3answers
45 views
I have Access 2007, but would like to install Access 2003 and have both on my desktop [closed]
Possible Duplicate:
Is having both MS Access 2003 and 2007 on the same computer possible?
I have MS Access 2007 on my desktop, but would like to install Access 2003. Will they co-exist?
1
vote
0answers
25 views
Free software that can recover or remove Access passwords stored in Access Workgroup files
Is there any free software that can recover or remove Access passwords stored in Access Workgroup files?
I found a software called MDWRecovery which is supposed to be able to do this task but I ...
0
votes
2answers
104 views
In Microsoft Access 2007, I am getting an “Error in Loading DLL” when trying to use the label wizard
I am trying to run the label wizard in Microsoft Access 2007 but when i click on; Create - > Labels, I get this error message:
Label Wizard: Error in loading DLL
2
votes
4answers
152 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
30 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 ...
0
votes
0answers
59 views
When using the Access Table Analyzer Wizard, I get the error “Cannot define field more than once”
I'm trying to normalize a very simple dataset:
user_id | role_id
I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table ...
0
votes
0answers
20 views
Open a second form linked to the first form [closed]
Possible Duplicate:
Link new record to existing form
Could someone please tell me how to link a form?
I enter data on a form, click save, then click a button that opens form2 which is ...
1
vote
2answers
344 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
58 views
How to import row data into Access when Excel does a date conversion?
I have an Excel worksheet that looks like this:
MONTH WIDGET QUANTITY COST
Jul-09 Widget1 1000 1.00
... <repeat a few thousand times> ...
I would like to ...
0
votes
1answer
52 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 ...
0
votes
1answer
44 views
Hiding Access 2000 Toolbar button
Is there a way to hide a Access 2000 toolbar button? I have looked in the properties for a toolbar button in design view, but there does not appear to be any properties listed that relate to what I am ...
1
vote
1answer
58 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 ...
1
vote
1answer
81 views
How can I modify tables and forms in a MS Access database using UA Business Software 7.0?
I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0
The problem is that UA hides everything and everything is locked.. It doesn't even look ...
0
votes
1answer
465 views
Where'd my System DSN that I just added go to?
I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle ...
0
votes
1answer
39 views
Link new record to existing form
In Access 2007. We enter a new record on a form. Then we click a button which has a macro action to open another form. What can I do to make the new form open but linked to the new record? I ...
2
votes
2answers
184 views
How can I easily migrate an Access database to MySQL?
My situation:
Earlier, I asked:
What is the easiest way to edit an Access database online?
[...] What is the easiest way to allow people to make changes to that database without needing to ...
0
votes
1answer
55 views
List box value specific to form record
In Access 2007. How can I make the a value from a list box link to the form that the list box is on. Sub-form are no problem, you create the form, then when you add the sub form it asks you what ...
0
votes
0answers
63 views
Microsoft Access PivotTable to Powerpoint
I have a Microstof Access database with a PivotTable Report I would like to copy to Powerpoint. No further processing, just presentation.
I can select and copy the pivot data cells but not the left ...
0
votes
2answers
102 views
Export MS Access query into Excel
In Access, I know that there is a "Analyze it with Microsoft Office Excel" option, but i am creating a database and the person requesting this wants a command button on a form to do the same thing ...
0
votes
2answers
82 views
table relationships with linked tables
Sorry about all the reading - but it really explains my question.
MS Access Table relationships. Question: when I make a datbase and tables are NOT ODBC linked to SQL tables, it's no problem to ...
0
votes
0answers
85 views
Open an Access database with scripting disabled (macros and VBA)
Suppose you want to examine the contents of an untrusted Access database.
It seems there should be a way to open it in Access with macros and VBA disabled.
Searching around the web, I've found ...
0
votes
0answers
40 views
Access 2007 List Box store multi values
When using a list box with multi select set to simple, how can I store the multi values that are choosen. Or is there another way to store multi results from a dropdown. I have to allow my user to ...
