Search results

Hello Everyone, I have an relation issue which is working in MS Access but not in SQL Server BE. That was my relation completely same when I had BE also in MS Access. Now I did this in SQL Server BE with linked table. I have following table structure and database relation between two tables...

Dear Friends, I have linked tables from SQL server and adjusted all queries based on new linked tables' names in my MS Access and tested it. İt workes a little slow in compared to compact MS Access (When the table is also from Access itself). Forms and reports are opening a bit more slowly...

Galaxiom also Minthy, I really thanks a lot. Now at least I know I am in the right direction and I can defend my argument confidently against IT guys. But before that I need some more clarifications from you at some points. Please confirm me if I understood this two different connection...

Thanks Sir Galaxiom. I have created file dsn. But I am connecting SQL Server Management Studio with windows authentication. So I tested today sending Access and dsn file to one user. Dsn file was located in the same address. then we opened the MS Access and clicked linked table. Warning pop...

Hello Everyone, I am struggling for creating a ODBC data source and then link my tables from SQL server. (And please keep in mind that I will distribute FE MS Access with Email to all users after linking process has been done. So they need to be able to make data changes as linked with SQL...