Access 97 issues

[Johnny37]

I'm having problems with two PC's not being able to perform certain routines in MS Access.

OS is Windows XP PRO
Access 97

The error on one PC happens when exporting Access tables, and states that "ActiveX can't create object".

The other PC in question doesn't have file type Excel as an option for Importing files.

Any pointers would be greatly appreciated.

Johnny

 

[Trevil]

It kinda sounds like an issue with the options used at install time. If I'm not mistaken, when you initially do an install, certain features (or add-in's / wizards) are installed by default. Some others you need to explicity specify. Try running the install for Access again and see if you can select additional components. I have found it necessary in the past to go back and add items, but now I just select EVERYTHING. I know there are optional components that deal with certain format (i.e. dBase, Excel, etc.)

I have Access 97, 2000 and XP all running on my Win-XP box without a problem. If above doesn't work -- and you are running code -- maybe you're missing a required reference?

35+ years of 'progress' -- can't we all just go wire boards again?

 

[av8tar]

Reregister dao350.dll
See

http://www.mvps.org/access/bugs/bugs0007.htm

Cheers
Brian

 

[Johnny37]

Trevil & Av8tar,

Thanks very much for replying. Sorry for not contacting you sooner. I will try both fixes tomorrow and let you know.

All the very best

Johnny

 

[Johnny37]

Success Brian - Thanks very much indeed.

Trevil - I followed your instructions yet the reinstall still does not load the Excel option. I've checked other PCs and they have this option. I shall keep plugging away!!! Thanks a lot Trevil.


Cheers lads

Johnny

 

[Trevil]

Hi Johnny,

The following link should solve the problem where you don't see Excel as an import option:

http://support.microsoft.com/default.aspx?scid=kb;en-us;171955

ACC97: Certain ISAM Drivers Not Appearing in Files Of Type Box

Good Luck,
Wayne

Code: Where the vision is often rudely introduced to reality!

 

[Johnny37]

Hi Wayne,

Again, Thanks a lot - I will give it a try and update you today or tomorrow.

All the very best

Johnny