All Questions
Tagged with sql-server microsoft-access
18
questions
0
votes
0
answers
188
views
MS-Access keeps stealing focus from VBA
When I'm working on MS Access VBA scripting, the Access application keeps stealing focus from VBA, even mid typing. So I will be typing code, there will be a pause, a brief lock up, and all of a ...
- 1
0
votes
1
answer
287
views
"Operating System is not configured to use this application" when migrating a DB using the Access SQL server migration assistant
I have (re)installed Microsoft SQL Server migration assistant latest version today, and i have installed Ms SQL server Management studio 18 in order to migrate my accdb access database from Access to ...
- 13
0
votes
1
answer
79
views
Excel to access file data tranfer by SQL server
I have an issue While Transfer Data From Ms Excel to MS Access by SQL Server
here is my program
Public Sub DoTrans()
DoEvents
Sheets("Temp").Select
Set cn = CreateObject("ADODB....
- 115
0
votes
1
answer
620
views
Unable to import access database to SQL Server - unrecognized database format '.mdb'. (microsoft jet database engine)
I am trying to import .mdb (Access database file) to SQL Server.
Adding the sys-admin privilege username and password also does not help and gives an error - not a valid account name or password.
0
votes
0
answers
671
views
Cannot install SQL Server Migration Assistant for Access due to missing Data Access Object libraries
I have a requirement to migrate some MS Access databases to SQL Server, and would like to use the Microsoft SQL Server Migration Assistant 8.3 for Access. One of the pre-requisites for installing SSMA ...
- 126
0
votes
1
answer
4k
views
Power BI data refresh timeout
So I have built some dashboards in Power BI that have direct linked data to my access queries that are connected to sql servers. when I refresh them individually they work fine just take some time. ...
0
votes
1
answer
592
views
MS Access - #DELETED when adding a record
I'm using an MS Access 2010 .accdb database connected to a SQL Server 2016 database. My tables and views from SQL are managed as linked tables in MS Access. I'm using a DSNless connection with the ...
- 31
1
vote
0
answers
443
views
Extract data from hundreds of Microsoft Access databases
I have 1,371 Microsoft Access databases (.mdb), each database represents the daily log for a door entry system (so over 4 years worth of daily logs).
Within each mdb file there are only 2 tables: ...
- 115
0
votes
0
answers
923
views
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
this error is very common but in my case, is very strange why is being produced.
I have developed a 64 bits application that uses an Access database. To be able to run it, I installed 64 bits version ...
- 337
0
votes
1
answer
5k
views
How to speed up off-site access to Access application
I built a calendar-type application on MS Access 2013 with SQL Server as the back-end (each day on the calendar is a subform). About 20 tables are connected using the line Call AttachDSNLessTable([...
- 115
1
vote
1
answer
5k
views
How can I determine which SQL db my Access app is pointing to?
There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this?
The linked table manager appears to point to something but doesn't give ...
- 2,107
3
votes
2
answers
114k
views
How do I allow multiple people to open my Access database?
I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the ...
- 179
0
votes
1
answer
88
views
MS Access Autonumber dilemma
I am using a sql query that will copy the data from one table to another.
The problem though is the counter which I put in the Second table of my Insert into Select Statement.
It all started from ...
- 69
3
votes
1
answer
4k
views
SQL Server 2012 Connecting to MS Access 2003
SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.
I just installed SQL Server ...
- 179
1
vote
1
answer
1k
views
connecting to sql server from access for multiple users
I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize ...
- 121