Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2003-02-10 : 07:48:53
|
| We have an Access97 DB that we need to give to someone who only has Access2K. Obviously she gets prompted to convert. We need the DB back when she has finished entering data in a month or so to compile results from. Is there anyway of easily getting it back into Access97 format ? We only need the tables back.I'm not sure this is very straight forward as i think Access2K was an extensive re-write.I was perhaps thinking of converting it to SQL Server (which we have got) tables , and working off those, but we need it to be portable. There are autonumber fields in it.Any ideas ? thanks===========Paul |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-02-10 : 09:21:37
|
| If all she is doing is entering data, then no conversion is needed (choose no when prompted). If she is editing the database, then that won't work. |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-10 : 09:34:41
|
| That sounds perfect....................Except it won't let her do it. She is getting some permission problems when she tries either to convert or open ?? We have not set up any permissioning within it ??===========PaulEdited by - KnooKie on 02/11/2003 06:29:33 |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-02-11 : 18:23:04
|
| Give her two databases, one with the GUI (which she can convert) with linked tables to the other (which just has the tables) - the data mdb can stay Acc97.You should have no troubles with that...You'll need to write some code to relink the tables automatically - but that's pretty straight forward.Then she can just send back the data mdb.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-02-11 : 18:38:47
|
| ...or you can move the data permanently to SQL server and use Access 97/2000/XP front-ends with linked tables. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-02-11 : 18:55:56
|
| but then you won't be able to send the data back and forth as a single file quite so easily....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-12 : 05:31:03
|
| thanks for the replies.we've solved the problem, she was logging into her machine incorrectly !?!? The accessDB uses the currentuser object library function to grab the machine login name and compare with a user table. Hence the permission problem.she only needs to input the data initially. once she's done that she can send back a copy to us and THEN convert the one on her machine to query it or whatever she needs to do.thanks again===========Paul |
|
|
|
|
|
|
converting Access2K to Access97