Access News / Other Topic

{Too Long!}

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.

Hi 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]

I 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

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

I 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

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?

When 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.

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.

Hi, 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, .

Does anyone know how I can insert and retrieve serialized objects into/from a Microsoft Access Database using JDBC/ODBC?, , Thanks,, Christophe

Are 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.

I 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?

I 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?

Hi, 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

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

I 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.

I 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.

I 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.

I 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]

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 !

Not 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

I 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

SELECT,    AgeRange,    COUNT(AgeRange) AS Total,    FROM Table,    GROUP BY AgeRange,    ORDER BY AgeRange

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

Hi,, Is there a way to use a popup menu inside a listview? , Thanks