Search results

Would it be better just to take the backup database? As Im aware only one user is using the database, locally. Nothing it stays as it is, #####

Alright, there are some backups and yes I guess I will use it but how to prevent this from happening again? It's strange that it happened on a backup database too. I'm not sure if it could be an virus infection, but the windows defender didn't find anything suspicious on the PC. Maybe migrating...

So I suppose not worth trying any mdb repair/recovery software?

I read it however, Im not sure that it is the exact same problem, the symptoms seem different. I can still use and open the database. Any way to try and recover the lost records?

Edition: Windows 10 Pro Version: 1903 OS build: 18362.476 To be honest I have no idea, the database is not at my PC tho. Which issue do you exactly mean? Could you provide a link about it? Thanks Btw office is the 2007 one

Strange things happening with one of my .mdb files. In one table, there are records which cant contain a Null value but they do and have ### instead real value (screenshoot in attachment) I replaced the database with a backup one but then again same happened when the same records had to be...

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 connection string so I will have to do some testing in the upcoming days and I will also test the...

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 chance to test what you wrote. 11 in string, 10 being the only driver on computer.

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 remember exactly the description. However, when I changed the link string to Native Client 11.0 it...

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 driver version in a table with the server name, so I will grab it from there. BTW: how can I...

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, for now will try to finish what I started. I dont have much left to do, just want to read...

This is what I get when trying to open with Access 2007 (attachment)

Looks like its not compatible with Access 2007 :(

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 system;DATABASE=DatabaseSQL; with this one DRIVER=ODBC Driver 17 for SQL...

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 Microsoft Office system;DATABASE=DatabaseSQL; So I need the "DatabaseSQL". Im not sure if the order...

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 because it uses SQL Server Native client 11.0 and because of it I have to somehow modify my code to use...

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 for SQL Server};" & _ "DATABASE=" & DatabaseName & ";" & _ "SERVER=" & ServerName &...

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? Should I stick with the Native client driver and make an option button to select between 10.0 or...

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 definitely check your example How exactly do I do that?

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 the other database which I dont need and that causes an error because it cant find the table. Any...