[mso] Re: Access asking for password.
- From: "Jim Pettit" <jimpettit@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 09:50:14 -0700
Peter--
If it's SQL Server, my guess is you're connecting via an ODBC DSN (or via a
so-called DSN-less connection). If so, you'll need to speak with the DBA
(the administrator) of the particular SQL Server database to which you're
trying to connect to be sure you have a valid user login and password for
that database. You can save that login and password as part of the ODBC DSN,
and you'll not have to input it again. If you're using a DSN-less
connenction, you'll need to hard code the user name and password into the
connection string stored inside your VBA code.
Hope I didn't confuse you too much. ;-)
--Jim
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Peter A. Wilson
Sent: Monday, April 11, 2005 9:46 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access asking for password.
Sorry.....its a SQL server db.
=20
Peter Wilson, CCNA
Network Administration/Support
Heritage-Encon Inc
704-588-1366 (W)
704-451-0596 (C)=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Jim Pettit
Sent: Monday, April 11, 2005 12:34 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access asking for password.
Peter--
It depends; to which type of databases is your main Access application
trying to connect? If it's a SQL Server database, for instance, that backend
DB itself manages its own authentication schema. The same goes for Oracle,
for example. If the backend is another Access DB, that application might be
using other than the default Access login/password combo. Too, if your
trying to connect to, say, a flat database file residing on a network share,
the operating system may be asking you for access to the remote machine. So,
again: which type of database(s) is/are your main Access application trying
to connect to?
--Jim Pettit
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Peter A. Wilson
Sent: Monday, April 11, 2005 9:31 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access asking for password.
Hello....
I am running an access db application and I keep getting prompted to enter a
username and password when I try and access different applications that
this db is connected to. =3D20 Any clues as to why = this is happening.
Peter Wilson, CCNA
Network Administration/Support
Heritage-Encon Inc
704-588-1366 (W)
704-451-0596 (C)=3D20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Sunday, April 10, 2005 2:06 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access 2000: Unwanted closing of file, Access closes &
exits
-Copy-
The name of the input file should have nade impact.
-End-
I wholeheartedly agree. I have been writing science programs too long to
believe it did make an impact, but the fact it changed then sure was a
strange coincidence.
-Copy-
FWIW ... My next move would be to build another new form and include only
one field field to display. If that works.. delete it and build another form
to display 2 fieilds... and so on. Start simple ... get unsimpler.
Also, are you including the photos there or links to them?
-End-
No to both questions. I am including the photo NAME though. My photo names
are useful to *ME* and I can find the photo fast on a DVD-R or hard drive,
but most of us would probably balk at my naming scheme. If I take a picture
today, at 3:15:00pm, I am naming that photo:
200504101515000001.TIFF Translation:
YYYYMMDDHHMMSSnnnn.ext
As long as we have long name ability, that will work. I am using the data in
Access to make 4 by 5" labels I stick on the back of the photo giving
peoples' names, births, marriages, deaths, locations, etc.
Lisa, Jim, everyone, thank you for your responses. If I find out the cause
why the first file did not import but the second file did, I will post it.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Green
Sent: Saturday, April 09, 2005 6:10 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access 2000: Unwanted closing of file, Access closes &
exits
Robert,
FWIW ... My next move would be to build another new form and inlude only one
field field to display. If that works.. delete it and build another form to
display 2 fieilds... and so on. Start simple ... get unsimpler.
Also, are you including the photos thereor links to them?
Lisa
> Everyone-
>
> This is for recording the photographs of familial ancestral,=20
> familial=3D20 historical, genealogy, photographs of research papers=20
> librarians would
> not allow patrons to touch, family members whom I have yet to=3D20=20
> identify, and sadly many duplicates of originals but I have
> not=3D20=20 identified which are duplicates. That said, I have 27
> toilet =
sized=3D20
> boxes to go through so I am taking a guess here based on HALF of=20
> the=3D20 first box. Half of the first box yielded 64,815 and =
thankfully=20
> 2/3rds=3D20 were duplicates which Access found for me. I need to =
record
> them all=3D20 however to make sure I get all of them. Then I can =
archive
> the=3D20 duplicates or discard some of them. That said, I am using=20
> Access to=3D20 create ID labels with vital information on the image=20
> (names of people,
> births, marriages, deaths). That calls for a big label, but still=20
> I=3D20 have to condense some numbers to get everything to fit.
>
> After all this, I plan to use this to create a date file that contains
> no duplicates, and have a set of information that can be entered=20
> into=3D20 a genealogist database, hopefully reliable.
>
> Jim
> I do have a valid pre-build of the data. You asked how many records; I
> am
> *guessing* this: 64,815*2 for 129,630 per box average, times 27=20
> boxes=3D20 is 3,500,010!!! Plus I have to go over that for any more I
> =
> eventually
> come across. Yikes. I had not seen those numbers before; they are=3D20
> =
> huge! I thought about null values, and didn't find any. I will =
try=3D20
> the JetComp utility.
>
> Lisa-
> I can open the form in Design mode, and you are right; the =
triangle=3D20
> ruler and pencil is "Design." I can tab across all the fields. Is=3D20
> =
> there something I can do in this window to correct the closing of=20
> the=3D20 form?
> I didn't see
> anything.
>
> Thanks everyone. And yes, I will keep you posted; I do want to be able
> to use this if I can.
>
> Robert
>
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
[mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Green
Sent: Saturday, April 09, 2005 5:22 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access 2000: Unwanted closing of file, Access closes &
exits
Hi Robert,
Don't "Open" the form. Highlight it and then use the little icon with the
triangle ruler and pencil in. I can't tell you the name exactly 'cause this
is a Dutch version... sorry.. but I think it's "Design".
That should open the form in Design mode.
Lisa
> I made a table in Access 2000, and used the wizard to create a =
form=3D20
> with the intention of 'editing' the form.
>
> The form was made, but whenever I attempt to open it, it opens and=20
> as=3D20 soon as it opens all the way, it reverses, closes, and
> Access=20 exits
>
> Can I correct this? I can't use it if it won't stay up long enough for
> me to enter and edit data. <g>
>
> Thank you.
>
> Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
