sql - Login Prompt when refreshing access data connection from Excel -
i have user gets prompt when opening 1 of file (no 1 else it).
the file has connection access table using sql command.
the connection string gets updated automatically when opening file match local adress of accdb file.
the connection string following:
dsn=ms access database;dbq=c:\users\t73648\google drive\computer\documents\opex\dmc mbo\final files\dmcmbotable.accdb;defaultdir=c:\users\t73648\google drive\computer\documents\opex\dmc mbo\final files;driverid=25;fil=ms access;maxbuffersize=2048;pagetimeout=5;
the command in following:
select * gareagpl gareagpl (gareagpl.gpl='test')
it not generate problems other users.
the pop looks that:
obviously there no password can provide db unlock.
thanks helping me out on one
Comments
Post a Comment