Thread 25 of 25 | Thread Starter | | |  Rainier | Schedule database{Too Long!} |
 2669 Hits | |
Thread 24 of 25 | Thread Starter | | |  jman009 | I need Security!!! *info required*Hi, I'm doing a Uni report on the security features of Access., basically info on:, -related issues such as system and data access security, -user login facilities of access as well as machines etc, -performance considerations (info on access on a network), -Optimal number of users accessing files at one time if centralised etc, If you could help me out with this I'd be very grateful. |
 3983 Hits | |
Thread 23 of 25 | Thread Starter | | |  Rhowk | excel updates access dbHi sorry if this question is insanely stupid, but I have a client who wants to use his excel spreadsheet to enter data for use on the web. I have linked the spreadsheet to an access DB and have linked the DB to a Flash front end( via ASP) so certain clients of his can get the data they need on the web. , , What I don't know how to do is write a macro or App that takes his data in excel and updates the DB on the webserver every morning at 9am. Should I have the DB in his office computer and have asp look on his office computer for the data, or should I just have the DB on the webserver (not in his office) and have excel update it remotely. Again forgive me if this is completely obvious, I'v e been teaching myself ASP and Access on the fly for this project and am a little over my head as usual, , Rh, [EMAIL]vaene@yahoo.com[/EMAIL] |
 2094 Hits | |
Thread 22 of 25 | Thread Starter | | |  Jocat | Synchronizing w/o networkI have a situation where we have a remote office and we want the staff to be able to enter complaints (and their subsequent resolution)into a database. Note that this office is not connected to our lan. We want to be able to view the information on that database at the home office. , , I am thinking of placing a replica of the remote office database on the home office lan and update it periodically. Because there is no network link to the remote office, what is the best way to update the home office lan database replica?, , We are using Access 97., , Any help or suggestions would be greatly appreciated., , Joe 1 Reply: |  jdschram | best way? create an app using ASP...as far using just access...i would say create an FTP site where you post/DL/update the database |
|
 2451 Hits | |
Thread 21 of 25 | Thread Starter | | |  BD | any advice?!i'm trying to get a form in access upon update - to have to have data entry into certain fields., , I'm aware I can specify this has to be entered in the table itslef - but I'm wanting this condition only on the form..., , Any advice/help on how I can do this?, , If so please reply here or e-m me on:, , be_insane@yahoo.com, , cheers |
 2297 Hits | |
Thread 20 of 25 | Thread Starter | | |  Neil Webre | Moving tables from back-end to localI split an Access db using Tools ... Database Utilities ... Database Splitter. The process moved all my tables to a ..._be.mdb back-end database. But I wanted two of the tables to remain local. The process gave me no choice on which tables were to be moved - all went. , , Is there a quick and/or easy way to move the two back-end tables back to local, with all queries, forms, etc. adjusting to the move automatically? , , Neil Webre 1 Reply: |  dynamictiger | Use the import tool to reimport the tables back again., , Then use the linking wizard to update the links., , HTH |
|
 2258 Hits | |
Thread 19 of 25 | Thread Starter | | |  Rick Carter | Future of Access?I've heard that Microsoft eventually plans to move away from both the Jet engine and ADO. What are the plans for the future? It seems like the emphasis from both Microsoft and Borland is on building new ways to access SQL databases, but what about local tables? Will there always be some kind of support for local tables, and will Access always be part of the office suite? 1 Reply: |  jdschram | from what I have heard, MS is abondoning Access, but will replace it with a desktop version of SQL Server, so you will still have the ability to create local tables. |
|
 1721 Hits | |
Thread 18 of 25 | Thread Starter | | |  ErnNJ33 | Exporting a table to ExcelWhen I export a table to Excel I get an apostrophe in all of the cells. I assume this is a transition key but when I go into options/transitions the transition navigation keys box is not checked. How can I stop this? Thanks in advance for any assistance. |
 2141 Hits | |
Thread 17 of 25 | Thread Starter | | |  jdflux | Microsoft Jet 4.0 SP6 fix?Hello everybody., I'm accessing an Access 2000 database via ODBC from a Java developed system., The problem I have is that after a few hundred operations on the database I get "Cannot open more tables" or "Object invalid or no longer set" error messages reported from my ODBC driver., I have checked the Knowledge Base from Microsoft and they say that SP6 for Jet 4.0 corrects this problem (see Q239114 and Q304536). But after installing it, I still get it., , Has this happened to anyone?, Does anyone know how I can solve the problem?, , Thanks in advance,, Jorge.  |
 1813 Hits | |
Thread 16 of 25 | Thread Starter | | |  jan71942 | New member needs helpHi, My organization is trying to locate a copy of the MS , Office 97 Developer Edition Update. We are currently users , of Office 97 and are not ready to undertake the upgrading , of all of our users to Office 2000 or Office XP. We are , trying to do some Indirect replication and synchronization , using Access but this requires the Replication Manager , which is included in the MS Office 97 Developers Edition., , We have searched all over the internet (surplus vendors, , liquidators, etc) trying to purchase this product and no , one seems to have it., , Please help, . 1 Reply: |  mprestwood | Try eBay. I've had great luck finding pretty much anything. I checked and there's one there now going for about $50. |
|
 1695 Hits | |
Thread 15 of 25 | Thread Starter | | |  Christophe De Clercq | Help needed (JDBC)Does anyone know how I can insert and retrieve serialized objects into/from a Microsoft Access Database using JDBC/ODBC?, , Thanks,, Christophe |
 1852 Hits | |
Thread 14 of 25 | Thread Starter | | |  Lucy | Access Samples BookAre there any books that have examples of databases aside from northwind? I need one for tracking time work sheets. Please advise at your earliest convenience. Thank you.  1 Reply: |  Occie | Hi,, , If you want to see some sample databases, go here [URL=http://officeupdate.microsoft.com/templategallery/default.asp]http://officeupdate.microsoft.com/templategallery/default.asp[/URL] |
|
 2063 Hits | |
Thread 13 of 25 | Thread Starter | | |  deleted_member | 2 detail sectionsI work for a government insurance program. I need to produce a report that repeats a series of information on one page. The first section has a leader paragraph and shows information for each insured member. The second detail section repeats the name of the insured and reports on a different set of information for each member. When I produce the report and duplicate the name with the other information, the report shows the information for both sections for each individual. This makes the report confusing and way too long. Is there a way to have two detail sections on one report? 1 Reply: |  juanperro | I think in access you can't create multiple details sections like you do, for example, in crystal reports. What I think you can do is create another report with the information you want to show and then add it to the original one as a subreport. sounds good? |
|
 2090 Hits | |
Thread 12 of 25 | Thread Starter | | |  Skyusa11 | Conversion from 97 to 2000I am trying to convert an Access database from Access 97 to Access 2000 using the standard Access database conversion tool. I have followed the instructions I have gotten from Microsoft as well as from other websites including ensuring I am using not only a different new database name but putting it into a new folder., , The conversion utility compiles, converts and then signals 'Ready'. Upon looking for the newly converted database, however, it is nowhere to be found. A 'find' in Windows Explorer shows no new files created. So I have a utility running with no visible errors, but no resulting database., , Any ideas before the phones really start to ring? 1 Reply: |  dynamictiger | Try creating a new database in 2000. Save the new database to a known file. Close it and find it, reopen it., , Import the old access 97 file using the import tool. This will force conversion., , Save it, findit, open it., , Now run VBA compile., , HTH |
|
 2134 Hits | |
Thread 11 of 25 | Thread Starter | | |  clowe | Access 2000 Developer's EditionHi, I am just starting out on a small project for a local non-profit organization. I know some Paradox and a little Oracle, but Access seems to me to make sense for our purposes, can't be too hard to learn, right? Anyway, I am familiar with Access 2000 but I cannot find where to buy the Developer's Edition. Also, the local software stores (CompUSA, OfficeMax, etc.) only have Access 2002 (XP) and have told me they are unable to order 2000. I am loath to try software that has just been released, but will I get support (other than sites like this one) for 2000? Last question, what kind of help am I likely to get on this forum?, Thanks 1 Reply: |  dynamictiger | Try ebay for Access 2000 Developer, I don't think you will find it at retail level now., , Microsoft still supports Access 2000. However, you will find they are very expensive for any assistance. You will end up using forums like this one., , Forums are really here to help you when the answer is either not in the help system or the answer in the onboard help system is so vague you can't get it., , Good luck on the changeover., , HTH |
|
 1905 Hits | |
Thread 10 of 25 | Thread Starter | | |  Neil Webre | Upgrade Office XP Pro to XP Developers Ed.I have an Access project that is going multi-user. I need Office XP Developer's Ed. to provide licensing for the distributed workstations. Anyone know if it is possible for Office XP Pro owners to upgrade to XP Developer's Ed. without having to buy an entire new copy of Office?, , N. Webre 1 Reply: |  dynamictiger | You would simply buy the developer upgrade. I have just bought XP on ebay, so it is available if you look long enough., , HTH |
|
 2008 Hits | |
Thread 9 of 25 | Thread Starter | | |  MikeS | :confused How do I write parameter query form fieI am using Access 2000 for a small manufactuing plant's customer, product, vendor, and order information databases. I am performing a parameter query to extract information from three related tables and combining the information on the form which has calculated fields. I would like to write this information to a table to save it for future costing reference. Is there a clean way to do this? Can it be done through code. I have very little VBA experience. 1 Reply: |  dynamictiger | Mike, Access is a relational database. This means it should be normalised. Normalised is a specific term that refers to a number of rules on how the data is structured, and how it is stored., , Under the rules of normalisation you never store the results of a calculation. Rather you would calculate the result for analysis whenever you need it., , HTH |
|
 2211 Hits | |
Thread 8 of 25 | Thread Starter | | |  Jeff Estes | PicturesI am creating a database for a service company that has 10 years worth of invoices to be put into the database. We decided to scan them all in, making the file name of the bmp as the invoice number. This invoice number is tied to the location that had the work done. What is the best way to put multiple pictures for a location. Or is there a better way to tackle this project? Any help is appreciated. 1 Reply: |  Dan | If the invoice number is not necessarly unique number between the different locations I think the best approach would be to store the invoices in unique folders for each location. |
|
 1789 Hits | |
Thread 7 of 25 | Thread Starter | | |  GRAHAM | LINKING TABLESI have created a link to a table in an external data base,the problem I have is I need to update this data base table without updating the table in the external data base? However, whenever the source table is updated I need to have this information.So in other words,I need the source table to update the link table but the link table cant update the source table? Can this be done? Any suggestions welcome. Thankyou. 1 Reply: |  saleem | Make Copy of table in ur database. Write small utility on db opening that update records in the copy of table from external source. This will update ur table from linked database. whatever u want to add add directly to created copy of table |
|
 2445 Hits | |
Thread 6 of 25 | Thread Starter | | |  mmollett | AccessI have created a combo box from a table which, has a field called last name and a field called first names., In the combo box each filed is listed as a separate columm, but when I go to the form and click on the box only the last name appears, how do I get both fields to be reflected on the form. Do I need to run a query?  [EMAIL]michele.mollett@everestre.com[/EMAIL] 1 Reply: |  Dan | Check the Column width property of the drop down list. You should see something like 1";1" and in the column count you should see a 2 |
|
 1886 Hits | |
Thread 5 of 25 | Thread Starter | | |  Tulip123 | Access97 security wizard I have a problem with Access97 security wizard: when I start it I get a message saying that I am currently connected as the network manager and if I will continue than the data base and all its objects will become unsecured., , What does this message mean ? Is it a problem or should I continue ?, , Thanks ! |
 1645 Hits | |
Thread 4 of 25 | Thread Starter | | |  Patricia R. Turner | access vrs paradoxNot sure where to put this, but I am interested in whether the general groups feels there is more of a market out there for paradox apps or access apps. Keeping this short i won't go into my background, but I am thinking of making a career change, currently i am not in a development enviroment but am thinking of getting back into it. I have developed apps in both Paradox (my first development platform, and my first love) and Access. I am thinking of getting back into the field developing stand alone apps and I guess I need to pick one or the other to use, and i am wondering which would be the better choice as far as more marketable? , , I hope this post makes sense as I need to make a decision on wheter to purchase the Paradox Development edition or the Office Developer tools., , I would appreciate the groups comments, either on here or via email. Thanks |
 4190 Hits | |
Thread 3 of 25 | Thread Starter | | |  dhborchardt | query questionI have a column in a table that has age ranges, i.e. 18 to 30, 31 to 39, 40 to 49 etc. How do I separate the ranges and total them up? Can this be done in one query. For example, the result would come out: , 248 , 126 , 150 , , *248 18 to 30, 126 31 to 39 1 Reply: |  wpantoja | Use the GROUP BY clause and the COUNT aggragate function to determine the total number of records within each age range., , SELECT, AgeRange, COUNT(AgeRange) AS Total, FROM Table, GROUP BY AgeRange, ORDER BY AgeRange |
|
 1728 Hits | |
Thread 2 of 25 | Thread Starter | | |  BD | HELP Please .....Please would somebody offer some kind of help and assitance..., , I am supposed to be developing some way of creating a CD refenece system., , Essentially it is a number of rack that will contain a number of rows and a number of columns.... due to wanting to expand the system these will need to be defined..., , a number of operations are therefore needed:, , looking to see how many rows are used in a column - therefore how many are free and which positions are free..., , the need is to then be able to "add" a new cd to a particalur slot., , the mention is by using 2lookup" tables... but to be honest I am stuck and in need of help and guideance.., , If anyone can provide an idea of how to deveop this I would be gratful.., , Regards, , BD  |
 1644 Hits | |
Thread 1 of 25 | Thread Starter | | |  BrUuu | listview &popup menuHi,, Is there a way to use a popup menu inside a listview?  , Thanks |
 1650 Hits | |
 |
|