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
1
vote
1
answer
200
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
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
1
answer
102
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
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
1
vote
1
answer
720
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....
1
vote
0
answers
44
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
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](...
1
vote
1
answer
225
views
How to access an Oracle linked table in Linq2db?
I have a linked table I access like this:
SELECT Id, Name FROM MySchema.Sectors@STATS
How do I define that in Linq2db?
I tried:
[Table(Schema = "MySchema", Name = "SECTORS@STATS")...
- 3,241
-1
votes
1
answer
148
views
MSAccess Missing Column After Relinking Table
I am trying to add a pull-down combo box to a form in MSAccess. The strange part is that the (email) column is missing. I have performed the following checks/actions
Validated the SQL table (...
- 334
0
votes
1
answer
2k
views
Access Linked Tables can't see the new SQL Server tables
HISTORY
In the 1990's, my predecessor built an Access database for my company (four of them actually). In the aughts, the next employee built a SQL Server 2008 Express on Windows Server 2003 and moved ...
- 805
-1
votes
1
answer
400
views
How do I add linked tables to a microsoft access database where the source is stored on Google Drive (for free)?
So for context, I have a database backend that is stored in Google Drive and I have a frontend with an interface, forms, and reports. The current solution that we have is that all employees in the ...
- 81
1
vote
2
answers
843
views
Using Snowflake ODBC Driver with MS Access
I am trying to access my tables in Snowflake using MS Access. I am able to make the connection to make a connection between them and see the list of all my tables but the I am getting all my tables (...
0
votes
0
answers
169
views
How to set column defaults for linked tables?
In my access 365 database, I am linking some tables of my sql server 2017.
An example table in SQL Server:
CREATE TABLE pet (
ID INT NOT NULL,
name VARCHAR(255) DEFAULT 'noname',
age INT ...
- 21.8k
1
vote
1
answer
189
views
Is there a way in MS Access, using VBA to work out if a ODBC linked Table is a SQL View or Table
I have an Access Database with hundreds of ODBC Linked Tables to a couple of backend SQL Servers. Some of these Linked Tables are to SQL Tables and some are to SQL Views. Is there any way to ...
0
votes
1
answer
169
views
Access Query sort of Linked tables
I'm using Access 2007. I have two tables, first one has a PK (primary key), but the second has not.
When using a query linking the two tables on the PK, I need the rows have the same sort as it is in ...
- 11
1
vote
2
answers
2k
views
Changing Linked Table Source Access 2016
I am trying to change the links in an Access 2016 database, but the method I've used in the past is not working as required.
I am using the
t.connect="new connection"
t.refreshlink
method,...
- 8,576
1
vote
2
answers
1k
views
Cannot connect Access to SQL Server Linked Tables - error message loggingin
I have a client for which I am setting up a new SQL Server Express and (on a different computer) connecting their Access front end to that SQL Server. I created an account on SQL Server, changed ...
- 127
2
votes
1
answer
1k
views
Is it possible to update a local table with values from a linked table?
I have two identical tables in my database, T1 and T2. T1 is a local table while T2 is a linked table from a live SQL database. At the moment the two tables are identical.
In short, I would like to ...
- 195
1
vote
1
answer
1k
views
Test to see if ODBC Linked Table is Available
I have an Access database that links to six tables in other SQL databases using ODBC connections. I then have a couple of queries running checks on these tables generating some reports. However, ...
- 195
2
votes
1
answer
575
views
How to setup a link from an Access .accdb file to a mdb file with user level security?
We use in a company an Access database which I developed a long time ago with front end and back end .mdb files and user level security. (We don't need high security standards)
Now I am developing an ...
- 2,807
0
votes
0
answers
117
views
Join tables from different servers in Oracle - Microsoft Query
I'm using Microsoft Query and I want to connect tables from two different servers.
One uses Oracle in OraClient11g_home1 and the other MySQL ODBC 5.1 Driver.
Both have DSN setup, a different user ...
- 2,450
9
votes
4
answers
72k
views
Spring-boot jpa how to find entity with max value
Lets tell I have two tables.
CREATE TABLE user (ID int AUTO_INCREMENT,PRIMARY KEY (ID));
CREATE TABLE points (ID int AUTO_INCREMENT, user_id int, points int,PRIMARY KEY (ID));
How can I use spring-...
- 173
0
votes
0
answers
39
views
Write Conflict error in MS Access 2010 when i try to assign a record source
I have SQL Server 2008 R2 linked tables in my MS Access 2010.
I have many forms in this MS Access database. Few of my forms gets Write Conflict error when I try to assign it to a SQL statement as ...
- 1
0
votes
1
answer
2k
views
How do I create links to my tables in a password protected back end?
I created an install for my database. However it loses the password for the linked tables to the back end.
I need to relink all the tables on load.
I found the below code to add specified table but I ...
- 11