467,169 Members | 994 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

Old computer to new - problems with transferring Access data

I've bought a new laptop (running Windows XP home edition) to replace my old
one (running Windows 98). I don't have cable connection between the two
computers, so I've transferred most of the files between the two using RW
disk.

I'm membership secretary for a charity (1300 members), with another smaller
group (25 members), both using Access from MS Office 2000 Premium edition.

On the new computer the small Db works fine, address labels print out fine,
but the larger Db has problems. When clicking 'print single address label'
(and other similar labels) I get a notice asking for 'Trim'. When I ignore
this (because I don't know what it's asking for, never had this before!), it
opens the label with 'Error' instead of the data on each line.

I've tried deleting my transferred files and starting again, but the same
problem appears. I doubt there's a problem with Access programme itself, as
the small Db works fine, using the same programme.

I've checked the properties of the address labels in each Db, and they're
both identical as far as I can see.

Any ideas how I can solve this problem?

I've been told the best solution is to get a direct cable connection (??),
wipe the new computer back to manufacturer's specs, and start again, sending
everything over by cable. If this is the solution, any tips about how to go
about this, what to buy, etc.

I'm anxious to get back to work!

Thanks in advance

I. Kargar
db*****@radmid.demon.co.uk

Nov 12 '05 #1
  • viewed: 2617
Share:
6 Replies
I'd say the problem is likely a References issue. Open any module in the
database in design view, and on the module window's menu, Tools |
References. Look for any marked "missing" and uncheck them. Close Access,
reopen and if you still have problems, go back into References and check the
ones you unchecked. You may have to browse to find the particular library,
but not always.

It'll certainly be less expensive than some hokey cable arrangement that
likely will not solve the problem anyway. Chances are very low that it was
an issue with the actual transfer of the data. It is always best to
determine what the problem is before rushing to apply a solution --
especially if it is a solution that will cost you.

Larry Linson
Microsoft Access MVP
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bp*******************@news.demon.co.uk...
I've bought a new laptop (running Windows XP home edition) to replace my old one (running Windows 98). I don't have cable connection between the two
computers, so I've transferred most of the files between the two using RW
disk.

I'm membership secretary for a charity (1300 members), with another smaller group (25 members), both using Access from MS Office 2000 Premium edition.

On the new computer the small Db works fine, address labels print out fine, but the larger Db has problems. When clicking 'print single address label' (and other similar labels) I get a notice asking for 'Trim'. When I ignore this (because I don't know what it's asking for, never had this before!), it opens the label with 'Error' instead of the data on each line.

I've tried deleting my transferred files and starting again, but the same
problem appears. I doubt there's a problem with Access programme itself, as the small Db works fine, using the same programme.

I've checked the properties of the address labels in each Db, and they're
both identical as far as I can see.

Any ideas how I can solve this problem?

I've been told the best solution is to get a direct cable connection (??),
wipe the new computer back to manufacturer's specs, and start again, sending everything over by cable. If this is the solution, any tips about how to go about this, what to buy, etc.

I'm anxious to get back to work!

Thanks in advance

I. Kargar
db*****@radmid.demon.co.uk


Nov 12 '05 #2
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message news:<bp*******************@news.demon.co.uk>...
I've bought a new laptop (running Windows XP home edition) to replace my old
one (running Windows 98). I don't have cable connection between the two
computers, so I've transferred most of the files between the two using RW
disk.

I'm membership secretary for a charity (1300 members), with another smaller
group (25 members), both using Access from MS Office 2000 Premium edition.

On the new computer the small Db works fine, address labels print out fine,
but the larger Db has problems. When clicking 'print single address label'
(and other similar labels) I get a notice asking for 'Trim'. When I ignore
this (because I don't know what it's asking for, never had this before!), it
opens the label with 'Error' instead of the data on each line.

I've tried deleting my transferred files and starting again, but the same
problem appears. I doubt there's a problem with Access programme itself, as
the small Db works fine, using the same programme.

I've checked the properties of the address labels in each Db, and they're
both identical as far as I can see.

Any ideas how I can solve this problem?

I've been told the best solution is to get a direct cable connection (??),
wipe the new computer back to manufacturer's specs, and start again, sending
everything over by cable. If this is the solution, any tips about how to go
about this, what to buy, etc.

I'm anxious to get back to work!

Thanks in advance

I. Kargar
db*****@radmid.demon.co.uk

ishbel,

if the access mdb-file is opened and you van reach the database-window
to select reports, modules etc. try to open an existing module or
create a new one if no one exists. Then open the debug-menu and try to
compile the database. If it compiles OK you probably got rid of the
problem. Otherwise check the tools-references menu and check for
missing libraries. the trim-function is in the standard VBA-library,
but when the database is not compiled again on a new access
environment it is possible the VBA-trim-function in a report or query
won't work. Compliation refreshes the standard library-references,
thats probably the cause of your problem.

Marc

Marc.
Nov 12 '05 #3
I've found that this sometimes relates to a change in the location of the
utility.mda file. However, I think that if you delete the reference instead
of relocating it, the application will work fine.

Any other confirmation that Utility.mda is not required in A2K and above?

tim mills-groninger

"Larry Linson" <bo*****@localhost.not> wrote in message
news:24******************@nwrddc01.gnilink.net...
I'd say the problem is likely a References issue. Open any module in the
database in design view, and on the module window's menu, Tools |
References. Look for any marked "missing" and uncheck them. Close Access,
reopen and if you still have problems, go back into References and check the ones you unchecked. You may have to browse to find the particular library,
but not always. .... Larry Linson
Microsoft Access MVP
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bp*******************@news.demon.co.uk...
I've bought a new laptop (running Windows XP home edition) to replace my

old
one (running Windows 98). I don't have cable connection between the two
computers, so I've transferred most of the files between the two using RW disk.

... When clicking 'print single address label'
(and other similar labels) I get a notice asking for 'Trim'. When I ignore this (because I don't know what it's asking for, never had this before!), it opens the label with 'Error' instead of the data on each line.

....
Nov 12 '05 #4
Many thanks Larry. The labels are printing out properly now. So I can now
tackle the back-log of work!

Ishbel

Nov 12 '05 #5
Thanks Tim.

I've filed your suggestion in case I have any further problems.

Ishbel
Nov 12 '05 #6
Many thanks Marc

Larry's instructions helped me to solve the initial problem. However, I'm
keeping the other responses on file for future reference, you never know
when things are going to go pear-shaped!

thanks again

Ishbel
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ebbie | last post: by
1 post views Thread by Asaf | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.