Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ms-access-2007]

21 questions
3
votes
2 answers

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 | |John | B | A | A | B | |Randy| A …
Juan Velez
  • 3,303
  • 19
  • 57
  • 75
3
votes
2 answers

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 versions. The Linked Table Manager only lists the…
taddy hoops
  • 141
  • 1
  • 1
  • 6
2
votes
1 answer

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 working on the ~400 forms, reports, etc, but want…
dt647146
  • 23
  • 2
2
votes
1 answer

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 the Student ID the primary key, but the check in…
shadowZz
  • 21
  • 1
2
votes
2 answers

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 help me to resolve this issue.
Jonas Ronald Costa
  • 63
  • 1
  • 1
  • 4
2
votes
0 answers

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.description column, and in another table descriptionLog, I…
Johnley
  • 93
  • 2
  • 2
  • 8
2
votes
0 answers

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 children are in a table separate from their…
Amanda Lietman
  • 21
  • 1
1
vote
0 answers

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 order and for some reason I couldn't dynamically…
COYG
  • 111
  • 1
1
vote
1 answer

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?
vivek
  • 91
  • 2
  • 4
  • 9
1
vote
0 answers

Select value and display in a combobox if the datetimepicker value lies between two extreme dates in a table in database

I am creating an attendance management system in vb.net and using MS access as my database. I created a leave form in which the student on leave has a roll number and his details along with the from date and to date field. What I'm trying to do is…
Vivek
  • 11
  • 1
1
vote
1 answer

What is MS Access ODBC SQL syntax for a table with AutoIncrement and Memo columns?

I am migrating a full framework .NET app to core. It used ADOX to create an MS Access database and tables. It used OLE DB to populate data. In ADOX, the data type was ADOX.DataTypeEnum.adInteger and the syntax from c#…
Gandon Jank
  • 37
  • 7
1
vote
1 answer

MS Access 2000 Application - SQL Server

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 running locally on my user's workstation. …
EASTBAY_DBA
  • 11
  • 3
1
vote
1 answer

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 a run-time file (.accdr) but the access table is…
Marcus Mackaku
  • 23
  • 5
1
vote
2 answers

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 broken in less than a second with very easy tools. A…
A-B
  • 21
  • 4
1
vote
0 answers

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: SELECT master.tag, MAX(CASE WHEN data.key = 1 THEN data.value ELSE NULL END) AS F1, MAX(CASE…
pppp
  • 11
  • 1
1
2