Questions tagged [ms-access-2007]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
57 views

How to connect UDL file to a Msaccess DB 2007 (Protected with password)?

The UDL file was connected to MS Access DB 2007 successfully. However, when I have protected the DB with a user the connection failed. Can any one show us how to solve this problem ?
1
vote
1answer
56 views

MS Access 2000 Application - SQL Server [closed]

I have an old MS Access 2000 application which connects to a SQL Server 2000 database. I need to migrate this database and application to a new server with SQL Server 2012. The Access application is ...
1
vote
1answer
39 views

I need to hide an open Access table from users

For application startup I had to open a table as part of some DAO.recordSet code. DoCmd.OpenTable "User", acNormal, acReadOnly On running user tests, I want to distribute the desktop application as ...
0
votes
1answer
505 views

MS Access Crash on DAO connection

Can someone take a look at this code and provide a hint as to what it is I am doing wrong. This code taken almost literally from a reference book, as an example on how to use VBA ADO object. Here is ...
0
votes
3answers
185 views

Restrict Front Ended User access to Form entry only

I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in ...
1
vote
2answers
60 views

Back-end with encription and user-control for MS Access2003-VBA

My client has an Access 2003 "multi-user" (<6) "database" (<3k records) with "encryption" located in a LAN folder and an easy Form I polished with VBA(DAO library). Access 2003 encryption can be ...
1
vote
0answers
103 views

how to edit kvp data as crosstab/pivot

I am keeping data in key/value pairs. I know how to convert that data into crosstab form using queries like this: <!-- language: lang-sql --> SELECT master.tag, MAX(CASE WHEN data.key = ...
1
vote
2answers
27k views

Combine multiple row's records in one row with MS Access Query?

I have a table (name- tbl2) with 21 column but I want to combine multiple rows records in a row by using a unique reference number as below: Table Field and Records Type Expected Result: Please ...
1
vote
1answer
112 views

MS Access : Navigation pane is suppressed

I received a MS Access form client. It is in access 2007 format. Initially Navigation Pane was not available. Only form was visible. Then I choose options->Current database->checked Display Navigation ...
1
vote
1answer
11k views

What DSN file is MS Access using for ODBC Linked Tables?

I set up a linked tables in Microsoft Access to connects to an remote database using ODBC with a File DSN. But which DSN file is Access using now? I want to examine it and compare it with the other ...
2
votes
0answers
149 views

Moving from MS Access to SQL Server 2012, need help with column history

I'm moving an access database from all the data being in MS Access to MS Access being just a frontend, but I'm having trouble figuring out how to do a sort of column history. I have a tasks....
2
votes
0answers
76 views

MS Access database returns multiple entries for same person with more than one child

I know this is a very basic question, but I've watched about six Access database videos and still can't find the answer. I'm a volunteer creating a membership database for a church in MS Access. The ...
0
votes
1answer
269 views

How to save the design of an Access database — not the content — as text?

How can I save the entire design or specifications of an Access 2007 database -- not the data content -- as text? I have fallen foul of the "Enter Parameter Value" bug whereby a query pop-up shows an ...
2
votes
1answer
319 views

Changing data source on Access front end

I feel bad asking this, as I am only using an Access front end temporarily, but I have been asked to migrate an access 2007 db to mysql with a php front end. I have moved the data to mysql and am ...
1
vote
0answers
129 views

Named a table “order” in Microsoft Office Access database and the webapp now can't see the table (even after renaming it)

I am creating a web application in Dreamweaver using ASP VBScript. The web application is a store and I have to implement a database into it (which I did). I created a table in my database called ...
1
vote
1answer
26k views

How to convert sql server table data into MS Access(.mdb) file

I have SQL Database table with 6664055 rows, I want to convert this SQL Server table data to MS Access format(.MDB), How Can I do this?
3
votes
2answers
1k views

Rearranging Data in an MS Access 2007 table into a new table format/Result Output

I have Access tables that have the following format: -------------------------------------- |Name |Math|Science|Reading|Civics| -------------------------------------- |Mike | A | C | A | B ...
2
votes
1answer
187 views

Primary Key Question

Building a database on Access 2007 and having trouble selecting the primary key. The tables consists of a student table and another table where the students are checked in. I would have liked to make ...