Search results for query: *

Hello, Although I've used FoxPro on and off since the first multi-user version first came out, It's been years since I've worked using VFP7 except for some basic maintenance and reports as needed. I could really use a little advice on documenting an old system which was originally developed by...

Thanks for the reply. The database is secured and there are no queries or reports - just the tables. The querying is done from VB but they're a wee bit bloated: "Select * From Clients Where LName = 'Smith'" I'm guessing there are well over a 100 fields in this table alone so this is an...

That is actually how it was initially set up but now, the number of concurrent users has grown to about 45 on at a time. I'm not sure but I suspect that the record locking on this one mdw file may be what's dragging the entire system down. Dave

Hello eyeswideclosed, I think your earlier post, "After the first db is open, reset the dbengine.systemdb to use the 2nd mdw and open the second db? ", may be the only potential solution besides going to an ODBC connection for the second database. I hope that once a database has been opened...

I'm trying to lighten the load - we've had an influx of new users and there are some problems with communications between buildings so I was trying to move the common reference tables to the user's local database that they currently use for processing purposes. Both the server's master...

Looking at the documentation, I'm not sure that I can instantiate two of the DBEngine.SystemDB objects at the same time. The code for the master database on the server is as follows- 'Workgroup Administaration file on network DBEngine.SystemDB = mstrAppPath & "\CMT.mdw" Set mwsW2W =...

Looking at the documentation, I'm not sure that I can instantiate two of the DBEngine.SystemDB objects at the same time. The code for the master database on the server is as follows- 'Workgroup Administaration file on network DBEngine.SystemDB = mstrAppPath & "\CMT.mdw" Set mwsW2W =...

Thanks for the confirmation. The app is too darn big to rewrite... this one falls under the category of just trying to keep it breathing at this point. BTW - I've got a '77 Bob Weir Model with the Tree of Life inlay up the neck and to the top of the headstock. It's got the "Professional"...

Hello, I am revamping a VB6 system using Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can I...

Hello, I am revamping a VB6 system that uses Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can...

Hello, I am revamping a VB6 system using Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can I...

Hello, I Need To Purchase A 3rd Party Grid OCX similar to the DBGrid that shipped with VB6. I'm working on an old VB6 (SP5) app with DAO (3.6) and a secured (.mdw) Access 2000 database. The only requirement is that the grid must be able to display checkboxes for boolean fields. Ideally, it...

Interesting workaround - thank you gentlemen. Dave

Hello, I am working on a project in VB6 (SP5) which uses DAO and Access databases. Can anyone tell me if the check box can be made to appear as a cell in the DBGrid control? If not, is there a way to build such a control in VB6? Any code snippets, sites or suggestions would be greatly...

Greetings and Slautations, I'm having a problem with VFP 7 (SP1) and FoxFix 5.1. I've had people disappearing on searches yet their record is there if I go in and look manually. I have reindexed but this does not fix the problems 100%. My database container (PreScreen.dbc) always scans...

I'm using the database container in VFP 7.0 (SP1) on a Win XP machine. When a user clicks the Exit button on the Client Form, it saves the changes and unloads the form. Is there an indicator or some type of flag available that I can reference which would tell me if a user actually changed...

Hello, I'm faced with the very real possibility that parts of our facility may be jumping onto Microsoft's brand new 64 bit processor O/S bandwagon as it pulls out of the barn. Can anyone tell me: 1) Is VFP 7.0 (or any later versions) a true 32 bit app? 2) Will there be problems running on a...

Thanks Rob, We just lost the top 20% of our workforce to an early retirement package in March. I'm working on another developer's projects trying to troubleshoot some problems. I got an unusual error message about the VFP 7 installation script and it just made me think twice. Thanks Rob

Hello, I'm looking for VFP 6 and 7 developers that have any info on problems and/or issues when installing or running VFP 6 and VFP 7 apps under Win XP's Service Pack 2. Any feedback would be greatly appreciated. Thanks for your time, Dave

Thank you for the posts - I don't think 3 part names were in widespread usage 25 years ago. (Boy do I feel old.) We'll be matching either Case #'s or SSN #'s so the names are really a secondary validation check. Also, these Metafile tables were created back in the days when you were fortunate...