How can I use a US Access file on an Australian Computer?

A

aubdreamsbig

I have created a file in Access on my US computer and I need to be able to
use, edit, and store the file on both my computer and an Australian computer
(I am now in Australia). I was wondering if there was a way I could do this
or if I can't switch between the two regions.

Thanks everyone!
 
N

Nikos Yannacopoulos

My guess is the only type of problem you may have is related to date
format, if the (date) regional settings on your AU PC are European
(day/month/year) like I think you also use down there. You have two
options: (a) change the date settings to US, which of course will affect
every app on your computer, or (b) take some extra measures in your app
do make it format-independent, which I believe needs only be done in any
VBA procedures handling dates. If you have no code at all (or none that
handles dates) there's a very good chance you need do nothing at all.

HTH,
Nikos
 
A

aubdreamsbig

I just tried to open the file on an australian computer today and it opens up
as a "read-only" file - is there a way to get around this?
 
N

Nikos Yannacopoulos

Well, that's an altogether different issue. My best guess is the user
did not have write access to the folder the database was opened in, so
Access could not create a lock file. Any chance you opened it form a CD-ROM?

Nikos
 
N

Nikos Yannacopoulos

That explains why you could open the database read-only: Access was
unable to write on the CD, when it tried to create the lock file. Copy
the database file to the HDD nd try opening it from there.

Nikos
 
A

Alex White MCDBA MCSE

And take the read-only attributes of the copied file, right mouse click on
the copied file, down to properties, un-check read-only near the bottom of
page.
 
Top