I have an Access 97 program that for many years linked to tables in another
database through drive letter access.  Recently, because of speed, we
converted the Access tables to a SQL Server 2000 database and linked the
tables via an ODBC connection.

I'm using Microsoft Office 2003 Professional.  I've built an Access 2003
database application and used the Tools, Database Utilities, Make MDE to
create a *.mde file of my *.mdb file.   The compile or build worked fine.  I
can open the MDE on my machine and it works fine, but ...

G'day all
I haven't made the jump to XP yet & still use my ever reliable and trusty
Acc97. I did a DB for a friend, who just happens to run OffXP (which is
fine), anyways, everything converted fine, except for the annoying popup

I am developing in access 2002 on a win98 2nd edition machine. When I
transfer my database to a Windows XP Professional Machine running Access 2002
I encounter errors. For Example the code:
SQLStmt = "SELECT * FROM [GL Transactions] WHERE Left([GL ID],6) = '" & Temp

I recently converted an application from an .mdb to a .mdb with linked
tables (SQL Server).  On my main form, I have several subforms.  These
subforms show up fine when I'm dealing with existing records, however when I
add a new record to the form, the subforms disappear.  Any ...

i have an update querry that should pull number out of a string.the strings
are standardized(same). i thought it would be good to pull out the start
position of the nummber and the end position of the number.
here is the code for start position:

I am trying to upsize my Access 97 database to SQL 2000 using the
Upsizing Wizard. I keep getting overflow errors, even on an empty
database. I followed the steps in Article 165827 and it made no
difference. I can transfer the files using DTS, but I want the indexing,

Will be converting to Access 2003 from Access 2000 soon.  Have several large
databases.  Any known issues I should be aware of??
Thanks!

Sorry if this isn't the correct group - suggestions welcome.  Let me preface
by saying I'm not an access guru.  Did try doing some searches but came up
with nothing.  Will be using AccessXP on Novell server.  Is this possible
with with host script file or should I use DTS to read ...

Using a brand-new database and any .xls, csv or .txt file, I get this
message.  I am using Access 2003 with SP1.  
Interestinly, if I use Access 2000 from another machine the import operation
works great using the same DB and spreadsheet.  I can also import .mdb

Error message:
Unrecongnized database format then the file extension.
I need to work on a homework assignment and 97 is the only program I can get
to. I did the begining of it on a computer at school which has Access

When I open an Access 2000 database in Access 2003, my linked table manager
shows a blank window even though I have linked tables which are corrcectly
indicated in the table view. What's up ???

I'm new to this conversion process, so bear with me a little bit.  I have
an Access97 database and am looking to convert it to 2003.  I've done the
convert step listed under the utilities.  Problem is, is that the data
source that was used for that database is no longer valid.  All ...

I recently upsized a database using the upsizing wizard (went from a local
.mdb to a .mdb with linked tables on SQL Server).  I am unable to upload 2
of the tables.  One table says error 156: Incorrect syntax near the keyword
'ESCAPE', the other just says skipping table... (no ...

Is there a way to convert MDE to MDB?
Regards,