Stack Overflow
Stack Overflow

Questions tagged [ms-access-2007]

Microsoft Access 2007 - a rapid database application development tool

Microsoft Access 2007, also known as Microsoft Office Access 2007, is a rapid application database development tool.

Microsoft Office Access 2007 reached its end of extended support on October 10, 2017

It commonly uses the Jet or ACE database engine, but is not limited to these.

It is a member of the suite of applications, included in the Professional and higher editions or sold separately. Applications built with Microsoft Access can be distributed to end users with a free runtime version of the application that lets them view databases without needing the full installation of Access.

Please tag your question so others know what version you are using. Tag your question with if your question involves VBA.

Links:

4371 questions
10
votes
3 answers

Connect to web service in MS Access with VBA

Is it possible to connect to a web service (for example send a HTTP Request) via VBA in Microsoft Access? For example, the user clicks a button on a form, then a HTTP Request is sent to a web service that responds with OK. Has anyone done this…
Chris
  • 3,057
  • 5
  • 37
  • 63
10
votes
1 answer

Microsoft Access 2007 / 2012 Source Control using Team Foundation Services (2012)

I've been struggling for few days on this workaround... So, as you may know, Microsoft ran its cloud ALM platform : team foundation services (https://tfs.visualstudio.com/). It is free to use for teams containing less that 5 users... and it can be…
boblemar
  • 1,143
  • 1
  • 10
  • 24
9
votes
1 answer

Is there a way to disable Access 2007's Code editors CTRL+Y Shortcut key?

Background I have used MS editors and applications for years including Visual Studio and office products and got use to CTRL+Y being redo. In fact so use to it doing that that I use undo CTRL+Z multiple times to look back on what I had just done…
GazB
  • 3,510
  • 1
  • 36
  • 42
9
votes
2 answers

How to insert "Entire" DAO recordset into a table with VBA

I have a DAO recordset that gets created fine and I can transfer the records from the set to a table, this is done row by row and works well but I am transfering a large amount of data at once so this can take a very long time row by row. Is there a…
Steven Whelan
  • 128
  • 1
  • 1
  • 5
9
votes
6 answers

MS Access: How does one insert NULL into DateTime field

I have an MS Access database (intolerably enough), and communicating with it through PHP (ODBC). There is a DateTime field that I have to include in my INSERT statement. This field is NOT defined as "Required" in Access, meaning that it is indeed…
Teekin
  • 12,581
  • 15
  • 55
  • 67
9
votes
2 answers

CurrentDb.RecordsAffected returns 0. Why?

If I use RecordsAffected with CurrentDb.Execute, it always returns 0. If I first make a instance of a Database object it works properly. Why? Like this: Dim Db As Database Set Db = CurrentDb Db.Execute "DELETE * FROM [Samples] WHERE Sample=5" If…
waanders
  • 8,907
  • 22
  • 70
  • 102
9
votes
3 answers

"The data has been changed" error when stepping from main form into sub form

I'm migrating an Access database to SQL Server using the SQL Server Migration Assistant (SSMA). The Access application will continue to be used but with linked tables instead of local ones. I've run into a problem during the post-migration testing…
Simon Elms
  • 17,832
  • 21
  • 87
  • 103
9
votes
3 answers

accdb vs mdb. Which is faster/better?

Does anyone have any experience of using Access 2007 with the prior versions of Access (i.e. mdb files). We have been upgraded, but are still using the mdb format. Some of our code (in particular Docmd.TransferDatabase acImportReport) are now…
MT.
  • 791
  • 5
  • 15
  • 23
8
votes
2 answers

Annoying vba naming behaviour

I'm using access 2007 and this behaviour can be replicated as follows. 1) Create new access database accdb file. 2) Open database and create new vba module. 3) Create 1st subroutine sub1: Sub sub1() Msgbox Err.Description End Sub 4) Create 2nd…
David
  • 2,101
  • 2
  • 32
  • 41
8
votes
6 answers

Why does MS Access 2007 not allow a row insert, but then allow it on the next insert attempt?

My insert statement is: INSERT INTO myTable (inst_id,user_id,app_id,type,accessed_on) VALUES (3264,2580,'MyApp','Renew',Now); ...where all of the values are formatted correctly. The table has the above fields and one other, a long int…
Mike Webb
  • 8,855
  • 18
  • 78
  • 111
8
votes
1 answer

how to get column names of a table in ms access?

How to get fieldnames or columnname of a table in msaccess using query? Can someone help me to overcome this issue? Like if i have table called "employee" i need to fetch the fieldnames(id,name,workstatus..etc) of employees alone not its…
Yugal
  • 1,635
  • 8
  • 21
  • 30
8
votes
1 answer

Cannot Open Database Created with Access 2010 in Access 2007 Even With SP2

A database created with one of the new sort orders will not open in Access 2007 even with Service Pack 2 (SP2) installed.
Fionnuala
  • 90,370
  • 7
  • 114
  • 152
8
votes
5 answers

Pad numbers with leading zeros in an Access query

I have a column of numbers between 0 - 6 digits long. For those less than 6 I need to pad out with zeros to ensure they are all 6 digits i.e 12563 = 012563 or 23 000023 etc etc. Can someone recommend a solution?
A Hughes
  • 235
  • 1
  • 2
  • 15
8
votes
6 answers

How do I distribute updates to a Access database front end?

I've got an Access 2007 database that I developed which connects to SQL Server for the actual data storage. I used the Package Solution Wizard to create a distributable installer which included access runtime (with an ACCDE file) which I went…
Brett G
  • 349
  • 2
  • 4
  • 20
8
votes
1 answer

Inserting data to Access Duplicate Data Error

I have wrote some vbscript that updates all new fields in one access database from a table in another database however I am having problems with duplicate primary keys. I can't change the structure of the database so I can't remove the primary keys…
Simon Staton
  • 4,345
  • 4
  • 27
  • 49
1 2 3
…
99 100