Recent content by John Gall

Thanks, I'll give t a try. I've always used SQL Authentication as its the "devil I know"

Hi, Sorry I did not acknowledge your last message last night. SQL Server authentication. I have tried saving the uid and p/w with the connection string but it still requests it each time. As I mentioned in the first place, the code works but the database immediately goes from 800kb to 48Mb...

SQL seems to insist that the password is entered each time.

When I remove this code, every time you open the db it asks for the SQL password for each linked database. Only one in this instance. I guess this is for security of SWL data mill look at simply refreshing.

I'm only refreshing them to automate the password and save every user having it. Is there a better way? Yes each user (only 2) will have a copy

Thanks for an amazingly quick reply. I feel the same. It runs in the Autoexec macro before opening the main form. I have used this code in many applications and always get the same problem. The linked tables are in SQL for our main ERP system. As I mentioned, with this code left in, the...

Hi, I am new to this group. I have searched high and low for an answer to what I'm sure is a very simple question. Why when I run the code below does my database grow from about 800Kb to 50Mb and will not shrink even with compact and repair. The moment I switch this function off and use the...