|
Hi friends. I have a small software that uses an access database. I use it at home but i wonder if i can use it from anywhere by reaching the db over internet. Should i change any code to do so. By the way if Access doesnt support this function, i can replace my db with sql server.
|
|
|
|
|
Bad idea; Microsoft Access is not meant to be used as a server, and it ain't as secure as Sql Server. I'd even recommend against using Sql Server over the internet, would be safer to have IIS on the same server and provide access to the DB using webservices.
I can imagine you don't want to "waste time" with writing a useless layer. If my memory serves me correct, you'd open port 1433 on the firewall. Updating from Access to Sql Server should be easy; if you open the DB in Access, you'll have a button in that lint that says "upgrade to Sql Server" - that launches a wizard that recreates all your tables in Sql Server.
Hope this helps 
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
leone wrote: I use it at home but i wonder if i can use it from anywhere by reaching the db over internet.
As stated no.
MS Access is a file based server. Thus if you have software that uses MS Access then the file must be visible in file system of the client machine.
Thus if you want to run the software on machine A then on A you MUST be able to open explorer and see the database file.
That means that you would need to enable file sharing over the internet. You might be able to do that depending on the machines at either end and how they are connected.
leone wrote: i can replace my db with sql server.
MS SQL Server is accessible via the internet as long as the server machine is accessible. That is not guaranteed (machine is visible) but that is a different discussion.
It is possible to secure MS SQL Server so it can be exposed on the internet however either you must presume that your data is not secure and not important or you are going to need to learn a lot more about internet security and SQL Server before using it. It probably isn't worth learning that since it isn't a skill that businesses want.
|
|
|
|
|
Thank you friends for your answers. I decided to hire a server machine and put everyhing on it.
|
|
|
|
|
Don't understand why this was downvoted, (over)compensating.
|
|
|
|
|
Access can only be used remotely on MS Sharepoint websites, but you could uses Access as a data store behind a hosted web application (though I would suggest the use of SQL server).
Alternatively, you can use Access as the front end to a hosted SQL server database, so your user interface is local, but links to the remote database.
Many web service providers offer MSSQL and/or MySQL databases
====================================
Transvestites - Roberts in Disguise!
====================================
|
|
|
|
|
Hey.. I am developing an windows form application using ms sql server 2008. and i want to connect my sql server to cloud at internet to use it as backup. if there is any changes made bu application in local server then it should be reflected on cloud also. and if there is any loss of data at local server then it should get backup automatically from cloud.
Can someone help me in this please.. ??
|
|
|
|
|
You seem to be describing replication. See if your cloud provider will support that type of configuration. Sounds like overkill to me.
You can build a very robust database server configuration locally and maybe use the cloud to store your database backups. Before shipping the databackups to the cloud you might want to investigate data encryption. I don't know the type of data your are working with, but I wouldn't want my personal information stored in the cloud without being encrypted.
|
|
|
|
|
KUNWAR999 wrote: Can someone help me in this please.. ??
You already received help in the C# forum. Pete posted the best answer, as far as I can judge.
Did you try his answer, what where the results, and why are you repeating the question? It'd be appreciated if you at least included a link to the prior question, otherwise I'll simply start copy/pasting the old answers to your question. Same question -> same answer.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi All,
I'm trying to send an email using a SQL procedure within SQL Anywhere 11. I have the following SQL statements to do this:
ALTER PROCEDURE "DBName"."WebFormNotify"()
begin
call xp_startsmtp('*A*@***.org', 'SMTP_Relay_server_name');
call xp_sendmail(recipient = '*B*@***.org',subject = 'SMTP SYBASE TEST',"message" = 'SMTP SYBASE TEST');
call xp_stopsmtp()
end
This is being ran from the server that has SMTP Relay setup on it. I am able to use telnet and send an email successfully. The procedure runs with no errors but the email is never recieved by the recipient. I have also replaced the second parameter passed into xp_startsmtp with the name of the actual SMTP server itself, but still no email was recieved by the recipient.
Any help on this would be really appreciated. Pleas elet me know if additional information is needed.
Thank you,
Mel
|
|
|
|
|
I'd start by capturing the return code from the calls. The MAPI errors will likely tell you what is failing. At a guess, it is possible that some form of authentication may be necessary to get this to work.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
xp_startsmtp is a system procedure that starts a mail session for a specified email address by connecting to an SMTP server. This connection can time out. Therefore, it is recommended that you call xp_startsmtp just before executing xp_sendmail.
If you specify smtp_auth_username and smtp_auth_password, and the server does not support the SMTP authentication capability, error code 104 is returned.
Virus scanners can affect xp_startsmtp, causing it to return error code 100. For McAfee VirusScan version 8.0.0 and later, settings for preventing mass mailing of email worms also prevent xp_sendmail from executing properly. If your virus scanning software allows you to specify processes that can bypass the mass mailing protections, specify dbeng12.exe and dbsrv12.exe. For example, with McAfee VirusScan you can prevent mass mailing by adding these two processes to the list of Excluded Processes in the Properties area.
Documentation[^]. Which error-code is it returning btw?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
I am creating report for displaying continuous absent for more than 2 days.Query is build and working fine.Range is passed by using @StartDate and @EndDate. but problem is if In between two absent week off comes then it is also considered as continuous absent.i want to add that functionality to the existing query.How can i do that?
Existing query is:
WITH Dates
(
EntryDate,
EmployeeNumber,
Status,
Days,
EmployeeCode,
EmployeeName,
DeptName,
JobName,
HOD,
Supervisor
)
AS
(
SELECT
a.[DATE],
a.EmployeeID,
a.Status,
1,a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
tblEmployeeAttendance1 a
WHERE
a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O')
UNION ALL
SELECT
a.[DATE],
a.EmployeeID,
a.Status,
CASE WHEN (a.Status = Parent.Status) THEN Parent.Days + 1 ELSE 1 END,
a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
tblEmployeeAttendance1 a
INNER JOIN
Dates parent
ON
datediff(day, a.[DATE], DateAdd(day, 1, parent.EntryDate)) = 0
AND
a.EmployeeID = parent.EmployeeNumber where a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O')
)
SELECT * FROM Dates where days>=2 order by EmployeeNumber, EntryDate
|
|
|
|
|
You may need to build a calendar of work days. Saw a link a couple of days ago but do not remember where. 
|
|
|
|
|
WITH Dates
(
EntryDate,
EmployeeNumber,
Status,
Days,
EmployeeCode,
EmployeeName,
DeptName,
JobName,
HOD,
Supervisor
)
AS
(
SELECT
a.[DATE],
a.EmployeeID,
a.Status,
1,a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
tblEmployeeAttendance1 a
WHERE
a.[Date] between @StartDate and @EndDate and (a.status=
-- RECURSIVE
UNION ALL
SELECT
a.[DATE],
a.EmployeeID,
a.Status,
CASE WHEN (a.Status = Parent.Status) THEN Parent.Days + 1 ELSE 1 END,
a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
tblEmployeeAttendance1 a
INNER JOIN
Dates parent
ON
datediff(day, a.[DATE], DateAdd(day, 1, parent.EntryDate)) = 0
AND
a.EmployeeID = parent.EmployeeNumber where a.[Date] between @StartDate and @EndDate and (a.status=
)
SELECT * FROM Dates where days>=2 order by EmployeeNumber, EntryDate
I have added AND datepart(dw,a.[Date]) NOT IN (1,7), which will excludes weekly off days.
this would work perfactly.
|
|
|
|
|
i have three comboboxes and a sub form whose recordsource is from same table.these both and a save button are present in a main form .according to combo box selected values the sub form displays the corrresponding data. i can edit the sub form and when i click on save button the values in the combo boxes and corresponding data in sub form should be updated in the msaccess table from where they come..can any body tell solution to this?
|
|
|
|
|
Is it possible to specify from the override of onmodelbuilding() the starting value to use for a table primary key and the seed value to use for generating the rest columns? I'm using 4.1 code first
|
|
|
|
|
your description doesn't tell us what you are using? what is 4.1 code?
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
I think he might mean Entity Framework 4.1. Just a guess.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
You might start here and read the documentation: Tutorial: Code First with EF 4.1[^]. Maynot have the answer but might point you in the right direction.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
To add to the rest of the advice; It's a bad idea to tinker with the seed-values. You should NOT be wasting time on having them start from a particular range (like 1).
Why? Because the artificial key does not hold information, it is merely a link to another record. It's contents should not be relevant outside that purpose. Ever.
Second, having an artificial key does not mean that you no longer need to find the "real" primary key, the combination of (non-identity) fields that make the record unique. Why? Because the user needs to be able to differentiate between the records, based on something else than an artificial identity that holds no information.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
I have someone who stores a modest amount of data by file path in different directorys on a network share. The path to the network share identifies the data. They now want to store some data in a database and whould like to store the data in different database files in each of the shared network folders. My question is, is this even a remotely good idea.
|
|
|
|
|
Until they tell you the reason behind it I'd say: Not even a remotely good idea.
|
|
|
|
|
Unless there is a very good reason, it sounds like a moderately horrible idea to me.
|
|
|
|
|
Thanks, I think the reason they want to do this is that it would tie into their existing scheme for backing up data.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
