Search results

Also manual linked table manager refresh doesn't work (btw i need automatic way to relink tables, but i can't refresh even manually) except to close application and start again... A try to change methods, (ado, dao and vba way docmd.transferdatabase, aclink...) and try to chanfe drivers in...

hm... it does not solve problem as i could understand... could you send ftest code... ANYWAY PROBABLY I NEED THE WAY TO CLOSE PREVIOUS DNSLESS CONNECTION TO SQL SERVER WHICH HAS BEEN BROKEN AND CREATE IT ONCE AGAIN SOMETHING LIKE APPLICATION.CURRENTPROJECT.CLOSE CONNECTION (IT PROBABLY WORKS...

Refresh linked tables when connection has been lost whit out closing access database I have MDB database linked to SQL SERVER through VPN connection... I create links to the sql server with dao method.. everything works fine but when I lost VPN connection i cant refresh links to the tables with...

this link describe nice the way... i tried with simple installing another version of ocx but it didn't work.. this could work... But I already ask the clients to upgrade the their msoffice and they did that one of them msoffice2010 another 2013 both 32bit version because I red that 64bit might...

I have MDE app in access 2003 ... in two client computers having win7 and msoffice 2007 doesn't work ... problem is progress bar control... error does not recognize object.. I put different versions of mscomctl,ocx file but no success... should i regiter ocx file some how or some other idea...

Ok... i'll try that way...

It is onother function or procedure or some loop let say started on loading form ... so i want to quit them with some button and start something else...

I need to stop already ran procedure or function with vba code So I use END command ans everything stops.. in some cases that is usefull , but some times need I to do something else after I use END command, but after END everything stops... LIKE THIS : SUB () END ME.CTL.SETFOCUS...

this really works..... i was wondering what is that keep tables locked... and actually it is combo box in my case as you wrote just refresh the form and tables connected to combo box are setting free and able to be deleted thanks....

THANKS FOR THE REPLAY... But I'm using VPN connection and I need to start some TXT or some BATCH file on the remote computer which be executed on remote computer, not on mine... So it can be used in LAN network connected computers as well... p.s. I'd prefer to do that from VBA code calling...

I think i found a way to replace sendkeys with API.... So I'm steel testing the way... but it seems to work properly.... The code is as follow... Any suggestions to improve the code are welcome ... Option Compare Database Option Explicit Private Declare Sub keybd_event Lib "user32" ( _...

WHEN I USE SENDKEYS in XP i don't have any specific problems... but on win7 they make a lot of confusion with num lock ...when i use sendkeys in win7 num lock sometimes is going off ... so I red around that i could replace them with API but i didn't find any clear example... ANY IDEA TO SOLVE...

FINALLY I found the right way... So I had mistake in connection string to the sqlDB so the correct string is : "ODBC;driver={SQL Server};Server=MyServer;database=MyDataBase;uid=MyUser;pwd=MyPasword;" so both methods DAO and ADO works properly Thanks to all replies who guide me to find a...

the same error i have as well when run code with DAO METHOD...

to resume all... i use this code to create link to sql database WITH ADO METHOD.. at the end i have err message could not find installable ISAM WHEN I try to append link table IF I USE THIS CODE WITH CREATED DSN THEN IT IS WORK PROPERLY CONNECTION STRING THEN IS AS FOLLOW...

yes i already check that... and i have adox ... but still have problem with apending tables... err "could not fin istallable isam" :(

:( i do get message "could not find installable isam" if connect to sql database wit dsnleess string always get that message... with ado it is ok i establish connection to sql database with dsnless string but i can't create link table

that i tried , an i understood that i can run commands after connection is opened like exec sqls... but if i wan't to create query in mdb file or fill sum form controls I need to have link to sql table . i red that i can do that with adox extensions but samples what i found doesn't work should...

anyway don't i should have links in mdb database to be able to work with queries and forms... it seems to must have the linked tables in mdb, so i should create them...?

thanks for replay i've done your way and i opened connection... now i need to refresh links to sql database.. I used to do this with dao method: So, What is ADO method to create/refresh link...