0
votes
1answer
18 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
29 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
0
votes
1answer
35 views

Cascade combo box query sorting

I have a question regarding ms access 2007 query sorting for the cascade combo box. As i have initially 3 tables with names country,state and city and i want to have a combo box such a way that if i ...
0
votes
1answer
91 views

cascading combo boxes and queries in access

I am using access. I have queried a table using a form to trigger the query, with three combo boxes(cascading) the results how ever are not based on the three criteria, only the first. The code below ...
0
votes
0answers
9 views

Is there any way I can access an access database I set to read only from other computers on another computer?

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this? Thanks Edit: The database is a .accdb I changed the ...
0
votes
2answers
73 views

Combining two Excel sheets

I ship a lot of items to a lot of stores and I have two Excel sheets. I have one sheet showing how many items I have shipped to each store and another sheet showing how many I have sold in each store. ...
0
votes
0answers
52 views

Access Query Designer Woes — select by multiple values not working

Table 1 Names Table 2 Services If I do a simple select of both tables together, I get a list as follows: Name1 Service X Name2 Service X Name2 Service X Name2 Service Y Name3 Service Y Name3 ...
0
votes
1answer
382 views

Append a record's field value with a string in MS Access SQL

I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end. For example say there's a field called AccountNumber and for a certain ...
0
votes
1answer
402 views

Display vs Value in a Microsoft Access Form's dropdown box

I'm a n00b at Access, so I might not be approaching this in an Access-y way. Say I have two tables, A and B. Every A belongs to a B, so A has a column B_id which is constrained to match the id ...
0
votes
1answer
241 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
1
vote
2answers
6k views

How can I get a list of fields AND respective tables used in an MS Access 2010 database?

I know this is how you get a list of all the tables in the database (and more if you modify the critieria: SELECT * FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); But ...
0
votes
1answer
140 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.
3
votes
2answers
3k 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
0answers
229 views

Mirror a Microsoft Access 2007 file as a SQL database?

We have a Microsoft Access 2007 database that we would like to mirror as SQL database (typically MSSQL or MySQL, but we are flexible here). The mirrored database is only used for read-only purposes. ...
0
votes
1answer
653 views

Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.? The query has the globe to the left of ...
0
votes
1answer
1k views

How can I specify rules for foreign keys in Microsoft Access using SQL?

I have to create some tables in Microsoft Access using SQL sentences, and some of the tables have foreign keys. I would like to specify the constraints and rules for foreign keys using SQL: Whether ...
1
vote
2answers
827 views

How to swap first and last names in MS Access

I have an Access database where a column of fields contain names where the first name is first and the last name is last. Id like to be able to swap then around so they are Last name first, first name ...
1
vote
3answers
1k views

Access - Merge two databases with identical structure

I would like to write a query that merges two Access 2000 databases into one. Each has 35 tables with identical fields and mostly unique data. There are some rows which will have the same "primary ...