•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 374,181 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,402 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 545 | Replies: 3
 |
•
•
Join Date: Jun 2007
Posts: 49
Reputation: 
Rep Power: 2
Solved Threads: 2
Light Poster
I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem to figure out what Access would use. The regular SQL statement throws an error.
Mr.Wobbles~
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,172
Reputation:
Rep Power: 4
Solved Threads: 75
You can try to make a copy of the original MDB file and that can be used as a backup of actual data. The syntaxes of oracle or mysql will not work here.
Share your Knowledge.
•
•
Join Date: Jun 2007
Posts: 49
Reputation:
Rep Power: 2
Solved Threads: 2
Light Poster
I have tried that before but this is my problem with that:
http://www.daniweb.com/forums/thread99598.html
So I was looking to see if there was another way -- I have had this problem for a long time...
http://www.daniweb.com/forums/thread99598.html
So I was looking to see if there was another way -- I have had this problem for a long time...
Mr.Wobbles~
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 263
VBA can do file I/O
Last edited by jbennet : Feb 26th, 2008 at 1:31 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
access ajax asp code combo data database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development dropdownlist hacker how to restrict access to a specific file ip management studio 2005 microshaft microsoft module ms msdn net news office reuse security software sql sql cache dependency with polling-based invalidation survey vista web
- Expression Builder and using SQL in MS Access (MS Access and FileMaker Pro)
- MS Access 2000 - Inserting records in a new table by joining input from two tables (Visual Basic 4 / 5 / 6)
- SQL SERVER 2000 Selecting a record based on an aggregate function (MS SQL)
- PHP / My SQL Web developer (Web Development Job Offers)
- Project using access with VB4 (Visual Basic 4 / 5 / 6)
- Sybase SQL Anywhere versus Microsoft Access (Database Design)
- Frontend HTML, Backend MS Access Database?? (Database Design)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
- HELP! Need someone that Knows SQL to tell Me How to Access a Primary Key (C)
- what is the best book to learn SQL fast and quick (MS SQL)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: difference in years between two dates (FileMaker Pro 9)
- Next Thread: Help in tables
