Search results

Can you make the data type a double? I had a function calculating GPA and it was not rounding correctly because I was using a Single vs. a Double.

Nice Dave! Makes me think of a good one for my customer- Check day of week and compact on friday afternoon.

Worked great. She was able to convert it over. Thanks Parker. I'll see her thursday, maybe I can see how she was pointing to the network .mdw. I don't have 95, so I can test here.

I like the manual method. I would train the 'admin' user to run the compact manually once a week or once a month. Depending on the how large the db grows per day/week/month. Plus, the admin user needs exclusive access. Would this person be the last one logging off everynight? Plus-Plus,Some...

She copied the .db & .mdw, but when she modifies the Admin user priveleges, she sees the changes on the network drive, not her local d: drive. She mentioned she could still see it pointing to the network because when she ran the wizard it showed which file she was joined to. Shouldn't wrkgadm be...

I just received a CD with Office2003 & appology letter from microsoft for the problem with VSTO & moving from Office 2003 Evaluation to Office 2003. From the letter: "...We recently discovered two issues that can prevent installation of VSTO [Visual Studio Tools for Microsoft Office System]...

Add the extra notes table. You have a claim tracking system, why not give the users the power to lookup what other users thought or why they entered the info. You have this ability with Siebel or other CRM applications :) Plus - all the more reason your database will become the "one stop answer...

Thanks Parker & Doc_Man. Just curious if you know how/where access95 points to the mdw file? Even with a wrkgadm join, my client still points to the network drive. She wanted to work on the database locally, but can not unlink the network mdw file from the database. Once she gets both the...

To close out this thread- Maybe it could help someone out there :) The problem was with a novell network parameter limiting the number of locks a user can have. The novell admin increased the number of locks and everything works fine.

Jon, I would be interested. Thanks -Norm.

At my client's site they have access95 running on some client pcs. They tried to open/convert it to 2000, but received an error message. We tried to move the database and open up privileges, but it still points to the g:\users.mdw file, not our new d:\users.mdw file. Where do you change the...

This one will stump you! I don't think there is a way to fix this problem! Help! I have a database and made some changes to queries, forms, reports, and vb public module. The easiest way for me to move it into production is to simply rename the old objects and import the new ones. (Yes I know I...

Truly annoying. I can't update records because another user has one record locked. :mad: Does Access 2002 hang on update queries? Or does it provide at least an error message such as "record not updated due to lock". Even a timeout message is better than using the task manager to kill off...

Does this error occur with Access 2002/2003? Other Instances of Access Hang When One User Has a Table Locked Background: The access db is on a network drive. I ran an update query and need to use the task manager to kill the process. Shouldn't the query timeout...or continue to try the update...

Jon- Any upate on your thoughts of sharing equiries? Any target date on when this may happen? Thanks -Norm.

Mitch- Thanks for the advice. I did not see any lock files, but I did notice numerous msaccess.exe processes running. This may be an Office2kSP-3 bug. I dunno. Seems suspect. I am running Windows2k & Access2k

DocMan - I did exactly as you said. And still get the exclussive lock error. Although I did move Admin back into the Admins group because I accidently removed administer rights from Users but did not First give administer rights to "newadmin". There is a benefit to being able to bring Admin back...

I tried a simple test-- A new db with default Admins and Users group. No problem opening the db between two computers and able to create new forms or queries while the other is browsing. I added a user called "testread" to the Users group. No problem modifying objects (as long as the other user...

I read numerous threads on the "You do not have exclusive access to the database..." error and have a few questions: I do not want to split the db for the five users. If I set the users group to read/run access for forms and queries I should never get this error message when I log in as Admin...

How can I get a continuous subform to stay on the current record? When my afterupdate code runs a Requery on a field on a main form, the cursor moves to the next field on the subform but jumps to the first record in the recordset. The requery is resetting the subforms recordset. As an...