J
John
How do I reconnect a split database in Access 97?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Why would you want to? Even my single-user databases are always split,
because of how much simpler it is to make changes.
If you're determined, though, simply delete all of the linked tables in your
front end, then select File | Get External Data | Import and import each of
the tables into your front end.
because of how much simpler it is to make changes.
If you're determined, though, simply delete all of the linked tables in your
front end, then select File | Get External Data | Import and import each of
the tables into your front end.
J
John
Thanks for the info. I am trying to convert from Acc 97
to 2003 and am having problems converting the separate
files. I thought I should reconnect, compress, convert to
2003, and then re-split.
to 2003 and am having problems converting the separate
files. I thought I should reconnect, compress, convert to
2003, and then re-split.
D
Douglas J. Steele
There's no reason I can think of that you should need to go to that extent.
What error(s) are you encountering trying to convert the split databases?
What error(s) are you encountering trying to convert the split databases?
E
Ernie
-----Original Message-----
Why would you want to? Even my single-user databases are always split,
because of how much simpler it is to make changes.
If you're determined, though, simply delete all of the linked tables in your
front end, then select File | Get External Data | Import and import each of
the tables into your front end.
You can do the same thing in reverse. Open the backend db
and use File / get external data / import and import all
of your forms, queries, reports etc into the backend,
probably without having to delete anything.
Just a thought
D
Douglas J. Steele
Ernie said:You can do the same thing in reverse. Open the backend db
and use File / get external data / import and import all
of your forms, queries, reports etc into the backend,
probably without having to delete anything.
Just a thought
While theoretically that would work, in practice it can introduce problems.
If you've set any non-standard references in your front-end, you wouldn't
get them in the backend that way. If you set start-up properties, you
wouldn't get them in the backend. In most of my databases, there are far
more objects in the frontend than in the backend (although, of course, the
objects in the backend tend to be much larger...)