Stack Overflow
Stack Overflow

Questions tagged [ms-access-2013]

Questions regarding the Microsoft Access 2013 database management system.

Microsoft Access 2013 is a database management system and application development tool. It is included in "Microsoft Office Professional 2013" and "Microsoft Office Professional Plus 2013", and can also be purchased separately.

.

For more information on Microsoft Access, see

http://en.wikipedia.org/wiki/Microsoft_Access

.

For more information on new features in Microsoft Access 2013, see

What's new in Access 2013 - MSDN - Microsoft
http://msdn.microsoft.com/en-ca/library/fp179914.aspx

What's new for Access 2013 developers - MSDN - Microsoft
http://msdn.microsoft.com/en-us/library/office/jj250134.aspx

2184 questions
25
votes
14 answers

Access 2013 - Cannot open a database created with a previous version of your application

I have an Access database created more than 10 yrs back. I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desktop and opening the file with this version results in the…
Uma Ilango
  • 968
  • 4
  • 16
  • 31
15
votes
1 answer

How do I import an .accdb file into Python and use the data?

I am trying to figure out a way to create a program that allows me to find the best combination of data based on several different factors. I have a Microsoft Access file with creature data in it. Attack, Defense, Health, Required Battle skill to…
Justin
  • 155
  • 1
  • 1
  • 6
13
votes
5 answers

Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_Click() If ProjectAddAllDueDateAutoCmBx =…
D347HxD
  • 375
  • 4
  • 9
  • 26
11
votes
2 answers

TRANSFORM and PIVOT in Access 2013 SQL

How can I get second table from first table using TRANSFORM and PIVOT functions: TABLE_01 Config_ID | ConfigField | ConfigValue ----------------------------------------- 11 | Name | Basic 11 | Version | …
Viktor Krykun
  • 243
  • 1
  • 2
  • 9
10
votes
1 answer

Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)

I am iterating through files in a folder (which means I do not know the names in the folder), and have a file with a Polish ł character. The Dir function converts this to an l which means the filename can't be found at a later date. I've declared…
user3791372
  • 4,445
  • 6
  • 44
  • 78
10
votes
5 answers

Adding Trusted Location to Access Run Time

I have created a Microsoft Access file. How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?
Adarsh Madrecha
  • 6,364
  • 11
  • 69
  • 117
10
votes
4 answers

How can I view the metadata for a Microsoft Access 2013 table?

How can I view the metadata(data dictionary) for a Microsoft Access 2013 table?
yesman
  • 109
  • 1
  • 1
  • 7
10
votes
1 answer

How to Add Long Text Column to Access Table Via Query

I am updating a table in a .mdb format Access database with Access 2013. I want to add a new field, lets say a Description field, to an existing table. I can add a text column using the following query ALTER TABLE TestTable ADD Description…
jaredk
  • 986
  • 5
  • 21
  • 37
7
votes
2 answers

Garbled text in Access 2013 Print Preview

having a problem with an Access 2013 program that I need some outside insight on. We have upgraded our terminal server to windows server 2012 r2 from windows server 2008 r2, along with Office 2010 ProPlus 32-bit to Office 2013 ProPlus 32-bit. We…
Dimitri Shukuroglou
  • 363
  • 1
  • 5
  • 13
7
votes
2 answers

Sending emails to multiple recipients using VBA

I have the following code which allows me to attach a report then send it to one recipient. How do I send it to more than one address? I've tried putting the addresses in an array but it gives a "Type Mismatch" error. Dim strReportName As…
Chrislaar123
  • 323
  • 2
  • 6
  • 17
7
votes
2 answers

How to convert an ADP to ACCDB using Access 2013?

Access 2013 does not support ADP. Some alternatives to ADPs are given: Convert the ADP to a linked Access Desktop Database. Import objects into an ACCDE file and then create linked tables to the existing data by using an earlier version of…
A_kumar
  • 401
  • 1
  • 4
  • 12
6
votes
2 answers

Get contents of laccdb file through VBA

I want to be able to view the contents of my access database's laccdb file through VBA so I can use it to alert users (through a button) who else is in the database. I specifically don't want to use a 3rd Party tool. I have tried using: Set ts =…
Tim Edwards
  • 1,031
  • 1
  • 13
  • 34
6
votes
3 answers

How to make a table read-only in Access?

I have made up Tracker form in Access 2013 in which end user update their daily routine tasks. I want to keep the table as read-only so that no one can make any unauthorized changes in the existing data. Is there any way to do that in Access?
user3497327
  • 71
  • 1
  • 1
  • 3
6
votes
1 answer

ADODB doesn't exist in Access 2013 project, how do I add a reference to it

I am trying to rebuild an Access adp project in Access 2013 as and mdb. The tables are all linked tables in both version so that is not an issue. I have imported the forms from the old project so the form layouts and code is all there. Where I run…
John S
  • 7,909
  • 21
  • 77
  • 145
6
votes
3 answers

Access 2013 breaks UniqueTable functionality

We have a fairly large Access front-end application that has been running on Access 2010. It makes extensive use of ADO recordsets for accessing data on our SQL servers, and frequently uses the UniqueTable form property. We are looking to move the…
Corey
  • 15,524
  • 2
  • 35
  • 68
1
2 3
…
99 100