|
There are two methods for securing a Microsoft Access database;
1) Database-password
This is like password-protecting a zipfile. You'll need the password to open the database. This can be done from within the Access-application.
2) System.mdw
In that case, every user has a username and a password. The workgroup information is stored in the "System.mdw" file.
You'd want the first option, I believe. A connectionstring with a database-wide password can be found here[^].
Good luck
I are troll
|
|
|
|
|
thanks for your reply
But could you please tell me why am I getting the error.(when I try to get the exact connection string using con1.udl which I have created in the desktop )
thanks in advance
-----------------------------
I am a beginner
|
|
|
|
|
Probably because MS Access expects a workgroup-database. More information on that can be found here[^].
I are troll
|
|
|
|
|
Good Morning All
i have the Following Results
DESCR CYCLES
---------------------------------------
Galloway A Ms 20 21
Gama, E 20 21
Giatsi M Ms 20 21
Gibbon F Prof 20 21
Gibson C Ms 20 21
Gilfillin, P 20 21
Galloway A Ms 21 20
Gama, E 21 20
Giatsi M Ms 21 20
Gibbon F Prof 21 20
Gibson C Ms 21 20
Gilfillin, P 21 20
Now all this are Correct but i need to get rid of a duplicates. Check the Bolded part
Gilfillin, P 21 20 . i have reproduced this table from the Following
I have a First Stored Procedure doing the Following
ALTER PROC [dbo].[sp_Get_Staff_Cycles]
(
@ACTIVITY_ID INT
)
AS
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FINAL]'))
drop table [FINAL]
SELECT S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE
INTO FINAL FROM TBL_STAFF S
INNER JOIN MTM_ACTV_STAFF MTN ON
S.ID = MTN.STAFF
LEFT OUTER JOIN tbl_Cycles_Staff C
ON C.IDL = MTN.ID
WHERE MTN.ACTV = @ACTIVITY_ID
and lets Follow the Final table and the following Stored Procedure that does the Following
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROC [dbo].[sp_Get_Staff_Cycles_internal]
AS
--
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FINAL_NEW_FINAL]'))
DROP TABLE FINAL_NEW_FINAL
--ADD THIS TO A NEW TABLE NAMED 'FINAL_NEW_FINAL'
Select t1.DESCR, STR(t1.CYCLETEMPLATE) + ''+ STR(t2.CYCLETEMPLATE) AS [CYCLES]
INTO FINAL_NEW_FINAL From FINAL t1, FINAL t2
Where t2.DESCR = t1.DESCR
And t2.CYCLETEMPLATE <> t1.CYCLETEMPLATE;
--Get the Missing Records
--INSERT THE ONE THAT WAS MISSING
INSERT INTO FINAL_NEW_FINAL
SELECT DESCR ,CYCLETEMPLATE
FROM FINAL
WHERE DESCR NOT IN (SELECT DESCR FROM FINAL_NEW_FINAL)
-- Final Data for Rendering
SELECT DESCR,CYCLES FROM FINAL_NEW_FINAL
Now this above sp produce those Duplicates
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Vuyiswa Maseko wrote: INSERT INTO FINAL_NEW_FINAL SELECT DESCR ,CYCLETEMPLATE FROM FINAL
Change your 'SELECT' to 'SELECT DISTINCT'.
Tim
|
|
|
|
|
Good day Tim
The "DISTINCT" is not doing the Job, still it brings Duplicates.
Thanks
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
And if you change
And t2.CYCLETEMPLATE <> t1.CYCLETEMPLATE
to
And t2.CYCLETEMPLATE > t1.CYCLETEMPLATE
Wout Louwers
|
|
|
|
|
That is the Most Amazing Answer i have ever got Today.
You have made my day
It worked Like Charm
Vuyiswa Maseko
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi,
In my database, I have two tables DocFiles and VisioFiles.
One of the column in DocFiles contains Document files(.doc) in form of binary data.
One of the column in VisioFiles contains Visio files(.vsd) in form of binary data.
when I searched for a word in DocFiles, it returned corresponding rows..
But when I searched for a word in VisioFiles, it is not returning any rows.(Though there are few records).
Does FREETEXT has restriction on Visio files?
Please guide me to solve this problem.
Thanks in advance.
|
|
|
|
|
Say you declared a cursor (This is MySQL but question is for M$SQL + MySQL + Oracle)
<br />
DECLARE SomeCursor CURSOR FOR <br />
SELECT ...<br />
FROM PersonMap<br />
WHERE <br />
Id = XXXX<br />
CURSOR is only visible to current connection/session? I was told this is the case for MySQL.
Thanks
dev
|
|
|
|
|
Having a little trouble with the concept of creating a cursor over a connection. Just where are you creating the cursor?
I have only ever user cursors in a stored proc (cursors are EVIL) which is called/executed by the client or another proc, the cursor resides in the proc!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i'm using sql server 2005 for my asp.net program.
i have 2 tables, first table X, second table Y
X has column:
DEM_ID int
DEM_DATE datetime
DEM_QTY numeric(18,0)
constraint PK_DEMAND primary key nonclustered (DEM_ID)
Y has column:
FRC_ID int
FRC_YEAR numeric(4)
FRC_MON numeric(2)
FRC_SALES numeric(18,0)
FRC_FRCSALES numeric(18,0)
FRC_FRCLOG numeric(18,0)
constraint PK_FORECASTSALES primary key nonclustered (FRC_ID)
What i want to do is put each month and year from col dem_date in table X to col frc_year and frc_mon in table Y and put sum dem_qty per mon and year to frc_sales. and then get frc_frcsales row values from calculation (e.g for row 90 = (4*89th row in col frc_sales)+(6*84th row in col frc_sales+....), for row 91 =(4*90th row in col frc_sales)+(6*85th row in col frc_sales+....) ) and continues everytime i had new row on table X.
Best Regards and Thanks in advance.
|
|
|
|
|
And what have you tried so far?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
i've tried using convert date to get month and year value, and group by to make it grouped by month and year. but my trigger didn't work when i tried to update frc_frcsales value.
|
|
|
|
|
It is good that you have tried, however, people are often unwilling to do posters work for them, sometimes you can get lucky but mostly not.
Usually they like to see some code so that they can guide the poster in the right direction, or point out incorrect usage, or whatever. So I would suggest that you will get more answers if you post some code, nicely formatted for easy reading of course.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hi all
i need sybase ver.10 ODBC driver
thanks for any help
bye
|
|
|
|
|
Google give about 279000 hits for 'sybase ver 10 ODBC driver'.
One of them might be useful.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
really first time i knew that there is a site called google
thanks for your time
bye
|
|
|
|
|
Hi all,
Select distinct(Mobile), ROW_NUMBER() OVER(PARTITION BY mobile ORDER BY dateofcall DESC ) AS 'RowNumber' from Call
having RowNumber=1
Error Invalid coulmn RowNumber
Can any one advice please?
Thank you
|
|
|
|
|
The columname-alias "RowNumber" can only be used in a ORDER BY clause. Try this one;
SELECT TOP 1
distinct(Mobile), ROW_NUMBER() OVER(PARTITION BY mobile ORDER BY dateofcall DESC ) AS 'RowNumber' from Call
I are troll
|
|
|
|
|
top 1 returns one record.what i want is to select only those that has a first entry to my database.RowNumber=1
|
|
|
|
|
You can change the sorting by changing the ORDER BY clause, so that the first row is the first entry
I are troll
|
|
|
|
|
I cannot connect to a remote sql server 2005 database from my computer at work.
I'm using sql server 2005 express edition.
My work computer is inside a local network (work network) and obtains its ip address automatically (so it has no real ip).
I can connect successfully to the remote database through my home computer and through a server at work and both have real ips.
I've checked everything (firewall is disabled and all sql server services are working).
I think there is something blocking this connection related to the work network but I don't know what it is exactly.
I contacted the IT department but they don't know what's wrong.
I read somewhere that sql server uses port 1433. Could this be the cause??
Can someone help me out please?
|
|
|
|
|
How are you attempting to connect?
Are you using a name or an IP,Port combo?
If you are using a name to connect, e.g MainServer, try using a IP,Port combination instead, e.g 192.168.1.1,1433
|
|
|
|
|
well, yes I'm connecting using a name,port combo.
I don't really know the IP address.
How can I get the IP address?
Here's the error that sql server displays:
TITLE: Connect to Server
------------------------------
Cannot connect to name,port.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476
|
|
|
|