f



Linked tables in ms access asking for login/password

Hi,

I have an Access 2000 database, which contains some native tables,
and some linked tables which belong to an ORACLE database, through
ODBC.

Using VB.NET, I am trying to fetch some data by joining two tables,
one table native to the mdb file, and another belonging to ORACLE.

I am using a connection string to connect to mdb file:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
Jet OLEDB:Database Password=xxxx;Persist Security Info=True;

My problem is that as soon i try to fetch the data, a window (not belonging
to my vb program) comes up with the title "ORACLE ODBC driver connect"
asking for ORACLE's username and password. Its the same screen which 
i get when i open Access database, and try to view one of the oracle
tables for the first time.

I don't want this screen. Somehow :
- i want to store this info with access
OR
- pass this info through something like the connection string. 

User should not be able to see this screen.

I would appreciate any help.


anand saha
0
anandsaha (1)
6/21/2004 8:36:31 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

4 Replies
545 Views

Similar Articles

[PageSpeed] 41

Hi Anand,

Nice crossposted, however this newsgroup where this is often the question is
not in it.
If I was you I would try it especially there.

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsof
t.public.dotnet.framework.adonet>

I think you have more change there to get an answer that fits you.

Cor
"anand" <anandsaha@rediffmail.com> schreef in bericht
news:f7f6a451.0406210036.20f2c779@posting.google.com...
> Hi,
>
> I have an Access 2000 database, which contains some native tables,
> and some linked tables which belong to an ORACLE database, through
> ODBC.
>
> Using VB.NET, I am trying to fetch some data by joining two tables,
> one table native to the mdb file, and another belonging to ORACLE.
>
> I am using a connection string to connect to mdb file:
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
> Jet OLEDB:Database Password=xxxx;Persist Security Info=True;
>
> My problem is that as soon i try to fetch the data, a window (not
belonging
> to my vb program) comes up with the title "ORACLE ODBC driver connect"
> asking for ORACLE's username and password. Its the same screen which
> i get when i open Access database, and try to view one of the oracle
> tables for the first time.
>
> I don't want this screen. Somehow :
> - i want to store this info with access
> OR
> - pass this info through something like the connection string.
>
> User should not be able to see this screen.
>
> I would appreciate any help.
>
>
> anand saha


0
6/21/2004 8:42:48 AM
On 21 Jun 2004 01:36:31 -0700, anandsaha@rediffmail.com (anand) wrote:

� Hi,
� 
� I have an Access 2000 database, which contains some native tables,
� and some linked tables which belong to an ORACLE database, through
� ODBC.
� 
� Using VB.NET, I am trying to fetch some data by joining two tables,
� one table native to the mdb file, and another belonging to ORACLE.
� 
� I am using a connection string to connect to mdb file:
� Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
� Jet OLEDB:Database Password=xxxx;Persist Security Info=True;
� 
� My problem is that as soon i try to fetch the data, a window (not belonging
� to my vb program) comes up with the title "ORACLE ODBC driver connect"
� asking for ORACLE's username and password. Its the same screen which 
� i get when i open Access database, and try to view one of the oracle
� tables for the first time.
� 
� I don't want this screen. Somehow :
� - i want to store this info with access
� OR
� - pass this info through something like the connection string. 
� 
� User should not be able to see this screen.
� 
� I would appreciate any help.

When you create the linked table in Access there is an option to save the password so that you will
not be prompted when accessing the table.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
0
6/22/2004 2:51:50 PM
Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote in message news:<vjhgd0lkik4bi215vigpcaun83oi8ntqhh@4ax.com>...
> On 21 Jun 2004 01:36:31 -0700, anandsaha@rediffmail.com (anand) wrote:
> 
> � Hi,
> � 
> � I have an Access 2000 database, which contains some native tables,
> � and some linked tables which belong to an ORACLE database, through
> � ODBC.
> � 
> � Using VB.NET, I am trying to fetch some data by joining two tables,
> � one table native to the mdb file, and another belonging to ORACLE.
> � 
> � I am using a connection string to connect to mdb file:
> � Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
> � Jet OLEDB:Database Password=xxxx;Persist Security Info=True;
> � 
> � My problem is that as soon i try to fetch the data, a window (not belonging
> � to my vb program) comes up with the title "ORACLE ODBC driver connect"
> � asking for ORACLE's username and password. Its the same screen which 
> � i get when i open Access database, and try to view one of the oracle
> � tables for the first time.
> � 
> � I don't want this screen. Somehow :
> � - i want to store this info with access
> � OR
> � - pass this info through something like the connection string. 
> � 
> � User should not be able to see this screen.
> � 
> � I would appreciate any help.
> 
> When you create the linked table in Access there is an option to save the password so that you will
> not be prompted when accessing the table.
> 
> 
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Paul-

I'm having this same difficulty, and tried your suggestion by
re-linking the Oracle table so I could save the user ID and password. 
However, during re-linking I was never given the option to enter the
user ID and password.  Is this an option that has to be set-up in the
Oracle driver or database?

John
0
jbren (2)
6/22/2004 5:45:33 PM
On 22 Jun 2004 10:45:33 -0700, jbren@gene.com (John B) wrote:

� Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote in message news:<vjhgd0lkik4bi215vigpcaun83oi8ntqhh@4ax.com>...
� > On 21 Jun 2004 01:36:31 -0700, anandsaha@rediffmail.com (anand) wrote:
� > 
� > � Hi,
� > � 
� > � I have an Access 2000 database, which contains some native tables,
� > � and some linked tables which belong to an ORACLE database, through
� > � ODBC.
� > � 
� > � Using VB.NET, I am trying to fetch some data by joining two tables,
� > � one table native to the mdb file, and another belonging to ORACLE.
� > � 
� > � I am using a connection string to connect to mdb file:
� > � Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
� > � Jet OLEDB:Database Password=xxxx;Persist Security Info=True;
� > � 
� > � My problem is that as soon i try to fetch the data, a window (not belonging
� > � to my vb program) comes up with the title "ORACLE ODBC driver connect"
� > � asking for ORACLE's username and password. Its the same screen which 
� > � i get when i open Access database, and try to view one of the oracle
� > � tables for the first time.
� > � 
� > � I don't want this screen. Somehow :
� > � - i want to store this info with access
� > � OR
� > � - pass this info through something like the connection string. 
� > � 
� > � User should not be able to see this screen.
� > � 
� > � I would appreciate any help.
� > 
� > When you create the linked table in Access there is an option to save the password so that you will
� > not be prompted when accessing the table.
� > 
� > 
� > Paul ~~~ pclement@ameritech.net
� > Microsoft MVP (Visual Basic)
� 
� Paul-
� 
� I'm having this same difficulty, and tried your suggestion by
� re-linking the Oracle table so I could save the user ID and password. 
� However, during re-linking I was never given the option to enter the
� user ID and password.  Is this an option that has to be set-up in the
� Oracle driver or database?
� 
� John

I don't believe that the Linked Table Manager supports this capability if that is what you are
using. AFAIK, you have to delete the existing linked table and use the File...Get External
Tables...Link Tables... method.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
0
6/22/2004 6:54:15 PM
Reply:

Similar Artilces:

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but I don't know what software is >needed. Do you know? If so, please answer this post. Thanks. I think it comes down to semantics. "Licensed" vs "Loaded". No you can't create an app that will run on a PC with nothing loaded. Yes you can create an app that will run on a PC where nobody's paid the fee to run MS Access. You still have to install something on that PC, however. What it is is a freebie version of MS Access that only runs applications - doesn't allow anybody to develop an app. You develop the app on your PC, which has MS Access installed. Then somebody installs the freebie ("Runtime Access") on somebody's PC and they can run the app you developed without having to pay any money to anybody. -- PeteCresswell Sue, If Access isn't present, some version of it must be installed to run an Access database. VB.NET, ...

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

Accessing a passworded MS Access 2000 database in Crystal Reports
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

Accessing a passworded MS Access 2000 database in Crystal Reports #2
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS Access 2000 interface. Would it be possible? If I migrate the MS Access to SQL Server, would the queries, back-end VBA, macro, tables and forms be affected? Do I need to change the MS Access data type to SQL server supported data type? Which tool I can use to do the migration? Upsizing wizard or exporting...

MS Access and Sharepoint: saving the username and password in a linked table
I have some linked tables that connect to a Sharepoint site, but every time they are reconnected they prompt the user for a username/password. I would like to embed the login into the application, just as you can for any other type of linked table, but I can't find a way to do this. Do anyone have any idea how to fix this? Also, this is new to me, so anyone has any experience of how well Access and Sharepoint perform together, I'd love to know. Thanks, James "James Beswick" <jamesbeswick@gmail.com> wrote in news:1139768590.875155.122430@o13g2000cwo.googlegroups.com: > I have some linked tables that connect to a Sharepoint site, but > every time they are reconnected they prompt the user for a > username/password. > > I would like to embed the login into the application, just as you > can for any other type of linked table, but I can't find a way to > do this. > > Do anyone have any idea how to fix this? Also, this is new to me, > so anyone has any experience of how well Access and Sharepoint > perform together, I'd love to know. This is the first time I've ever noticed anyone post to this newsgroup a SharePoint question. I have no clients who use it, nor any who plan to use it. What is it good for, beyond lining Microsoft's pockets with cash? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ It's a convenient way of s...

Accessing Oracle Tables from MS Access
How difficult is this? I'm having a tough time getting a simple select to work. I am using MS Access 2002 and Windows XP. What do I have to do to make a simple select statement like this work: select id from emp I have stumbled upon many websites although none straight to the point. Any help in how to get this done, or pointing me in the right direction of a book or website, would be greatly appreciated! berj Yes, I do have the table links working. But I did want to run the select for such things as grabbing the next number off of a sequence. As in: select test.nextval from dual; Where "test" is the name of an Oracle sequence. berj "Steve Jorgensen" <nospam@nospam.nospam> wrote in message news:bp0821lsd8tt5ec5jhvtgbt46fdvb2t3dt@4ax.com... > The easiest way is to link the table in Access, then query the link. Is that > how you're trying to do it? > > On Mon, 28 Feb 2005 21:25:36 -0800, "berj" <berj@adelphia.net> wrote: > > >How difficult is this? I'm having a tough time getting a simple select to > >work. > > > >I am using MS Access 2002 and Windows XP. > > > > > >What do I have to do to make a simple select statement like this work: > > > >select id from emp > > > > > >I have stumbled upon many websites although none straight to the point. > > > > > >Any help in how to get this done, or pointing ...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

MS Access asking for password
A user is complaining that Access Dbs on her PC asks her to type in a username and password whenever she opens an Access Db. The username that appears in the username box is the same as her network username. No password actually works to open any DB. I've also logged in to that pc using the Admin account and get the same problem. She does not not have this problem (i.e. opening the same Db) on another pc. The Db in question is NOT secured and has not had a password applied to it. Anyone have any ideas what's happening here? TIA "Mo" <m.a.joomun@nospam.qmul.ac.uk> wrote: > The Db in question is NOT secured and has not had a password applied to > it. > > Anyone have any ideas what's happening here? Yes, someone has either: 1 - used the Workgroup Admin utility to change the default Workgroup Information File (WIF) to something other than "System.mdw" or 2 - modified "System.mdw" from another Access app. You need to find out which: Open the Workgroup Admin utility to see if the default workgroup is (for NT) C:\WINNT\System32\System.mdw. If it isn't, browse to this file and select it. If it is then you need a 'clean' copy of System.mdw. You may well be able to just copy a clean one from another PC, but I'd advise to make sure it's one from an identical MS Office image. HTH - Keith. www.keithwilby.org.uk Thanks very much for the suggestion Keith The System.mdw was there. I repla...

Date picker from MS-Access 2000 to MS-Access 2003
Hello. How do I get a date picker (References: Microsoft Calendar Control 8.0 Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in MS-Access 2003. TIA J�rn Why not scrap it and use the all-API approach Stephen Lebans has at http://www.lebans.com/monthcalendar.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message news:42190d18$0$48635$edfadb0f@dread15.news.tele.dk... > Hello. > > > > How do I get a date picker (References: Microsoft Calendar Control 8.0 > Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work > in > MS-Access 2003. > > > > TIA > > J�rn > > Allen Browne has an excellent calendar control at http://allenbrowne.com/tips.html -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com "JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message news:42190d18$0$48635$edfadb0f@dread15.news.tele.dk... > Hello. > > > > How do I get a date picker (References: Microsoft Calendar Control 8.0 > Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in > MS-Access 2003. > > > > TIA > > J�rn > > Thanks for the link...

MS Access VBA making multiple tables in database from a main table.
I have a database table called "tbl_personal" and struggling to VBA program a bit of code to create multiple tables in a database from the main "tbl_personal" table. In this case the 'color' column is the field I would like to look at. 1. Identify the number of unique records in column 'color' 2. For each color record that is label as red in the "tbl_personal" table, create a table called 'red' and populate with all red records in from the "tbl_personal" table. 3.Then move onto the next unique color and repeat the whole process again. 4. When all unique color tables are created in MS Access database end with a msg "batch process done" name surname age color country aa aaa 1 red UK bb bbb 10 green USA cc ccc 20 blue China dd ddd 30 red Germany ee eee 40 green France ff fff 1 blue Italy gg ggg 20 red Spain hh hhh 40 yellow Canada ii iii 34 black Italy =85 Is this doable automatically in MS Access? Many thanks. brenda Are you sure you want to do this? I would expect 3 tables vis: Table of Personel with PersonelID, Suname, FirstName, ColourID, CountryID & DateOfBirth (Age will be out of date next birthday and should be calculated), Table of Colours ColourID & Colour Table of Countries CountryID & Country. You can then use simple queries to return all the red people or people who live in UK. Am I missing something? Phil <bbcdancer@hotmail.com> wrote in message news:495c4ca6...

Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check here to see if there is a better way. Any suggestions? Thanks Do you mean remotely controlling an Access database, or linking tables over the internet? The first is doable, the second is a recipe for disaster. Remote Control: If your remote OS is Windows XP, you can use Remote Desktop (although only 1 person can access the PC at a time; this will change in the upcoming Service Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers similar services, as does Terminal Server (a component of a Windows Server machine), PCAnywhere, et al. Linking to remote tables: You will almost certainly encounter severe problems with corruption, and your performance will almost certainly be so poor as to be unworkable. I attempted this once, with a web server in Canada and my machine in Augusta, GA. Even tiny data requests on a very well optimized data structure took waaaay too long to process ... it's simply not workable, IMO. Other alternatives would be covert the app to a web-based and place your data on a web server. Access/Jet isn't really designed for those workloads, but running a small site with minimal transactions and users can be done. Otherwsie, consider switching to a more robust data platform like MySQL, SQL Server, etc. -- Scott McDaniel CS Computer Software Visual Bas...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Singularity.co.uk> wrote in message news:1118749208.204709.287950@g49g2000cwa.googlegroups.com... > Hi > > The technical support guys at my company have set up my system so that > the server containing the MS Access database is on one server, while > the pages that should access the database are on another server. > > When the pages and database are on the same server, I usually just > connect through ODBC. > > The problem is that I don't know how to set up an ODBC connection to > link from one server to a database in another. > > Anyone know what I am getting at and know of a possible solution, or a > link to a site which may help. > I think this may be more of a network issue than an Access one. Can you see both servers from your PC? Is there any particular reason why they've been put on different servers? Seems a little odd to...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Running a ms access database with access 2003 in Vista
I have a Database that I am trying to run on a new vista computer. Up to now I was running it on a win 98 computer and using access 2003! I installed access 2003 and I can make it run and view the data but I can not save any new records. Has any one seen this problem yet? Thanks Clarence Wollman On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <clarencewollman@gmail.com> wrote: Do you have the same problem with the Northwind sample application? (search your computer for northwind.mdb) -Tom. >I have a Database that I am trying to run on a new vista computer. Up >to now I was running it on a win 98 computer and using access 2003! I >installed access 2003 and I can make it run and view the data but I >can not save any new records. >Has any one seen this problem yet? > >Thanks Clarence Wollman On Aug 22, 7:29 pm, Tom van Stiphout <no.spam.tom7...@cox.net> wrote: > On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <clarencewoll...@gmail.com> > wrote: > > Do you have the same problem with the Northwind sample application? > (search your computer for northwind.mdb) I don't have a problem opening and editing the northwind.mdb. Thanks Hi I found a workaround. This database has a fronted and a backed. When I link them in the linked table manager, I was going threw the network to my computer. The reason I am doing this is when any networked computer opens the shortcut to the front end of this computer the linked table manger knows...

How to access MS-Access metadata tables (eg MSysObjects)
Dear all, I have an MS-Access MDB-file with hundreds of tables and want to know when they were created and/or modified. The MS-Access metadata table MSySObjects includes this information, but I have not managed to read it from SAS. (CLI describe error tells me that I have no reading access) --> Does anybody have a working code example for this? I have tried the libname ACCESS and Libname ODBC variants. Regards Dietrich -- DIETRICH ALTE, Dipl.-Statistiker, Dr. rer. med. Wiss. Projektmanager "Study of Health in Pomerania (SHIP)" Institut f�r Community Medicine - SHIP/KEF EMA-Universit�t Greifswald - Medizinische Fakult�t Walther-Rathenau-Str. 48, D-17475 Greifswald, Germany URL ship.community-medicine.de Phone ++49(0)3834-867713, Fax ++49(0)3834-866684 ...

ask me a question ms access databases
I will be willing to help, with access databases, in same order request is received. The web site is at www.jaxdatasolutions.com. This is for a limited time only. ivanmendoza@comcast.net (Ivan) wrote: >I will be willing to help, with access databases, in same order >request is received. The web site is at <snipped> This >is for a limited time only. Umm, hows about we ask questions in this newsgroup? Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm "Tony Toews" wrote > > I will be willing to help, with access > > databases, in same order request is > > received. The web site is at <snipped> > > This is for a limited time only. > > Umm, hows about we ask questions > in this newsgroup? Would one of the first ones be "Why ask questions just of a particular, unknown person of unknown ability instead of asking them publicly where they will be seen by many persons of proven ability?" <G> "Ivan" <ivanmendoza@comcast.net> wrote in message news:2be4a61d.0408010952.5f1d1438@posting.google.com... > I will be willing to help, with access databases, in same order > request is received. The web site is at www.jaxdatasolutions.com. This > is for a limited time only. Good idea. ...

MS Access linked tables MYSQL
Hi Folks, im using MS Access as a front end to link to MYSQL. although this is possibly a MYSQL issue i thought someone would be able to help me. the error message "ODBC--insert on a linked table 'tablname' failed" is displayed when i attempt to insert records to the MYSQL table. Does anyone know of a way round this ?? im using the most recent MYSQL driver and i have only text fields in my insert statement. Is there an Access setting or permission that i must change thanks in advance CG <csgraham74@gmail.com> wrote in message news:1147726709.116174.41660@v46g2000cwv.googlegroups.com... > Hi Folks, > > im using MS Access as a front end to link to MYSQL. although this is > possibly a MYSQL issue i thought someone would be able to help me. the > error message "ODBC--insert on a linked table 'tablname' failed" is > displayed when i attempt to insert records to the MYSQL table. > > Does anyone know of a way round this ?? im using the most recent MYSQL > driver and i have only text fields in my insert statement. Is there an > Access setting or permission that i must change Some server DBs require that you have a Primary Key defined on each Table that you update -- I don't know if that is the case with MySQL. That should be a quick thing to check. Larry Linson Microsoft Access MVP You may be using a constraint in one of your fields (maybe a relationship between two tables). When you are i...

MS Access Linked table problem
Hi. I've got a strange problem with linked tables in MS Access. The linked tables are on SQL Server 2000, and the Access version is 2003. When any of the the column names contain a space, I get an "incorrect syntax" error. When the column names do not contain a space, the table opens OK. So I assume it's some problem with the ODBC connector. However, the ODBC version is the same as on another PC that can open the linked tables (same database) without any problems. Any ideas? Try wrapping your field names in square brackets. i.e. tablename! [field name]. -tc On Mar 4, 4:51=A0am, benb <Ben.Baw...@gmail.com> wrote: > Hi. I've got a strange problem with linked tables in MS Access. > > The linked tables are on SQL Server 2000, and the Access version is > 2003. > > When any of the the column names contain a space, I get an "incorrect > syntax" error. When the column names do not contain a space, the table > opens OK. So I assume it's some problem with the ODBC connector. > However, the ODBC version is the same as on another PC that can open > the linked tables (same database) without any problems. > > Any ideas? ...

Blocking MS Access linked tables...
Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group that all Access users are a member of. I added that group to SQL Server logins and gave it public, datareader, and datawriter rights to the one database that's used. My front end is locked down, but I want to stop users from creating a new ..mdb and linking SQL Server tables through DSNs or ADO connections or even just importing the links from the actual front end.. I've tried setting the "denydatareader" security policy - that k...

Use ASP to read MS Access query that calls MS Access function
Hi: I have an MS Access query for a table called MyTable. One of my fields in the query is a custom field that looks like "MyField: = MyFunction(ID)" where ID is a field in MyTable. I have ASP code and I can use it to read the query OK when "MyField" is not part of the query. If I add in MyField and then run my ASP code to try to read all the query fields, I get an error message on my web browser which says something to the effect of "cannot find MyFunction." On the Access side, I have MyFunction set up in a module and use the keyword "Public" in front of the function name. What else do I need to do to get my ASP code to run this query. I'm trying to avoid reproducing MyFunction within the ASP code if possible. Thanks. Kevin On Thu, 14 Jun 2007 21:38:19 -0000, k-man <kmccrack@gmail.com> wrote: Sorry, no can do. From ASP you don't have access to the Access VBA interpreter. -Tom. >Hi: > >I have an MS Access query for a table called MyTable. One of my >fields in the query is a custom field that looks like "MyField: = >MyFunction(ID)" where ID is a field in MyTable. > >I have ASP code and I can use it to read the query OK when "MyField" >is not part of the query. If I add in MyField and then run my ASP >code to try to read all the query fields, I get an error message on my >web browser which says something to the effect of "cannot find >MyFunction."...

Re: How to access automatically in SAS a MS Access table name
i am not sure if SAS will support long file name if you use libname. a workaround is to use passthrough. On Jan 16, 2008 12:31 PM, JKamgang@Yahoo.com <JBKamgang@gmail.com> wrote: > Dear All, > > > > Happy New Year , > > > > Please, I need your help in figuring out how to access in SAS a MS > Access > table name which has more than 32 characters. As this program merges 5 > databases, I need to have almost everything automated. That's why I > don't want to rename manually the table names. > > > > Please find the program below. > > > > Thanks in advance for your kind assistance, > > > > Jean Baptiste > > > > The program: > > - - - > > > > options VALIDVARNAME=ANY ; > > libname DBsource access 'S:\Data > Management\External\Projects\MTCT-Plus\MTCT-Plus November 2007 > Data\Programs\Data\MTCT-PlusData All.mdb'; > > /* Creating the Pediatric HIV result information additional */ > > > > data* pedResultadd ; > > set dbsource.'tblInfantHIVTestResultsAdditional'n (keep = > > testid studyid labid i2 i2_da i2_mo i2_yr i2a i2b i2text > > ); > * > > run*; > > - - - The log - - > > 1636 > > 1637 /* Creating the Pediatric HIV result information additional */ > > 1638 > > 1639 data pedResultadd ; > > 1640 set dbsource.'tblInfantHIVTestResultsAdditional...

Web resources about - Linked tables in ms access asking for login/password - comp.databases.ms-access

One-time password - Wikipedia, the free encyclopedia
A one-time password (OTP) is a password that is valid for only one login session or transaction. OTPs avoid a number of shortcomings that are ...

Oregon To Consider Bill Blocking Employers From Demanding Applicants’ Facebook Passwords
The Oregon House of Representatives will hear a bill Friday that would prevent employers from demanding that job applicants reveal their passwords ...

Keeping Passwords Secure
The Facebook Security team has always kept a close eye on data breach announcements from other organizations. Theft of personal data like email ...

New Facebook Security Features: One-Time Passwords, Security Info
Facebook has launched two new security features to help users stay in control of their accounts. Users can now receive a one-time password from ...

The FBI Claims Failure To Guess Password Will Make Data ‘Permanently Inaccessible,’ Which Isn’t True
It's literally unbelievable that the FBI doesn't have access to the tools to perform this or the expertise to get it done.

Sharing passwords is a bad idea, yet people still do it
A lot of people like sharing their passwords with others, even though such actions put their data at risk and they know it. Those are the results ...

Behavioral biometrics and the future of the password
At the 2016 RSA Conference in San Francisco, CSO chats with SecureAuth about their behavioral biometrics technology, which allows or prevents ...

Terrorist changed iCloud password, disabled auto-backups on his iPhone
The government last week revealed new details about the iPhone that is at the center of an increasingly bitter dispute between federal authorities ...

It’s time to wrangle your unruly password situation
We’ve all got a system for keeping track of the dozens of online passwords we need these days. While some are more effective than others, none ...

Selfies Could Be Passwords on Amazon
The online retail giant has applied for a patent to allow shoppers to use a photograph for authentication.

Resources last updated: 3/21/2016 4:18:39 PM