How to create login form by myself in access data project

[Saroeurn Long]

I want want to create Form and write code to connect to SQL Server by
myself. I don't want to use built-in login form.

Thanks,

 

[BALINT]

You just want to link SQL tables to Access?

In Tables Tab, right click\Link Tables
Change Files of Type to ODBC.

Enter location of SQL tables... pretty easy, just follow your nose from
there.

 

[Saroeurn Long]

I don't want LINK table. Because I have Database as Access Project. When the
user open database, I want display my Login form connect ot SQL Server to
access data.


Thanks,

 

[Sylvain Lafontaine]

Don't know if this will work but many people have mentionned using the
functions Close and Open of the current connection object:

Application.CurrentProject.Connection.Close
Application.CurrentProject.Connection.Open "... Connection string ..." .

However, like I said, I never tried this myself.

 

[Brendan Reynolds]

If I remember correctly, I think there may be an example of this in the ADP
version of Northwind. I think it is called NorthwindCS.adp.