I am trying to do an insert into statement like so "SELECT * INTO tblX FROM tblX IN 'C:\Temp\X.mdb" but database X has a password so I was wondering if anyone knows how to specify a password as I think access only wants a path.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.