connecting to sql server from access 2010 accdb
Posted on 2013-01-13
I have 2 access files , first is .adp and the second is .accdb
in the adp file i just connect to sql server and run a query in vba code .
from .adp file i use File->server ->connection then insert the ip server,special port + username and password to connect to the sql server.
my needs now is to drop out this file and use instead the accdb file with a form that can run the same query i use in the adp , means i need a help with vba code that can be used in the accdb (in the form) that can connect to the sql server mentioned in the adp file.
thxn in regard:}