Has anyone had any problems with Access and Goldmine running at the same time. When I am in Access working on my program, I will tell it to save and not always, but once in a while (every 3 days) it will say it can't save the record and then all these Goldmine messages start coming up that this file is locked and that file is locked, etc. This has also caused my Access db to become corrupt quite frequently. I end up having to close Access and lose my work. Is there a setting in Goldmine I need to fix? All my Microsoft programs are up to date. I am using XP, Goldmine 5.7, and Office 2002 on a Novell server. Thanks for any ideas or help, Janet Lyn
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Compatibility 2
- Thread starter janetlyn
- Start date
-
1
- #2
TheIntWizard
Programmer
First of all - you aren't using Access to change your GoldMine .dbf files, correct?
The Wizard
Home of Link Magic and Web Magik
The Wizard
Home of Link Magic and Web Magik
- Thread starter
- #3
Not on purpose. Although I am the one who is "all-knowing" about Goldmine (yeah right), I really don't know much about it at all. I didn't even know Goldmine had .dbf files. It has caused me to have rename the license file a couple times though. JL
TheIntWizard
Programmer
It sounds to me, then, like the DNS for .dbf files is set to the Access driver, or vice-versa, in your ODBC
If that sounds like a lot of letters and no meaning to you, then you likely can't fix it on your own. Essentially, there is a way that Windows knows what to do when it sees a certain type of database file, and there is something in there telling it to do the wrong thing.
I would pack and rebuild GM and then tell someone who fixes GM for a living about this and get then to check your drivers in ODBC, or buy a book about ODBC and fix it (which would be good knowledge for you
The Wizard
Home of Link Magic and Web Magik
If that sounds like a lot of letters and no meaning to you, then you likely can't fix it on your own. Essentially, there is a way that Windows knows what to do when it sees a certain type of database file, and there is something in there telling it to do the wrong thing.
I would pack and rebuild GM and then tell someone who fixes GM for a living about this and get then to check your drivers in ODBC, or buy a book about ODBC and fix it (which would be good knowledge for you
The Wizard
Home of Link Magic and Web Magik
- Thread starter
- #5
Your absolutely right. I never was very good with acronyms or whatever they are called. However, I would like to know what ODBC stands for if you do not mind; I don't think it stands for overdrive-blind copy. HAHA. Thanks for your help wizard. Janet Lyn
-
1
- #6
Janet, could you post the contents of your Help|About|System screen for us? There's a handy COPY button there that will let you copy it all to your clipboard. Feel free to blank the serial number, but I'm interested to see your common files and GoldMine files entries. I hope you're not trying to use an ACCESS ODBE (open database connectivity) source as your GoldMine database (as many folks have, over the past many years expressed an unexplainable desire to do)...
Doug Castell
Computer Control Corp
(310)396-6811
Doug Castell
Computer Control Corp
(310)396-6811
- Thread starter
- #7
Doug, I have no idea what you are talking about "connectivity"-wise, but here is the info. If you can help, I would appreciate it.
Product = GoldMine® Business Contact Manager Edition
License =
Versions = GoldMine 5.70.20404, BDE 500 [4/11/1999], Windows NT 5.01.2600 Service Pack 1
GoldMine EXE = g:\grpware\goldmine\gmw5.exe
BDE DLL Files = g:\grpware\goldmine\setup\bdeshare
TEMP Directory = c:\docume~1\jdickson\locals~1\tempSystem Files = g:\grpware\goldmineGoldMine Files = g:\grpware\goldmine\GMBaseContact Files = \\MIDWEST_FS1\SYS\grpware\goldmine\mepFree Disk Space = G: 3,447 MB, \\MIDWEST_FS1\SYS: 3,447 MB, C: 71,144 MB
Memory (RAM) = 523 MB
Open Cursors = 29
Logged User = JDICKSON [Master!]
CAL LangDriver = DBWINUS0 [New RecID]
Contact1 LangDriver = DBWINUS0 [New RecID]
Tx32 version = 801
Janet Lyn
Product = GoldMine® Business Contact Manager Edition
License =
Versions = GoldMine 5.70.20404, BDE 500 [4/11/1999], Windows NT 5.01.2600 Service Pack 1
GoldMine EXE = g:\grpware\goldmine\gmw5.exe
BDE DLL Files = g:\grpware\goldmine\setup\bdeshare
TEMP Directory = c:\docume~1\jdickson\locals~1\tempSystem Files = g:\grpware\goldmineGoldMine Files = g:\grpware\goldmine\GMBaseContact Files = \\MIDWEST_FS1\SYS\grpware\goldmine\mepFree Disk Space = G: 3,447 MB, \\MIDWEST_FS1\SYS: 3,447 MB, C: 71,144 MB
Memory (RAM) = 523 MB
Open Cursors = 29
Logged User = JDICKSON [Master!]
CAL LangDriver = DBWINUS0 [New RecID]
Contact1 LangDriver = DBWINUS0 [New RecID]
Tx32 version = 801
Janet Lyn
It's possible that your Novell network driver is at fault here and with GoldMine AND Access open, it's losing proper connectivity to your server.. There are knows issues with Novell and dBase (and Access) databases and the tendency for them to become corrupted when using the Novell network driver with the out-of-the-box settings. IT could be that having the TWO programs open is stressing things just enough to cause problems.. Check out this document: ftp://66.116.79.99/factsbacks/348.pdf
Doug Castell
Computer Control Corp
(310)396-6811
Doug Castell
Computer Control Corp
(310)396-6811
- Thread starter
- #9
Doug, thank you. I will have the guy we hire to come fix our computers look at the document and see if it can be fixed. I can do everything with our computers except fix the server. Thanks for taking the time to help me and for the reference document. Janet Lyn
- Status
Similar threads
- Locked
- Question