Access help!!

[Kidem]

Not sure if this is the right place so let me know!!


My company has a access app that is having a problem, it does a DB for each
year,since its 2006 we need to start a new one!! There is a master one which
i copy and rename to 2006 then im trying to import data from the 2005 one,
when i do i get a error,there telling me its something to do with classes
but im access illertate.if i need to look at classes where do i do this at!!

Sorry if this doesnt make since

Thanks

 

[mscertified]

It would be helpful to post the exact error message text and also to know
what you were importing when the error occured. You can have a class internal
to your Access database or external to it in a DLL.

-Dorian

 

[John Vinson]

Not sure if this is the right place so let me know!!


My company has a access app that is having a problem, it does a DB for each
year,since its 2006 we need to start a new one!!

Bad idea. Storing data - a date - in a database name is EXTREMELY bad
design. A properly designed database will store dates in a date/time
field in a table; you can then use a Query to select data for 2004, or
2005, or 1834 if you wish.

There is a master one which
i copy and rename to 2006 then im trying to import data from the 2005 one,
when i do i get a error,there telling me its something to do with classes
but im access illertate.if i need to look at classes where do i do this at!!

Sorry if this doesnt make since

It doesn't. Could you please post the actual error message?


John W. Vinson[MVP]