I have a pre-saved static MS Access Report that I am Opening through a Form in MS Access. The User has two options from my Form. Option 1) Simply Open the Saved Report by selecting the Report via ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23394625.html
Hello,
In a access database I have two tables, lets call them table1 and table2.
table1 consists of an ID number and a text value.
table2 store several ID numbers from table1 in a comma separa...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23798638.html
Hey
I am migrating an Access DB to SQL Server. I have achieved this by using DTS and then creating the stored procedures and triggers from the Access queries. Happy enough
Now I want to link ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20354528.html
Zones:
MS AccessDate Answered: 09/18/2002 Grade: A Views: 0
Below is the MSSQL sql statement that generate the subsequent output.
How do I change the MSSQL sql statement to MSACCESS sql statement which can generate similar output?
SQL
select a.dis...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21224113.html
Zones:
MS AccessDate Answered: 12/02/2004 Grade: A Views: 0
What is the best way to secure users from seeing data on SQL and MSAccess on a WindowsNT OS. Do you have to have each seperately secured or do that work together?? Is there any information anywher...
http://www.experts-exchange.com/Security/Misc/Q_21499978.html
Zones:
SecurityDate Answered: 08/11/2005 Grade: A Views: 0
I would like to access a table in MS Access from a stored procedure on MS
SQL 2000. The MS Access DB is on the same server as the MSSQL Server.
How do I make the "connection" between the two sy...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21730663.html
I have an unbound Access form that has some unbound listboxes. The purpose of the form is to show a user and their assigned roles and the status of the role. I will give some data to explain what i...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22751177.html
hi....
i am using vb for my application and MS Access.
i understand that in sql, it is possible to write sql coding to check for existing before creating the table (temp table) to avoid a duplica...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20614332.html
Zones:
Visual BasicDate Answered: 05/20/2003 Grade: A Views: 0
Hi
I am using MSAccess as frontend and SQL. I am importing 3 text files with transfertext (delimited) and I need to lock 3 tables (before transfer text) that i am overwriting with transfertext...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21637802.html
Zones:
MS AccessDate Answered: 11/22/2005 Grade: B Views: 0
Hi Guys,
Im trying to modify a program that will run and can switch into two back-ends(MSSQL and MSACCESS) and initially it is working and with no issues using the MS SQL server side. But when I...
http://www.experts-exchange.com/Programming/Misc/Q_21698307.html
Zones:
ProgrammingDate Answered: 01/29/2006 Grade: A Views: 0
