How do I make my access db into a multiuser on a server?

I been trying to split my database on a SQL Server but its almost impossible to split and make that multiuser. Other thing it is possible for a multiuser use the database in access without having the program on their computers just connecting to the server?This forum is for IBM's DB2 database only. Try the SQL Server forum.

How do I make a field automatically get its values from anothe

David,
Thanks for your response. We're using an Access Form as a front-end to enter
data into this SQL Server table. So I'm not really using a storedproc to
enter data. Would using a trigger the only way to handle this then?
Thanks,
Sam
"David Portas" wrote:

> Sam wrote:
> I'm assuming you'll use stored procs for your inserts of course. So use
> an optional parameter and assign the default in the proc:
> CREATE TABLE dbo.PaymentSchedule (PaymentDate SMALLDATETIME NOT NULL,
> UpdatedPaymentDate SMALLDATETIME NOT NULL /* ... key? */);
> GO
> CREATE PROCEDURE dbo.usp_PaymentScheduleInsert
> (
> @.PaymentDate SMALLDATETIME,
> @.UpdatedPaymentDate SMALLDATETIME = NULL
> )
> AS
> INSERT INTO dbo.PaymentSchedule (PaymentDate, UpdatedPaymentDate)
> VALUES (@.PaymentDate, COALESCE(@.UpdatedPaymentDate,@.PaymentDat
e));
> GO
> EXEC dbo.usp_PaymentScheduleInsert
> @.PaymentDate = '2006-04-30T00:00:00.000' ;
>
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>Sam (Sam@.discussions.microsoft.com) writes:
> Thanks for your response. We're using an Access Form as a front-end to
> enter data into this SQL Server table. So I'm not really using a
> storedproc to enter data. Would using a trigger the only way to handle
> this then?
Yes, but I guess David's hint is that you should start using stored
procedures.
The trigger would look like:
CREATE TRIGGER sams_trigger ON tbl FOR INSERT AS
UPDATE tbl
SET updatedpaymentdate = i.paymentdate
FROM tbl
JOIN inserted i ON tbl.pkcol = i.pkcol
However, judging from the narrative, it seems to me that it would be
better to leave the column NULL. I'm assuming then that when the data is
entered, there has been no update to the payment date yet.
Then again, it was not clear to me whether this column is intended to
catch the date the client actually paid, or if this is a date agreeed-on
beforehand as the new date for the payment.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

How do I locate a Database on SQL Express from Access 2003.

Access 2003 Data exported to SQL Express , great.

How do I then link the tables to the new database, I only seem to be able to link to system tables etc ?

Any ideas ?

Hi,

I assume that you are trying to link external table(s) and going through "ODBC Databases"? Then you probably have an ODBC DSN defined?

I've done that and my user table is neatly sean in the list together with the system views, etc. What you are probably experiencing is a misalignment of permissions. The following chain should be unbroken in order for you to see the user tables:

(a) Client Application security context (in this case - MSAccess)

(b) ODBC DSN connection settings - are you using SQL Authentication?

(c) SQL Server account (SQL or NT authentication)

(d) Database user associated with the account

(e) Appropriate schema/object permissions

Check each of these and see if everything is in order. You could also experiment with the SQL Management Studio or SQL Query Analyzer with the credentials used in MSAccess and see if the table(s) would be visible.

HTH,

Jivko Dobrev - MSFT

--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Many thanks, sorted, hadn't selected database from options for users.

Thanks again Racing Snake

How do I locate a Database on SQL Express from Access 2003.

Access 2003 Data exported to SQL Express , great.

How do I then link the tables to the new database, I only seem to be able to link to system tables etc ?

Any ideas ?

Hi,

I assume that you are trying to link external table(s) and going through "ODBC Databases"? Then you probably have an ODBC DSN defined?

I've done that and my user table is neatly sean in the list together with the system views, etc. What you are probably experiencing is a misalignment of permissions. The following chain should be unbroken in order for you to see the user tables:

(a) Client Application security context (in this case - MSAccess)

(b) ODBC DSN connection settings - are you using SQL Authentication?

(c) SQL Server account (SQL or NT authentication)

(d) Database user associated with the account

(e) Appropriate schema/object permissions

Check each of these and see if everything is in order. You could also experiment with the SQL Management Studio or SQL Query Analyzer with the credentials used in MSAccess and see if the table(s) would be visible.

HTH,

Jivko Dobrev - MSFT

--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Many thanks, sorted, hadn't selected database from options for users.

Thanks again Racing Snake

sql

How do I link tables to another database?

With Access, I could link to tables in a foreign db, even a csv file, and
query them as if they were local tables. How do I do that in SQL Server?Check out OPENROWSET and OPENQUERY in BOLsql

How do I know whether this database is published or not?

G'Day
Some of our customers have the db replicated, some not. (SQL-Server 2000)
How can find out, whether the db is published or not without access to the
master db?
thanks
Aline
Aline,
The sp_dboption procedure will give you this information. Pass the database
name as the parameter.
The output will look something like this:
The following options are set:
published
select into/bulkcopy
merge publish
trunc. log on chkpt.
auto create statistics
auto update statistics
Alternatively:
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

How do I install Reporting services?

I come from access development background and I am new to SQL Server. I am
trying to learn it using the Developer edition. When I was installing SQL
server 2005 Developer edition, I came to the "Components to Install, Select
the components to install or upgrade"on the setup form , I noticed that
"Reporting Services" option was disabled is there a reason why? how can I
install it. After instalation, I tried to use the configure tools to
configure Report server I got the message "No report servers were found on
the specified machine.details: Invalid namespace". I had a dialog box
entiteled "Report Server Installation Instance Selection" with the Machine
Name box enabled and the machine name was entered but the "Instance name box"
was disabled? any idea.
thanks
AlYou need to installed the report service component from your Windows Server
2003 operating system
"Al" wrote:
> I come from access development background and I am new to SQL Server. I am
> trying to learn it using the Developer edition. When I was installing SQL
> server 2005 Developer edition, I came to the "Components to Install, Select
> the components to install or upgrade"on the setup form , I noticed that
> "Reporting Services" option was disabled is there a reason why? how can I
> install it. After instalation, I tried to use the configure tools to
> configure Report server I got the message "No report servers were found on
> the specified machine.details: Invalid namespace". I had a dialog box
> entiteled "Report Server Installation Instance Selection" with the Machine
> Name box enabled and the machine name was entered but the "Instance name box"
> was disabled? any idea.
> thanks
> Al|||Hi,
to clarify this a bit, there is no reporting services components of the
Windows 2003 Server system, but Reporting Services has the
prerequisites of IIS Service. This has to be installed from the
"Add/Remove Software" panel with the appropiate Windows 2003 Server
media.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thank you for responding. I do not have the Windows 2003 Server. I am
installing the Developer edition locally on Windows xp professional. is there
away to do it? is there another place (microsoft website) where I get IIS
service?
thanks
Al
"Jens" wrote:
> Hi,
> to clarify this a bit, there is no reporting services components of the
> Windows 2003 Server system, but Reporting Services has the
> prerequisites of IIS Service. This has to be installed from the
> "Add/Remove Software" panel with the appropiate Windows 2003 Server
> media.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||For developer edition of SQL Server, you do not need Win2003 server. WinXP
is OK. You need to have IIS running (install it if you haven't. Since you
have WinXP Pro, you are OK).
"Al" <Al@.discussions.microsoft.com> wrote in message
news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> Thank you for responding. I do not have the Windows 2003 Server. I am
> installing the Developer edition locally on Windows xp professional. is
> there
> away to do it? is there another place (microsoft website) where I get IIS
> service?
> thanks
> Al
> "Jens" wrote:
>> Hi,
>> to clarify this a bit, there is no reporting services components of the
>> Windows 2003 Server system, but Reporting Services has the
>> prerequisites of IIS Service. This has to be installed from the
>> "Add/Remove Software" panel with the appropiate Windows 2003 Server
>> media.
>> HTH, Jens K. Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>|||Windows XP Pro has IIS but it is not running/installed. Go to Control Panel,
Add/Remove, then on the left there will be a selection called something like
Windows Components. You need to have IIS running prior to installing RS. You
also need to have SQL Server Installed. If you are installing RS 2005 then
you can install both SQL Server and RS at the same time. Note you will have
two installs. The server install and then the client tools. I strongly
recommend using RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> Thank you for responding. I do not have the Windows 2003 Server. I am
> installing the Developer edition locally on Windows xp professional. is
> there
> away to do it? is there another place (microsoft website) where I get IIS
> service?
> thanks
> Al
> "Jens" wrote:
>> Hi,
>> to clarify this a bit, there is no reporting services components of the
>> Windows 2003 Server system, but Reporting Services has the
>> prerequisites of IIS Service. This has to be installed from the
>> "Add/Remove Software" panel with the appropiate Windows 2003 Server
>> media.
>> HTH, Jens K. Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>|||yes you are right. I tried to install the IIS from the windows Components
and from the original cd and made all the selections it asked me. I then
restarted my computer but nothing happened. it does not show on the control
panel>add remove program and it does not show on the all programs menu. how
do I know if it was installed?
Al
"Bruce L-C [MVP]" wrote:
> Windows XP Pro has IIS but it is not running/installed. Go to Control Panel,
> Add/Remove, then on the left there will be a selection called something like
> Windows Components. You need to have IIS running prior to installing RS. You
> also need to have SQL Server Installed. If you are installing RS 2005 then
> you can install both SQL Server and RS at the same time. Note you will have
> two installs. The server install and then the client tools. I strongly
> recommend using RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <Al@.discussions.microsoft.com> wrote in message
> news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> > Thank you for responding. I do not have the Windows 2003 Server. I am
> > installing the Developer edition locally on Windows xp professional. is
> > there
> > away to do it? is there another place (microsoft website) where I get IIS
> > service?
> > thanks
> > Al
> >
> > "Jens" wrote:
> >
> >> Hi,
> >>
> >> to clarify this a bit, there is no reporting services components of the
> >> Windows 2003 Server system, but Reporting Services has the
> >> prerequisites of IIS Service. This has to be installed from the
> >> "Add/Remove Software" panel with the appropiate Windows 2003 Server
> >> media.
> >>
> >> HTH, Jens K. Suessmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
>
>

How do I insert data from an Access db to a empty SQL database

Hi,

I'm new to VS2005 (vb.net) and here my situation

I have form with a dataset1 (tbl1, tbl2, tbl3, tbl4) pulling data from a Access db. and showing it on the form1(databound)

I need to write what is on form1 to the empty dataset2 in SQL 2005 db

I have created a new DB in SQL 2005 with a Table SQL1 which has the same fields as on form1. Please can some one show me how do I do this. Please

Thanks in advance for your response.

-NM

You can use the Export functionality of Access.

See this post for details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295865&SiteID=1

|||

Thanks, Will do

-NM

How do I Import textfile into SQL table using schema

I've been importing delimited textfile data into Access db using a Schema.in
i
file
to describe the text like this
[Import.TXT] ( where the raw text is )
ColNameHeader=False
Format=CSVDelimited
CharacterSet=ANSI
Col1 = Field1 text width 255
Col2 = Field2 text width 255
Col3 = Field3 text width 255
Col4 = Field4 text width 255
With the following code ( VB )
'{Microsoft Text Driver (*.txt; *.csv)}
' paths for the jet engine to find schema & files + text driver for
importation
strCn = "Driver=" & "{Microsoft Text Driver (*.txt; *.csv)}" & ";" & _
"DBQ=" & filepath & ";" & _
"DefaultDir=" & filepath & ";" & _
"Uid=Admin;Pwd=;"
' use ADO - init connection
Set adoCn = New ADODB.Connection
adoCn.Open strCn
then
strSQL = "SELECT * INTO [" & tbl & "] IN '" & dbName & "'"
strSQL = strSQL & "FROM " & txtfile
adoCn.Execute strSQL
to import the text into the appropriate fields in the table.
How do I do this with SQL Server 200?
thanks -- jackTry using DTS Wizard to do the job !
run at shell command "dtswiz"
Pollus Brodeur|||Hi
Along with DTS, you can use BCP or the BCP API. You may also want to look at
the BULK INSERT statement.
John
"hushtech" <hushtech@.discussions.microsoft.com> wrote in message
news:A78B5213-B579-44CC-AA3F-7949BC661C7E@.microsoft.com...
> I've been importing delimited textfile data into Access db using a
> Schema.ini
> file
> to describe the text like this
> [Import.TXT] ( where the raw text is )
> ColNameHeader=False
> Format=CSVDelimited
> CharacterSet=ANSI
> Col1 = Field1 text width 255
> Col2 = Field2 text width 255
> Col3 = Field3 text width 255
> Col4 = Field4 text width 255
> With the following code ( VB )
> '{Microsoft Text Driver (*.txt; *.csv)}
> ' paths for the jet engine to find schema & files + text driver for
> importation
> strCn = "Driver=" & "{Microsoft Text Driver (*.txt; *.csv)}" & ";" & _
> "DBQ=" & filepath & ";" & _
> "DefaultDir=" & filepath & ";" & _
> "Uid=Admin;Pwd=;"
> ' use ADO - init connection
> Set adoCn = New ADODB.Connection
> adoCn.Open strCn
> then
> strSQL = "SELECT * INTO [" & tbl & "] IN '" & dbName & "'"
> strSQL = strSQL & "FROM " & txtfile
> adoCn.Execute strSQL
> to import the text into the appropriate fields in the table.
> How do I do this with SQL Server 200?
> thanks -- jack|||Jack,
If the import file will always be in the same directory, you could
set up a linked server to that directory. This will automatically
use the specifications in the schema.ini file. Here is an example
for exporting, but it should be simple to adapt for importing.
1) Create a directory for the text files. I chose E:\txtsrv
2) Add this as a linked server
EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'e:\txtsrv',
NULL,
'Text'
3) Put an empty text file in this directory (I used empty.txt).
You can do this with master..xp_cmdshell, but I didn't. You
can't do CREATE TABLE on the linked server.
4) Create a schema.ini file to describe how this file should
represent your table. One schema.ini file is used for all the
tables of the linked server.
This is my schema.ini:
[empty.txt]
Format=FixedLength
ColNameHeader=True
Col1=CustomerNumber Long Width 11
Col2=CustomerName Text Width 30
Col3=CustomerDate DateTime Width 25
5) Populate the text-table, replacing the filename's . with # for the
table name.
insert into txtsrv...empty#txt(CustomerNumber, CustomerName,
CustomerDate)
select orderid, customerid, orderdate
from northwind..orders
order by customerid
Steve Kass
Drew University
"hushtech" <hushtech@.discussions.microsoft.com> wrote in message
news:A78B5213-B579-44CC-AA3F-7949BC661C7E@.microsoft.com...
> I've been importing delimited textfile data into Access db using a
> Schema.ini
> file
> to describe the text like this
> [Import.TXT] ( where the raw text is )
> ColNameHeader=False
> Format=CSVDelimited
> CharacterSet=ANSI
> Col1 = Field1 text width 255
> Col2 = Field2 text width 255
> Col3 = Field3 text width 255
> Col4 = Field4 text width 255
> With the following code ( VB )
> '{Microsoft Text Driver (*.txt; *.csv)}
> ' paths for the jet engine to find schema & files + text driver for
> importation
> strCn = "Driver=" & "{Microsoft Text Driver (*.txt; *.csv)}" & ";" & _
> "DBQ=" & filepath & ";" & _
> "DefaultDir=" & filepath & ";" & _
> "Uid=Admin;Pwd=;"
> ' use ADO - init connection
> Set adoCn = New ADODB.Connection
> adoCn.Open strCn
> then
> strSQL = "SELECT * INTO [" & tbl & "] IN '" & dbName & "'"
> strSQL = strSQL & "FROM " & txtfile
> adoCn.Execute strSQL
> to import the text into the appropriate fields in the table.
> How do I do this with SQL Server 200?
> thanks -- jack|||PollusB,
I was able to use the DTS Wizard to get a CSV file into my Table, but I
need to do this programatically on many files every day so a manual operatio
n
is not practical. I have seen some information that indicates DTS can be
used as an object etc., but I have no clue at this point about how that migh
t
be done. If you know how the task can be done using DTS internal to a VB ap
p
I'd sure appreciate it.
thanks for your help -- jack
"PollusB" wrote:

> Try using DTS Wizard to do the job !
> run at shell command "dtswiz"
> Pollus Brodeur
>|||John,
I tried to use a BCP format file, but since my input file has varying
number of columns per row, I wasn't able to get it to work. I've tried the
Bulk Insert approach
and it has the same problem. It wants to have the input 'line' contain the
exact
number of fields as the table, otherwise it gives an unexpected end of line
errror.
I've pretty much given up on the Bulk Insert method because I couldn't find
a method to get around it's limitations. I'm currently looking at how to us
e
DTS in
my application to get the files imported.
Thanks for your suggestions -- jack
"John Bell" wrote:

> Hi
> Along with DTS, you can use BCP or the BCP API. You may also want to look
at
> the BULK INSERT statement.
> John
> "hushtech" <hushtech@.discussions.microsoft.com> wrote in message
> news:A78B5213-B579-44CC-AA3F-7949BC661C7E@.microsoft.com...
>
>|||Steve,
The technique you've suggested is almost verbatim the method I used for
Access
databases. It worked very well in that environment. I couldn't get the
'linked server' to work; I'm actually not familiar with that technique.
Thanks for your suggested solution and code -- jack
"Steve Kass" wrote:

> Jack,
> If the import file will always be in the same directory, you could
> set up a linked server to that directory. This will automatically
> use the specifications in the schema.ini file. Here is an example
> for exporting, but it should be simple to adapt for importing.
> 1) Create a directory for the text files. I chose E:\txtsrv
> 2) Add this as a linked server
> EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
> 'Microsoft.Jet.OLEDB.4.0',
> 'e:\txtsrv',
> NULL,
> 'Text'
> 3) Put an empty text file in this directory (I used empty.txt).
> You can do this with master..xp_cmdshell, but I didn't. You
> can't do CREATE TABLE on the linked server.
> 4) Create a schema.ini file to describe how this file should
> represent your table. One schema.ini file is used for all the
> tables of the linked server.
> This is my schema.ini:
> [empty.txt]
> Format=FixedLength
> ColNameHeader=True
> Col1=CustomerNumber Long Width 11
> Col2=CustomerName Text Width 30
> Col3=CustomerDate DateTime Width 25
> 5) Populate the text-table, replacing the filename's . with # for the
> table name.
> insert into txtsrv...empty#txt(CustomerNumber, CustomerName,
> CustomerDate)
> select orderid, customerid, orderdate
> from northwind..orders
> order by customerid
> Steve Kass
> Drew University
> "hushtech" <hushtech@.discussions.microsoft.com> wrote in message
> news:A78B5213-B579-44CC-AA3F-7949BC661C7E@.microsoft.com...
>
>

How do i hide my db schema from...

everybody except 1 login which is non-sa in sql server 2000.
Even sa should not be able to access the schema.
Also are there anyways encrypt data in sql server 2000You don't. Answer in .server, but it is not much longer than this one.
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261136.176d7b10@.posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
> Even sa should not be able to access the schema.
> Also are there anyways encrypt data in sql server 2000|||There are several third party products that will encrypt the data. A google
search should bring up several.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

How do I give a user access to SQL Server?

Hi all

I tried using my administrator account to add SQLServer as an ODBC Connection, but for some reason when it tries authenticating it fails and the reason is that the user is not trusted to use that connection. Yet on my account i've created on my domain works perfectly.

I've added a new user in SQL Enterprise manager, but i still get that error.

How do I set the user to be trusted to use the connection?

Any and as many assists on this would be great.

Kr33

[edit] - Hmm, actually, I may be misunderstanding the question. I'm going to move this question into the Data Access forum which hopefully can provide better support:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

Sung

|||its better here in the Sql server security section|||

there are two types of login in SQL server

1. the NT login which is used when your server is configured

to use "windows Only" authentication

2. and The SQL server login which is used when your server is configured

to used mixed mode authentication. example of which is the SA login. this is usefull

if your accepting user that not authenticated through windows such as linux user

To configure you server to be on mixed mode authentication. open SQL Enterprise manager

expand the treeview until you reach the desired server. Right click the server. clcik on properties

clcik on security. Then choose "sql server and windows" in the authentication option

note that you can use SA only when you turn on this option

|||Whats your connection string ? If you are not sure about changing the authentication type, you can have a look at my screencasts on my site which will show you how to administer your SQL Server for the change of the authentication mode.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
sql

How do i get rid of a SQL Server login-prompt.

I've got an access 2k2 front-end with a SQL Server express 2005 table
holding all the data.
I've got SQL Server authentication on.
Everytime i open the front-end i have to use my SQL Server
username/login I previously set-up.
I have been told to take out the prompt but cant seem to track down the
solution to this.
Security is not an issue.If you must use SQL server login then use the save password function when
you create the linked tables in Access.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" <p.macrae@.gmail.com> wrote:
> I've got an access 2k2 front-end with a SQL Server express 2005 table
> holding all the data.
> I've got SQL Server authentication on.
> Everytime i open the front-end i have to use my SQL Server
> username/login I previously set-up.
> I have been told to take out the prompt but cant seem to track down the
> solution to this.
> Security is not an issue.
>|||damn that was easy thanks
Dave Patrick wrote:
> If you must use SQL server login then use the save password function when
> you create the linked tables in Access.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "p" <p.macrae@.gmail.com> wrote:
> > I've got an access 2k2 front-end with a SQL Server express 2005 table
> > holding all the data.
> > I've got SQL Server authentication on.
> >
> > Everytime i open the front-end i have to use my SQL Server
> > username/login I previously set-up.
> > I have been told to take out the prompt but cant seem to track down the
> > solution to this.
> >
> > Security is not an issue.
> >|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" wrote:
> damn that was easy thanks

How do i get rid of a SQL Server login-prompt.

I've got an access 2k2 front-end with a SQL Server express 2005 table
holding all the data.
I've got SQL Server authentication on.
Everytime i open the front-end i have to use my SQL Server
username/login I previously set-up.
I have been told to take out the prompt but cant seem to track down the
solution to this.
Security is not an issue.
If you must use SQL server login then use the save password function when
you create the linked tables in Access.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" <p.macrae@.gmail.com> wrote:
> I've got an access 2k2 front-end with a SQL Server express 2005 table
> holding all the data.
> I've got SQL Server authentication on.
> Everytime i open the front-end i have to use my SQL Server
> username/login I previously set-up.
> I have been told to take out the prompt but cant seem to track down the
> solution to this.
> Security is not an issue.
>

How do i get rid of a SQL Server login-prompt.

I've got an access 2k2 front-end with a SQL Server express 2005 table
holding all the data.
I've got SQL Server authentication on.
Everytime i open the front-end i have to use my SQL Server
username/login I previously set-up.
I have been told to take out the prompt but cant seem to track down the
solution to this.
Security is not an issue.If you must use SQL server login then use the save password function when
you create the linked tables in Access.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" <p.macrae@.gmail.com> wrote:
> I've got an access 2k2 front-end with a SQL Server express 2005 table
> holding all the data.
> I've got SQL Server authentication on.
> Everytime i open the front-end i have to use my SQL Server
> username/login I previously set-up.
> I have been told to take out the prompt but cant seem to track down the
> solution to this.
> Security is not an issue.
>|||damn that was easy thanks
Dave Patrick wrote:[vbcol=seagreen]
> If you must use SQL server login then use the save password function when
> you create the linked tables in Access.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "p" <p.macrae@.gmail.com> wrote:|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" wrote:
> damn that was easy thanks

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.
Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:

> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>
|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?
|||Hi
May be look at replication?
http://msdn.microsoft.com/library/de...plsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:

> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could us
e
FTP (possibly through a ASP component) to move your files to the location. I
f
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you wil
l
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:

> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/d...
ad0.asp
John
"needin4mation@.gmail.com" wrote:

> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my Data into SqlServer?

I have a development machine that I have prototyped with access. I don't know how to get the access data into Sql Server on the Internet. Can you help me? I'm not sure where to start. Thank you for any help.

just_for_forums wrote:

I don't know how to get the access data into Sql Server on the Internet.

I am not sure what you are asking? Are you trying to build a web application which will interact with your SQL Server, adding data to a table? Or are you trying to import records from Access into SQL Server? or, something else altogether?|||

tmorton wrote:

just_for_forums wrote:

I don't know how to get the access data into Sql Server on the Internet.

I am not sure what you are asking? Are you trying to build a web application which will interact with your SQL Server, adding data to a table? Or are you trying to import records from Access into SQL Server? or, something else altogether?

I have my web application already. I have everything working. The data is in Microsoft Access on my development machine. I need it in SQL Server on the Internet. I just need to know how to get the data in the table rows to SQL Server. The web application will then be adjusted so that it points to the Internet where data is housed (and where my web pages are).

Thanks for help.

|||

just_for_forums wrote:

The data is in Microsoft Access on my development machine. I need it in SQL Server on the Internet. I just need to know how to get the data in the table rows to SQL Server.

OK then, so you need to do a one-time import of your data from Microsoft Access into your SQL Server.

Which version of Access are you using? And which version of SQL Server?

As far as I know, there are 2 different ways to go about this. You can use the Upsizing Wizard within Access to push the data into SQL Server. Or you can use Data Transformation Services (DTS) within SQL Server to pull your data from Access.|||Thanks. I will look into it. I just so used to an Intranet and having access to all the pieces. I just have access 97. sql server on the Internet is 2000.|||I found that if I right-clicked on my table and exported it, I could export it to an ODBC data source.

How do I get db ddl properties from sql 2000 like documenter does in MS Access?

Hi,

I am looking for an easy way to get all of the properties from a SQL 2000
database much like the documenter does in MS Access. Any ideas?Ok, I take back, swag sucks! I just ran the app and I must say this is a DBA
's dream come true! Especially for a person like me that is a coder by trade
and forced to maintain SQL db's due to the client's small budgets. The plain
and simple fact is, in the five minutes it took to run the application, it
paid for itself ten times over. I love it! I recommend it to everybody.

Get Yours...

http://ag-software.com/ags_scribe_index.aspx

"NOSPAM" <NOSPAM@.shaw.ca> wrote in message
news:sO4Cb.661224$6C4.599221@.pd7tw1no...
> Hi,
> I am looking for an easy way to get all of the properties from a SQL 2000
> database much like the documenter does in MS Access. Any ideas?

How do I get db ddl properties from sql 2000 like documenter does in MS Access?

Hi,
I am looking for an easy way to get all of the properties from a SQL 2000
database much like the documenter does in MS Access. Any ideas?Not all of us use Access. Can you tell us what it is that you want?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message
news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> I am looking for an easy way to get all of the properties from a SQL 2000
> database much like the documenter does in MS Access. Any ideas?
>|||Perhaps you can use the INFORMATION_SCHEMA views. This should get you =started:
SELECT * FROM INFORMATION_SCHEMA.TABLES SELECT * FROM INFORMATION_SCHEMA.COLUMNS
More info on these views can be found within Books Online (within the =SQL Server program group).
-- Keith
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message =news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> > I am looking for an easy way to get all of the properties from a SQL =2000
> database much like the documenter does in MS Access. Any ideas?
> >|||Ok, I take back, swag sucks! I just ran the app and I must say this is a DBA
's dream come true! Especially for a person like me that is a coder by trade
and forced to maintain SQL db's due to the client's small budgets. The plain
and simple fact is, in the five minutes it took to run the application, it
paid for itself ten times over. I love it! I recommend it to everybody.
Get Yours...
http://ag-software.com/ags_scribe_index.aspx
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23zQ8CoCwDHA.2880@.tk2msftngp13.phx.gbl...
Perhaps you can use the INFORMATION_SCHEMA views. This should get you
started:
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
More info on these views can be found within Books Online (within the SQL
Server program group).
--
Keith
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message
news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> I am looking for an easy way to get all of the properties from a SQL 2000
> database much like the documenter does in MS Access. Any ideas?
>