Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 185
Search took 0.01 seconds.
Search: Posts Made By: Hello1
Forum: Modules & VBA Today, 09:01 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Alright, I will make a screenshoot next time I try it. No, I didn't try the default SQL Server driver, I will try that one too, I suppose that one should work. I finished my form and code for the...
Forum: Modules & VBA Today, 08:55 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Other way around. I had 10 in the connection string and the computer has only 11 installed. That way it didn't work. When I updated the connection string to 11 it did work.

I didn't have the...
Forum: Modules & VBA Today, 08:19 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Unfortunately its not, I tried it with the links having in it the Native Client 10.0 while the workstation only has the Native Client 11.0 driver. It caused an error in the linking process, cant...
Forum: Modules & VBA 11-08-2019, 09:44 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Sorry, that was my test string and I forgot to change it. It will actually be the Native client 10.0 but as I mentioned earlier, one machine has the Native client 11.0 so I will probably keep the...
Forum: Modules & VBA 11-08-2019, 09:26 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

I tried both versions but same error. On access 2010 it did install without problems but got the same error which he shows in his post when trying to run it.
I will maybe give it another try later,...
Forum: Modules & VBA 11-07-2019, 06:33 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

This is what I get when trying to open with Access 2007 (attachment)
Forum: Modules & VBA 11-07-2019, 06:11 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Looks like its not compatible with Access 2007 :(
Forum: Modules & VBA 11-07-2019, 04:33 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Whats confusing me is what if I want to change this link:

DRIVER=ODBC Driver 17 for SQL Server;SERVER=ServerName\SQLEXPRESS;UID=username;PWD=password;APP=2007
Microsoft Office...
Forum: Modules & VBA 11-07-2019, 03:04 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Im trying to extract the database name from the table link string. What would be the best way?

DRIVER=ODBC Driver 17 for SQL Server;SERVER=PCName\SQLEXPRESS;UID=username;PWD=password;APP=2007...
Forum: Modules & VBA 11-06-2019, 04:15 PM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Most SQL Servers are 2008, one is 2012 i think. All the workstations with SQL Server 2008 use SQL Server Native client 10.0, the exact versions I dont know. The 2012 is only giving me headache...
Forum: Modules & VBA 11-06-2019, 03:48 PM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

So if I understood well I want to use the ODBC Driver 17 for SQL Server, I dont use ADO?
So my connection string would be something like this?


strConnectionString = "ODBC;Driver={ODBC Driver 17...
Forum: Modules & VBA 11-06-2019, 03:14 PM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

One question. On some servers for linking tables I use the SQL Server Native client 10.0 driver and on some 11.0, no where I saw that I use the "ODBC;Driver={SQL Server}..
What is the difference?...
Forum: Modules & VBA 11-06-2019, 05:55 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

I went with with this and seems to work for now:

If UCase$(Left$(tdfCurrent.Connect, 5)) = "ODBC;" And InStr(1, tdfCurrent.Connect, DatabaseName, vbTextCompare) <> 0 Then

However, I will...
Forum: Modules & VBA 11-06-2019, 05:34 AM
Replies: 58
Views: 709
Posted By Hello1
Re: Linking SQL Server tables with VBA

Im trying to implement this but the problem I face is having tables linked to 2 databases on the SQL Server and not just one database.
After the code goes through all ODBC tables it picks those from...
Forum: Modules & VBA 11-01-2019, 06:17 AM
Replies: 58
Views: 709
Posted By Hello1
Linking SQL Server tables with VBA

I saw somewhere on the internet that I could link the SQL Server tables to my .accdb with VBA, without having to use the Linked table manager.
Sometimes I get the ODBC call failed when trying to...
Forum: General 10-31-2019, 04:10 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

Very strange. I made the decompiled version and took the old version also. Tried to make the .accde few times from both versions and both sometimes finish without the error and sometimes with the...
Forum: General 10-31-2019, 03:36 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

Do you mean this? (attachment)
Thats how it currently is.
Forum: General 10-31-2019, 03:34 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

I do run this line with F5 "Set ProP = Db.CreateProperty("AllowBypassKey", dbBoolean, False)" before doing the Save As but I did forget to do compile after doing so, I usually dont and it works. I...
Forum: General 10-31-2019, 02:56 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

No, not on any machine. It happens on the server but yes I do it locally on the server.
At my home machine it didnt happen.
Forum: General 10-31-2019, 02:49 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

Well, Im not quite sure. It happens when I go in the .accdb and do Save as .accde, this is where it actually happens..but in this process a C&R happens, yes.
However, it doesnt happen when I open...
Forum: General 10-31-2019, 02:46 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

Some more information, tables in the .accdb are mostly linked tables. Some are linked to .mdb and most of them are linked to the SQL Server. Very few are actually in the .accdb which arent linked but...
Forum: General 10-31-2019, 02:42 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

The .accdb is not even 10MB and I have no idea which query to check, however, I dont think any of the queries gives results that big to occupy 2GB
Forum: General 10-31-2019, 02:38 PM
Replies: 19
Views: 263
Posted By Hello1
Re: The query cannot be completed

Sorry, fixed. Thanks :)
Forum: General 10-31-2019, 02:37 PM
Replies: 19
Views: 263
Posted By Hello1
The query cannot be completed

I get this error/warning (check attachment) when I make an .accde from .accdb. It jumps after closing the .accdb or .accde when doing compact n repair (turned on to do it on exit). When I open the...
Forum: Queries 10-03-2019, 03:05 PM
Replies: 16
Views: 310
Posted By Hello1
Re: Speeding up a LEFT JOIN query

We posted at the same time, if I find time over the weekend I will try to do the testing and let you know :)
Showing results 1 to 25 of 185

 
Forum Jump



All times are GMT -8. The time now is 05:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World