Recent content by sandingdude

M8KWR I am having some problems and need some assistance. I don't have a SQL backend. We have the Goldmine database files on a file server. I am trying to create the DSN File on a workstation where I have the MS Access Report Writer I created and I receive the following error: You cannot use...

M8KWR Thanks for all your help. I am having some issues. Any suggestions on linking the tables. I keep getting an error saying some user and some unknown computer is connected to the database. Any advice?

Can anyone tell me how to setup an ODBC connection and what Goldmine tables to connect to use Access as a Report Writer for GM. I want to use MS Access to pull data from Goldmine to run a report based off of the contact and contact history database. I have imported the tables into Access...

Hi Doug I wrote some custom reports in Access and I want to pull data from Goldmine into Access to run the report. I want live data written in one direction. I don't want to go through the trouble of manually importing the data rather just connect to the GM database and pull the data. Any...

Hi Chad Thanks for the email. I'm not connecting to the wrong database. I connected to the Contact1 database, which is several hundred megabytes. Any ideas? Thanks, Dave

I have over 10 VPN coonnections and I want to export them to another computer. Any ideas on how to do this? Thanks, Dave

What is the max backup size to a file using Windows backup in Windows 2003 Small Business? thx

I have a problem with my ODBC connection that I created for Goldmine. It only brought over 1 record. Any ideas? Thank you in advance. Dave

Hi Deborah I hope you had a nice holiday. I started playing around with your instructions which worked very well. I was able to connect to the GM database, but I have a problem. It only brings 1 record into my spreadsheet. Any ideas? Thanks, Dave

I want to thank everyone for their help. I will go ahead and try everything you suggested. Deborah - I'm having trouble with Access seeing the Goldmine Date as a Date. So when I run a filter I get records outside of my date range. I have that post titled: Date Filter in Query not working...

Hi Deborah Thanks for your advice. Can you tell me how to create an ODBC connection for Goldmine? Thank you in advance. Dave

Thanks for the tips guys. DataDiva they doen't want to purcahse anymore software. Hap how do you put Access in Exclusive mode? And is there any way for me to prevent users from writing back data to access? I want one direction read only access. Thanks, Dave

Skip I figured out why the date filter was not working correctly. It was becase I had other criteria specified in another field to filter "ES" and "NS". This creates another problem for me. Because I am trying to filter new sales and existing sales when I specify the dates after the ES and NS...

I have a query that filters certain dates using the command Between [Enter Begin Date] And [Enter End Date]. When I enter the dates to run the filter the query runs, but I have dates outside of the scope. Any ideas? Thank you in advance.

We wrote a MS Access database to create custom reports from the Goldmine 6.0 tables. We did this because it was easier to write the reports in Access than using the Goldmine Report writer. I am running into problems though: -I need to link the tables from Goldmine to MS Access. When I do this I...