203 questions
1
vote
0
answers
68
views
Change the Outlook folder that a linked table in Access is pointing to using VBA
I have an Access 365 application with a linked table containing emails from a given Outlook folder. I want to change the folder this table is connected to from within the application.
My code opens ...
- 307
0
votes
1
answer
56
views
Access Form Linked to SQL Server: Automatically Generated Record Source Corrupted in Design View
I'm facing an issue with Access forms linked to SQL Server tables. I typically set the forms' RecordSource property using VBA in the Form_Load event, like this:
Set Me.Recordset = CurrentDb....
- 23
1
vote
1
answer
198
views
Find the unique "pseudo" index for a linked SQL view in Access
I have an Access database which has a number of linked tables linking to views in a SQL Server database. When you refresh the links to the views, Access asks for the field(s) which contain unique ...
- 307
0
votes
1
answer
56
views
Importing data to MS Access when the date is in the format dd-mmm-yyyy
I have a database which I use to keep my business accounts, it's that time of year again when I need to bring the accounts up to date and what I do is download my bank statement as a csv from the bank'...
- 1
1
vote
1
answer
3k
views
Power Query New column with Unique ID
I have an excel power query that transforms new files when added to a folder. The resultant table is then linked to a database. I would like to create a new column in power query that creates a ...
- 13
0
votes
0
answers
724
views
Is it possible to have relational databases using Microsoft/SharePoint Lists?
I want to implement a system of linked tables using Micorosft Lists (formerly known as SharePoint Lists) to create a list of our suppliers, the services they provide to us, and the contact people ...
- 14.3k
0
votes
1
answer
100
views
How do I read/write record in Access Database that has table relationships?
I am creating an Access Database, that has the following tables and field
TableMain TableCustomer Record in TableCustomer
ID Auto
fDate(Date/time) CID (Auto) ...
- 67
0
votes
0
answers
123
views
create linked tables with vba through odbc connection (MySql) in excel
I have an excel file, which needs to have a connection to a mysql database with odbc. I am aware of the option to do it through UI, but i would prefer not to (data - get_data - from other sources - ...
2
votes
0
answers
47
views
Disappearing Linked Table
I have a problem that arose last week and seems to be spreading. I installed a MS Access database front end on several pcs at a company, that link by ip address to SQL Server backend. This was done ...
- 55
0
votes
2
answers
492
views
Create and run append queries for multiple linked tables
I am trying to write a VBA code in Microsoft Access that will create and run 60 queries to select new records from 60 linked tables and insert them into 60 tables of the same format. Some background ...
1
vote
1
answer
719
views
How to get the columns of a linked odbc table in MS Access through SQL Query
I have linked a couple of tables in MS Access database from SQL Server and also from Excel. Now I want to query them from a Java application using jdbc. But when I run the query SELECT * FROM sys....
0
votes
3
answers
1k
views
Linked tables in MS Access showing #Deleted in all rows and columns
I ran into an issue today where MS Access version 2022 (Build 14931.20392) started just showing "#Deleted" for all rows and columns in a linked table to a SQL Server 2012 database.
No ...
- 47
1
vote
0
answers
43
views
Suddenly none of my linked tables work in Access [duplicate]
I have a large MS Access application that uses linked tables to a SQL Server back end. The Access database links to SQL Server via ODBC.
Suddenly, none of my linked tables work, if there is a unique ...
- 31
0
votes
1
answer
165
views
Creating login procedure for Linking MS Access to Azure SQL server
I have an MS Access program which contains a number of SQL tables which are linked to Azure SQL server. Ideally I would like to create a login procedure via a popup form, in which I would ask the ...
- 1
1
vote
2
answers
2k
views
Access Linked Table from SQL Shows #Delete
I created this table:
CREATE TABLE [dbo].[dbo_Country]
(
[Country] [nvarchar](100) NOT NULL,
[ISO3166Code] [smallint] NULL,
[CountryEn] [nvarchar](255) NULL,
[Abriviation] [nvarchar](...
