G
goofy11
I currently have an Access database that doesn't store any of my data, but
runs a variety of append and make-table queries. The make-table queries are
exported to individual Access databases. The problem I'm running into is
that some of these tables are arriving at the 2GB limit. I'm sure this is
not the most efficient way to do this, but I'm a relative novice in Access
and am brand new to Sequel. I'm now trying to use Sequel to store my large
tables, but remain using the Access database that already has all my queries
set up. I created an ODBC connection to the Sequel server and created a new
Access Database Project in which I imported each of my large Access tables
into my .adp file. In my Access database that has the queries, I updated all
the links to refer to the tables I imported into the new .adp file I created.
I then redirected the make-table query paths to the .adp file as well. I
thought I had everything in place to make it work, but when I kicked off my
macro that begins running all the make-table queries, I got the following
message:
Unrecognized database format 'file path.adp'
Is there any way to get my make-table queries to work using this setup, or
will I have to take a different approach. I'm hoping I won't have to
completely scrap this thing and start from scratch. it took me quite some
time to set up the Access database and get all the queries to work just right.
Any guidance would be appreciated.
Jeff
runs a variety of append and make-table queries. The make-table queries are
exported to individual Access databases. The problem I'm running into is
that some of these tables are arriving at the 2GB limit. I'm sure this is
not the most efficient way to do this, but I'm a relative novice in Access
and am brand new to Sequel. I'm now trying to use Sequel to store my large
tables, but remain using the Access database that already has all my queries
set up. I created an ODBC connection to the Sequel server and created a new
Access Database Project in which I imported each of my large Access tables
into my .adp file. In my Access database that has the queries, I updated all
the links to refer to the tables I imported into the new .adp file I created.
I then redirected the make-table query paths to the .adp file as well. I
thought I had everything in place to make it work, but when I kicked off my
macro that begins running all the make-table queries, I got the following
message:
Unrecognized database format 'file path.adp'
Is there any way to get my make-table queries to work using this setup, or
will I have to take a different approach. I'm hoping I won't have to
completely scrap this thing and start from scratch. it took me quite some
time to set up the Access database and get all the queries to work just right.
Any guidance would be appreciated.
Jeff