Congrats To Rural Guy - 2000 Posts
Jan 3, 2006Congratulations on your 2000th post since July 2005.
That is indeed impressive.
Best wishes,
Bob
ADVERTISEMENT
92, 000 Posts??? But I Am Only New
Sep 15, 2005Can anyone tell me why I have 92,000 posts when I have only just joind today?
I am fast but not that fast.....
Old Posts
Jun 5, 2005I'm really afraid to ask this question. I was working on a database for our LawFirm about a year ago but it was a longterm project and low priority. For reasons beyond my control I got away from it and am just getting to back to it. Miles and many of you were very helpful to me in answering my questions. I can't remember the user name I chose and my dob is not listed so I can't find it that way. I have searched what I thought was the user name and every combination thereof. I'm wondering if I got deleted after so long for inactivity? I certainly don't to waste people's time by asking the same questions a second time. Anyone have any ideas how I can find my old posts?
View 2 Replies View RelatedDuplicate Posts
Jul 11, 2005i have a table with 3 fields: ID, line_item, and pay_app.
line_item and pay_app are linked to other tables in a one-to-many.
For every pay_app, there can be up to 100 line_items. However, I only want each line item to appear once (at most) in each pay_app. I want to prevent the same line item from showing up multiple times in the same pay_app. Essentially, I want to prevent duplicate entries, but with a stipulation, if that makes sense.
How Do I Find My Posts?
Sep 27, 2005I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?
Thanks in advance to whoever replies :D
Finding My Posts
Sep 4, 2006Is there a way to find all my old posts except looking at all 381 pages?
View 4 Replies View RelatedAdding Links To Posts
Feb 28, 2008Sorry, cant find this in help, and cant do it by trial and error
How do I add a link to a post/thread in a reply
Security Question..after Reading Many Posts..
Jun 16, 2005I didnt find answer to my question!..
Hope someone here can help..
I just added security to my access application...
I have added a new user and gave all admin rights. Removed all permissions from Admin and Admins group. When I log on as this new user who is equivalent of Admin,
I am able to doubleclick the table(linked table) and modify/delete the data..but when I the form is executing, it says, "Records cannot be read, no read permission on <Table>"
Hope someone can answer my question.
Thanks very much.
Limited Posts In Access DB Forum
May 2, 2007Hi there!
I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-).
The reason for this is that the db want accept more posts unless I do so.
My question is how do I "extend" the db to accept more posts?
Thx in advance,
Sarre
General :: Not Receiving Email Notifications Of Posts
Apr 9, 2013I don't appear to be getting any email notifications of posts in threads to which I have subscribed.I have Instant in my profile/userCP, but have not been receiving emails for some time. I edited my preferences today again -- I set it to daily, saved, then reset to instant, and saved. Thought that the edit may tweak some anomaly???
View 3 Replies View RelatedAccess 2000 Security - Authenticate With Windows 2000 Server Credentials
Oct 24, 2005Hi
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
chris@ctbjs.co.uk
many thanks
Chris
Opening & Closing Excel 2000 Workbooks From Access 2000
Jun 2, 2006I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
Any help most appreciated.
Dalien51
Link/Transfer Data From Access 2000 To Excel 2000
Mar 27, 2006If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
Please help...Thank you so much....
Access 2000 & MSSQL 2000 Multiuser Problems
Aug 20, 2007Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
Replication Between SQL Server 2000 And MS Access 2000.
Nov 15, 2006Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?
Thank you in advance.
97 To 2000
Aug 18, 2005I had converted a Access (shared) DB from 97 to 2000. Now when more then one person open it it tells the others that it has been opened in an admin state denying the other users the ability to open. I checked the options and toggled back and forth to exclusive and back to shared, with no luck. Any ideas?
View 1 Replies View RelatedUse Bot 2000 And 2003
May 8, 2005I just got a new machine with office 2003 but it doesn't include ms access. Can I use access2k with this new version of office?? so I can do reports and put them into word etc??
View 2 Replies View RelatedConvertin From 97 To 2000
Sep 14, 2005I created a db in access 97. It has tabkes, queries, forms, modules and reports
Now i am trying to convert it into access 2000 but .... thats why i am here.
Here is what i am doing:
1- open access 2000
2- go to tools, db utilities, convert db to 2002
3- select the access 97 db
After that access 2000 starts to make the convertion and at the end it display an error like:
"Microsoft Access has encountered a problem and needs
to close. we are sorry for the inconvenience."
Also gives me the option to repair the db and restart access.
Any clue about the problem? thx, Max.
Access 2000
Dec 20, 2007can an Access 2000 Db be accessed over the internet??
If so, is this done often???
Access 2000
Jan 25, 2008Hi all,
At the moment the company Im with uses Access 2000, however ive been told by a few people that Access 2000 had alot of issues and it would be worth informing the company to upgrade to 2003 asap. Is there any major concerns with 2000? Some of the databases currently being used are very large and complex. Any chance data could be lost/displayed incorrectly? etc
Thanks for any input
Using 2000 Can I Do This Without VB Knowledge?
Dec 9, 2007:confused:I have created a small DB to keep track of meetings.
Main Form customer
Sub form meetings with customer
At the end of each meeting I make notes on the sub form and enter an agreed date for next meeting.
Q 1.
I would like the sub form to open at new record, or last record and with the agreed meeting date CARRIED OVER to the new record form. Have unsuccessfully tried (among many) DoCmd.GoToRecord , , acNewRec
Q 2
I love the idea of having a sub form, but am unsure when creating reports how to ask for information from “last record”.
thanks have spent hours looking thru messages and closest I found was Dmax but not sure how or where to find/use this.
MS Access 2000
Jul 22, 2003I'm new to MS Access. I want to know about compressed/reindexed databases.
What happens when a database is compressed?
What happens when a database is reindexed?
Why is it important to periodically compress and reindex a database?
I have records in the database that I need to pull up by local time zones, what would be the most effective way to do this?
Need Access 2000 Help
May 12, 2006I have a form that submits to an access database which has auto number enabled.. Trouble is that some of the submissions are missing and the database skips an ID number.
View 1 Replies View RelatedAccess 2000 To 2002
Jul 8, 2005I need to develop an application that works in 2002. I tried to take a 2002 mdb, convert in 2002 to 2000 and try it on my machine at home. It didn't work and I couldn't find the missing reference. I then took an mdb that was originally a 2000 format, converted it to 2002 and it worked fine. So what I want to do is develop the app in 2000 and just convert it over to 2002. This allows me to work on it from home which is pretty important since my deadline is creeping closer. Am I ok doing this or am I courting disaster? Or is there another way of doing this?
scratch
Users In Access 2000
Aug 16, 2005Is there a way in Access 2000 that I can set up a users table? Basic info:
Name
Phone Number
Fax Number
Then every time the database is opened they are prompted for their name?
I have a database that has a Fax Cover Sheet within the DB, when they click the Fax Cover Sheet Form I want their information to automatically be generated into the form based on the information from the original table.
Hope this is clear. Thanks.
Travis
Access 2000 To 2003
Aug 26, 2005How unusual is it for a database to become MUCH smaller when converting it from 2000 to 2003 formats. I mean 600megs to 10 megs. And as far as I can tell all the records are intact....!
View 1 Replies View Related