Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
0
votes
1answer
71 views
Access 2003 (SQL Server 2000) migration to SQL Azure
As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
0
votes
1answer
192 views
Connecting to a SQL Server database from a Flash program
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
0
votes
1answer
210 views
Microsoft Office Access database engine could not find the object 'tableName'
First a little background:
I am using MS access to link to tables in an advantage database. I created a System DSN. In the past in Access I've created a new database, and using the exteranl data ...
2
votes
0answers
51 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
2
votes
0answers
431 views
Access 2010 linked table - solve the “decimal field's precision” error
I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
2
votes
0answers
273 views
Parameters in queries using vba
I am trying to write a process to run several prewritten Queries in a row without any human interaction. I tried to write a macro, but the after saving it it still prompted for the date range in the ...
2
votes
0answers
174 views
MYSQL & Access ODBC
I am trying to connect mysql with access, i am settings up the ODBC correctly from the data sources, however i get a driver error.
I am using access 2010 and the driver version of the ODBC conector ...
1
vote
0answers
25 views
Merging two Access tables into one
I have mostly identical tables, however there are slightly differences like missing columns in older ones. I want to merge 5 tables into one. Is there any easy way to do this?
1
vote
0answers
297 views
Missing 'Microsoft Office 12.0 Access Database Engine' in SSMS
I've got several users that need to import / export ACCDB Access files into out of SQL Server.
Unfortunately, I have been unable to get 'Microsoft Office 12.0 Access Database Engine' to show up as a ...
1
vote
0answers
244 views
Implementing a family database using Access 2010
A while ago I asked this question about using Access 2007 to implement a family tree model. I had all the tables and relationships mapped out in a UML diagram but realised it was getting out of hand ...
1
vote
0answers
186 views
How do I auto-fill data in Microsoft Access 2003?
I am creating a Purchase Order Form at work using Microsoft Access 2003 so that it can be saved and archived in a database and reduce paper costs.
These are my current dilemmas:
I am unable to ...
0
votes
0answers
25 views
Missing values in INNER JOIN MS-Access?
When I run the following query in MS-Access:
SELECT a1.ConStateNumber, a2.ConStateNumber
FROM qryW2_yr_sum_slash_qryW2_q4_sum_result a1 INNER JOIN
qryW2_q3_sum a2 ON a1.ConStateNumber = ...
0
votes
0answers
14 views
Performance Slow After CompactRepair Access
I am performing a large number of insert operations using VBA - Access. the VBA code is in a file "control.accdb" performing operations on "data.accdb"
Few tables in the process are created from the ...
0
votes
0answers
48 views
How to update column value in MS-Access by comparing two columns?
I have an Access 2000 table with 10 fields. I want to compare the 2 column and update the third one.
To elaborate :
keyfield cno entno uno
(Text) (Text) (int) (int)
...
0
votes
0answers
52 views
Access 2007 - Splitting single record into component parts similar to Microsoft Money's split transaction (Updated)
I currently import a bank statement into an Access 2007 table and then use a lookup within the table to categorise each transaction. I then use a report to group the transactions into category types.
...
0
votes
0answers
147 views
Is there any in-depth tutorial for ACCESS 2007 Northwind Traders template?
I wanted to learn a little bit more about Access in order to create a sales/inventory analisys tool to use at work. Now I came across this beautiful template on microsoft office's official website: ...
0
votes
0answers
189 views
MS Access trigger
I got a trigger to update a table in SQL.
My actual need is in MS Access but I could not make it. So please help me to write the same trigger in MS Access.
Query is as follows:
Create trigger ...
0
votes
0answers
85 views
Being careful about additional records being added in a duplicate record merge?
We have a multi-user MS-Access 2003 database. Connecting to it using SQuirrel SQL, and the JDBC/ODBC bridge, I've managed to eek transactions of some sort out of JET by turning off autocommit. I've ...
0
votes
0answers
100 views
Connecting to a remote production MS-Access 2003 database that has Workgroups with SquirrelSQL?
I'm trying to connect to an MS-Access 2003 database using SQuirrelSQL and the JDBC-ODBC Driver.
I have the database shared on a network share mounted on drive D:
In SQuirrelSQL, I add an Alias like ...
0
votes
0answers
797 views
How to bulk import multiple CSV files into master tables with variable field names?
As a learning exercise, I am trying to map several data files into a few master tables. Right now, I have a file hierarchy as follows:
<Root>
- Client 1
- CustomerInfo.csv
- ...
