syntax error = please help

  • Thread starter Thread starter heather
  • Start date Start date
H

heather

I have bought some software and it requires access 2000 or 97 to run..
We had 2003 running on all the pcs already with xp OS so we realized
we would have to downgrade access..
to make a long story short after the downgrade when we try to run the
program we get a error msg stating

"there was an error compiling this function. the visual basic module
contains a syntax error. check the code and then recompile it"

If anyone can give me a clue I would surely appreciate it. Access is
not one of my strenghts that is for sure.

I should also note that on a pc that had an old version of office 2k
installed and running xp OS .. The software ran fine.


Thanks in advance to anyone.

Heather
 
You probably could have gotten by without "down grading" Access. The new
version should have been able to read the old file. You may want to try it
on one machine to see if it works.

For the error you're receiving, when you've been doing conversions such as
this, it is usually a References error. Here is some more information on
that.

http://members.iinet.net.au/~allenbrowne/ser-38.html
 
Thanks for the info. I tried a few things and still no luck. I also
forgot to note that it does not work on a machine with 03 that has
never been downgraded. The only way i had it working was on a machine
that only had access 2000 installed. If there are any more ideas
please let me know.

thanks
 
Try also Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

I think the best bet is to go back to whoever you got the software from. It
is possible that the code for the software (in whatever the programming
language it was written) works with older versions of DAO/ADO/MDAC but not
the later versions.

Note that it sounds like you the software you bought simply uses a JET
database, not an Access database to store data and you are not really using
Access at all. However, Access, the software you bought as well as other
software may use the shared Libraries such as DAO, ADO, etc...
 
Below is my original post. I paid about 500 bucks for this database
and my boss is freaking at this point since I can not reach the
writers for over a week now and I was supposed to have this database
working and saving the company time. I'm willing to post the files to
a binary group if someone is willing to help me get this working. Any
ideas please share!!

Thanks for reading
 
What kind of software is it that you bought? Was it customized or did
you buy it somewhere? What is the size of this database?
 
It is a database used for auditing lighting. Its under 6 megs I think.
It wasn't customized yet since I can't get it to run to see what i
would need to change.
 
Back
Top