اتصال به بانک رمز دار

[qazwsx]

سلام من میخوام به یه بانک اکسس که روش پسورد گزاشتم وصل بشم تو سایت جستجو کردم و فهمیدم که باید این کدو به کار ببرم

'Provider=Microsoft.Jet.OLEDB.4.0;OLEDB.4.0:databa se password=qaz@# Data Source='+
a\data\data1.mdb;Persist Security Info=False';

ولی زمانی که این کد. استفاده میکنم یه پیغام خطا میاد به این شکل

canno start application. the workgroup information file missing or opened exclusively by another user

لطفا راهنمایی کنید باید چکار کنم

[tefos666]

:خجالت: سلام دوست عزیز یه سایتی وجود داره که انواع و اقسام کانکشن استرینگ ها رو توش گذاشته ، کافی نوع بانکتون رو پیدا کنید و به کار ببرید .

http://www.connectionstrings.com/


Database servers

http://www.connectionstrings.com/images/icons/sqlserver2008.png (http://www.connectionstrings.com/?carrier=sqlserver2008)SQL Server 2008 (http://www.connectionstrings.com/?carrier=sqlserver2008)
http://www.connectionstrings.com/images/icons/sqlserver2005.bmp (http://www.connectionstrings.com/?carrier=sqlserver2005)SQL Server 2005 (http://www.connectionstrings.com/?carrier=sqlserver2005)
http://www.connectionstrings.com/images/icons/sqlserver.gif (http://www.connectionstrings.com/?carrier=sqlserver)SQL Server 2000, 7.0 (http://www.connectionstrings.com/?carrier=sqlserver)
http://www.connectionstrings.com/images/icons/sqlserver2005ce.gif (http://www.connectionstrings.com/?carrier=sqlserver2005ce)SQL Server Compact Edition (http://www.connectionstrings.com/?carrier=sqlserver2005ce)
http://www.connectionstrings.com/images/icons/oracle.gif (http://www.connectionstrings.com/?carrier=oracle)Oracle (http://www.connectionstrings.com/?carrier=oracle)
http://www.connectionstrings.com/images/icons/db2.gif (http://www.connectionstrings.com/?carrier=ibmdb2)IBM DB2 (http://www.connectionstrings.com/?carrier=ibmdb2)
http://www.connectionstrings.com/images/icons/mysql.gif (http://www.connectionstrings.com/?carrier=mysql)MySQL (http://www.connectionstrings.com/?carrier=mysql)
http://www.connectionstrings.com/images/icons/interbase.gif (http://www.connectionstrings.com/?carrier=interbase)Interbase (http://www.connectionstrings.com/?carrier=interbase)
http://www.connectionstrings.com/images/icons/sybaseads.gif (http://www.connectionstrings.com/?carrier=sybaseads)Sybase Advantage Database Server (http://www.connectionstrings.com/?carrier=sybaseads)
http://www.connectionstrings.com/images/icons/sybasease.gif (http://www.connectionstrings.com/?carrier=sybasease)Sybase Adaptive Server Enterprise (http://www.connectionstrings.com/?carrier=sybasease)
http://www.connectionstrings.com/images/icons/informix.gif (http://www.connectionstrings.com/?carrier=informix)Informix (http://www.connectionstrings.com/?carrier=informix)
http://www.connectionstrings.com/images/icons/ingres.gif (http://www.connectionstrings.com/?carrier=ingres)Ingres (http://www.connectionstrings.com/?carrier=ingres)
http://www.connectionstrings.com/images/icons/mimer.gif (http://www.connectionstrings.com/?carrier=mimersql)Mimer SQL (http://www.connectionstrings.com/?carrier=mimersql)
http://www.connectionstrings.com/images/icons/lightbase.gif (http://www.connectionstrings.com/?carrier=lightbase)Lightbase (http://www.connectionstrings.com/?carrier=lightbase)
http://www.connectionstrings.com/images/icons/postgre.gif (http://www.connectionstrings.com/?carrier=postgresql)Postgre SQL (http://www.connectionstrings.com/?carrier=postgresql)
http://www.connectionstrings.com/images/icons/paradox.bmp (http://www.connectionstrings.com/?carrier=paradox)Paradox (http://www.connectionstrings.com/?carrier=paradox)
http://www.connectionstrings.com/images/icons/firebird.bmp (http://www.connectionstrings.com/?carrier=firebird)Firebird (http://www.connectionstrings.com/?carrier=firebird)
http://www.connectionstrings.com/images/icons/as400.gif (http://www.connectionstrings.com/?carrier=as400)AS/400 (IBM iSeries) (http://www.connectionstrings.com/?carrier=as400)
http://www.connectionstrings.com/images/icons/pervasive.gif (http://www.connectionstrings.com/?carrier=pervasive)Pervasive (http://www.connectionstrings.com/?carrier=pervasive)
http://www.connectionstrings.com/images/icons/sqlbase.gif (http://www.connectionstrings.com/?carrier=sqlbase)SQLBase (http://www.connectionstrings.com/?carrier=sqlbase)
http://www.connectionstrings.com/images/icons/progress.gif (http://www.connectionstrings.com/?carrier=progress)Progress (http://www.connectionstrings.com/?carrier=progress)
http://www.connectionstrings.com/images/icons/cache.gif (http://www.connectionstrings.com/?carrier=cache)Caché (http://www.connectionstrings.com/?carrier=cache)
http://www.connectionstrings.com/images/icons/teradata.gif (http://www.connectionstrings.com/?carrier=teradata)Teradata (http://www.connectionstrings.com/?carrier=teradata)
http://www.connectionstrings.com/images/icons/vistadb.gif (http://www.connectionstrings.com/?carrier=vistadb)VistaDB (http://www.connectionstrings.com/?carrier=vistadb)
http://www.connectionstrings.com/images/icons/dbmaker.gif (http://www.connectionstrings.com/?carrier=dbmaker)DBMaker (http://www.connectionstrings.com/?carrier=dbmaker)
http://www.connectionstrings.com/images/icons/netezza.png (http://www.connectionstrings.com/?carrier=netezza)Netezza DBMS (http://www.connectionstrings.com/?carrier=netezza)
http://www.connectionstrings.com/images/icons/valentina.png (http://www.connectionstrings.com/?carrier=valentina)Valentina (http://www.connectionstrings.com/?carrier=valentina)

Data files
http://www.connectionstrings.com/images/icons/excel2007.gif (http://www.connectionstrings.com/?carrier=excel2007)Excel 2007 (http://www.connectionstrings.com/?carrier=excel2007)
http://www.connectionstrings.com/images/icons/excel.gif (http://www.connectionstrings.com/?carrier=excel)Excel (http://www.connectionstrings.com/?carrier=excel)
http://www.connectionstrings.com/images/icons/text.gif (http://www.connectionstrings.com/?carrier=textfile)Textfile (http://www.connectionstrings.com/?carrier=textfile)
http://www.connectionstrings.com/images/icons/access2007.gif (http://www.connectionstrings.com/?carrier=access2007)Access 2007 (http://www.connectionstrings.com/?carrier=access2007)
http://www.connectionstrings.com/images/icons/access.gif (http://www.connectionstrings.com/?carrier=access)Access (http://www.connectionstrings.com/?carrier=access)
http://www.connectionstrings.com/images/icons/visualfoxpro.gif (http://www.connectionstrings.com/?carrier=visualfoxpro)Visual FoxPro / FoxPro 2.x (http://www.connectionstrings.com/?carrier=visualfoxpro)
http://www.connectionstrings.com/images/icons/dbf.gif (http://www.connectionstrings.com/?carrier=dbffoxpro)DBF / FoxPro (http://www.connectionstrings.com/?carrier=dbffoxpro)
http://www.connectionstrings.com/images/icons/sqlite.gif (http://www.connectionstrings.com/?carrier=sqlite)SQLite (http://www.connectionstrings.com/?carrier=sqlite)
http://www.connectionstrings.com/images/icons/filemaker.gif (http://www.connectionstrings.com/?carrier=filemaker)Filemaker (http://www.connectionstrings.com/?carrier=filemaker)

Other
http://www.connectionstrings.com/images/icons/olap.png (http://www.connectionstrings.com/?carrier=olap)OLAP, Analysis Services (http://www.connectionstrings.com/?carrier=olap)
http://www.connectionstrings.com/images/icons/sharepoint.gif (http://www.connectionstrings.com/?carrier=sharepoint)SharePoint (http://www.connectionstrings.com/?carrier=sharepoint)
http://www.connectionstrings.com/images/icons/msproject.gif (http://www.connectionstrings.com/?carrier=msproject)MS Projec (http://www.connectionstrings.com/?carrier=msproject)
t (http://www.connectionstrings.com/?carrier=msproject)http://www.connectionstrings.com/images/icons/acdi.bmp (http://www.connectionstrings.com/?carrier=activedirectory)Active Directory (http://www.connectionstrings.com/?carrier=activedirectory)
http://www.connectionstrings.com/images/icons/exchange.bmp (http://www.connectionstrings.com/?carrier=exchange)Exchange (http://www.connectionstrings.com/?carrier=exchange)
http://www.connectionstrings.com/images/icons/quickbase.gif (http://www.connectionstrings.com/?carrier=quickbase)Intuit QuickBase (http://www.connectionstrings.com/?carrier=quickbase)
http://www.connectionstrings.com/images/icons/lotusnotes.gif (http://www.connectionstrings.com/?carrier=lotusnotes)Lotus Notes (http://www.connectionstrings.com/?carrier=lotusnotes)
http://www.connectionstrings.com/images/icons/dsn.gif (http://www.connectionstrings.com/?carrier=dsn)DSN (http://www.connectionstrings.com/?carrier=dsn)
http://www.connectionstrings.com/images/icons/udl.gif (http://www.connectionstrings.com/?carrier=udl)UDL (http://www.connectionstrings.com/?carrier=udl)
http://www.connectionstrings.com/images/icons/msindexserver.gif (http://www.connectionstrings.com/?carrier=msindexserver)Index Server (http://www.connectionstrings.com/?carrier=msindexserver)
http://www.connectionstrings.com/images/icons/htmltable.gif (http://www.connectionstrings.com/?carrier=htmltable)HTML Table (http://www.connectionstrings.com/?carrier=htmltable)

اینم روش های متصل شدن به بانک اکسس


http://www.connectionstrings.com/images/icons/access.gif Access

This is a compiled connection strings reference list on how to connect to Access.


ODBC
Standard Security




Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
Workgroup




Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatab ase.mdw;




Exclusive



Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=adm in;Pwd=;


Enable admin statementsTo enable certain programatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.



Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;Exte ndedAnsiSQL=1;


Specifying locale identifierUse this one to specify the locale identifier which can help with non-US formated dates.



Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Locale Identifier=2057;Uid=Admin;Pwd=;

The above example uses the en-gb locale identifier (2057)OLE DB, OleDbConnection (.NET)
Standard security



Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;


With database passwordThis is the connection string to use when you have an access database protected with a password using the Set Database Password function in Access.



Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;


Workgroup (system database)



Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;


Workgroup (system database) specifying username and password



Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;


DataDirectory functionality



Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;



اینم روش متصل شدن به اکسس 2007


http://www.connectionstrings.com/images/icons/access2007.gif Access 2007

This is a compiled connection strings reference list on how to connect to Access 2007.
ACE OLEDB 12.0

Standard security



Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;


With database passwordThis is the connection string to use when you have an Access 2007 database protected with a password using the "Set Database Password" function in Access.



Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;


DataDirectory functionality




Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Pers ist Security Info=False;

[qazwsx]

ممنون سایت خوبی بود ولی مشکلم حل نشد ببین من رو فرمم یه tabelمیزارم و با کد زیر میخوام وصل بشم ولی باز خطای بالا رو میگیره

ADOConnection1.ConnectionString:='Provider=Microso ft.Jet.OLEDB.4.0;Data Source=f:\se exe\data\data1.mdb;User Id=admin;Password=q;';
ADOConnection1.Connected:=true;
Table2.Connection:=ADOConnection1;
table2.TableName:='pas';
table2.Active:=true;
Table2.Open;
Table2.First;

[tefos666]

فکر کنم فقط اسم پایگاه رو بدی کفایت کنه - اینجوری سورس رو هرجا دیگه ببری کار میکنه وگرنه باید یه آدرس مثل مال خودت درست کنی و فایل اکسس رو توش کپی کنی


ADOConnection1.ConnectionString:='Provider=Microso ft.Jet.OLEDB.4.0;Data Source=data1.mdb;User Id=admin;Password=q;';
خاصیت login promt رو false کن
ضمنا خیلی عجیبه این خطا معمولا باید موقعی داده بشه که یک کاربر دیگه یا برنامه دیگه هم داره از بانک اطلاعاتی شما استفاده میکنه ، از Workgroup file برای دیتابیس استفاده کردی ؟
حتمالا مشکل اینه که بانک خودتون رو در محیط دلفی Active کردید و بعد که برنامه اجرا میشه ،‌دوباره نمیتونه فایل بانک رو لود کنه ! ، بهتره بانکتون رو با شروع برنامه لود کنید ...
حالا اول راه زیر رو امتحان کن ببین جواب میده ؟ احتمال 99% مشکلت حل بشه



ADOConnection.Connected := False;
ADOConnection.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb;Persist Security Info=False;Jet OLEDB:Database Password=tefos666';
ADOConnection.Connected := True;

[qazwsx]

درست شد از کد زیر استفاده کردم درست شد
d1:=Td1.Create(nil);
s:=ExtractFileDir(Application.ExeName);
d1.ADOConnection1.ConnectionString:='Provider=Micr osoft.Jet.OLEDB.4.0;Data Source='+
s+'\data\data1.mdb;Jet OLEDB:Database Password=q;';
d1.Table2.Connection:=d1.ADOConnection1;
d1.table2.TableName:='log';
d1.table2.Active:=true;
d1.Table2.Open;
d1.Table2.First;