Exporting MS Access data to Oracle
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....
5 pts.
MS Access Date Time
I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time
I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time
Microsoft Office & AS/400 Database
I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.
I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.
IIF clause
Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 ...
Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 ...
How to read/write Access 2003 mdb records on server via INTERNET connection
It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally....
It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally....
MS Access - Count of parent table items in a report
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on...
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on...
Access 2007 refrence look up
Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...
Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...
MS Access Question
ok im working with office 07, Access. I have multiple checkboxes for one question. I need to create some kind of auto warning system if the user checks more then one box for the same question. I cannot change design because it needs to mimic a current form. As well as needs to have the ability to...
ok im working with office 07, Access. I have multiple checkboxes for one question. I need to create some kind of auto warning system if the user checks more then one box for the same question. I cannot change design because it needs to mimic a current form. As well as needs to have the ability to...
SQL 2000 to Yukon Migration
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one...
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one...
Controlling VPN access
Here's my scenario. I fall under guidelines of HIPPA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...
Here's my scenario. I fall under guidelines of HIPPA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...
What is NAT port forwarding?
Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.
Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.
Dynamic updates to a DNS Server
What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?
What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?
Managing SQL 2000 server over the internet
I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.
I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.
Count Distinct Rows on Multiple Columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
Accessing Mail Server
I have remote users who are not allowed on the domain... At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get...
I have remote users who are not allowed on the domain... At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get...
MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...
dynamic visual basic form based on access database table
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100...
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100...
